Create a scatter plot of the data in Excel. Based on the scatter plot alone, does the correlation between SBP and 10-year CHD appear strong or weak?
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.
Create a scatter plot of the data in Excel. Based on the scatter plot alone, does the 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?