Choosing Regression Models
Using Excel’s trendline feature, find which type of model best fits the data, going by the r-value.
Find the equation of the trendline and use it to predict the value of Y corresponding to an X-value of 2.5.
According to the scatter plot, which model explains better the relation of the response to pain on obesity: linear, exponential, quadratic, or logarithmic?
According to the best regression model, what is the response to pain expected for a person with obesity of 50%? Is this prediction reliable?
According to the best regression model, what is the expected pain threshold for a person with obesity of 4.5%? Is this prediction reliable?
Create a scatter plot of the data in Excel. Based on the scatter plot alone, does the (logistic) correlation between SBP and 10-year CHD appear strong or weak?
Use the XLMiner app to determine the logistic correlation for the data. Does the p-value suggest a strong or weak correlation?
Why do you think that the correlation looks weak in the scatter plot, when in fact the correlation is strong?
Use the output from Excel to determine the equation of the best-fit logistic curve. You may want to revisit the video (Links to an external site.) to see how to do this
