Topic Five: Correlation/Regression and Chi Square Excel Worksheet
Directions: Answer all problems and submit to instructor at the end of Module 5
SYSTOLIC AND DIASTOLIC BLOOD PRESSURE OF FEMALES The following table represents systolic and diastolic blood pressure measurements of 40 females.
A) Use the Excel Analysis ToolPak to find the linear correlation coefficient for the systolic and diastolic measurements. B) Use the Excel Analysis ToolPak to determine the linear regression equation that uses the systolic pressure to predict the diastolic pressure. C) What is the best predicted value for diastolic pressure given that a woman has a systolic level of 100?
SYS 104 99 102 114 94 101 108 104 123 93 89 112
DIAS 61 64 65 76 58 66 61 41 72 61 56 62
A: place correlation table here SYS SYS DIAS 1 0.785369154 DIAS 0.785369154 1
B: place regression equation table here SUMMARY OUTPUT Regression Statistics Multiple R 0.785369154 R Square 0.616804708 Adjusted R Square