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?

Choosing Regression Models

For this assignment, download this Excel file and follow along with the questions below. Note that the table for the third question is on the second sheet of the Excel file. Click on the tabs to view the questions:

Assignment 11.1 Excel File (Links to an external site.)

Question 1

Use the table provided for Question 1 in the Excel file and answer the following questions:

1. Using Excel’s trendline feature, find which type of model best fits the data, going by the r-value.
2. Find the equation of the trendline and use it to predict the value of Y corresponding to an X-value of 2.5.

Question 2

Rhudy and France (2007)* studied the relation between obesity and the response to pain. Obesity was measured as the percentage over the ideal weight, and the response to pain as the nociceptive flexion reflex threshold. The results of the study appear in the table, labeled Question 2 in the Excel file. Based on that, answer the following questions:

1. According to the scatter plot, which model explains better the relation of the response to pain on obesity: linear, exponential, quadratic, or logarithmic?
2. According to the best regression model, what is the response to pain expected for a person with obesity of 50%? Is this prediction reliable?
3. According to the best regression model, what is the expected pain threshold for a person with obesity of 4.5%? Is this prediction reliable?

• *Rhudy, J. L., & France, C. R. (2007). Defining the nociceptive flexion reflex (NFR) threshold in human participants: a comparison of different scoring criteria(Links to an external site.). Pain, 128(3), 244–253.

Question 3

In the second sheet of the Excel file, you find a large data set comprised of two columns of data from the famous Framingham Heart Study*. The first column lists the systolic BP of the patients. The second shows a 1 if they developed coronary heart disease within the next ten years and a 0 if they did not.

1. 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?
2. Use the XLMiner app to determine the logistic correlation for the data. Does the p-value suggest a strong or weak correlation?
3. Why do you think that the correlation looks weak in the scatter plot, when in fact the correlation is strong?
4. 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.
5. Use the equation to estimate the probability of a patient developing CHD in the next ten years if their SBP is 133. You may need to use e≈2.718.

• *Mahmood, S. S., Levy, D., Vasan, R. S., & Wang, T. J. (2014). The Framingham Heart Study and the epidemiology of cardiovascular disease: a historical perspective.(Links to an external site.) Lancet, 383(9921), 999–1008.