Correlation/Regression and Chi Square Excel Worksheet
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 |
DIAS |
| 104 |
61 |
| 99 |
64 |
| 102 |
65 |
| 114 |
76 |
| 94 |
58 |
| 101 |
66 |
| 108 |
61 |
| 104 |
41 |
| 123 |
72 |
| 93 |
61 |
| 89 |
56 |
| 112 |
62 |
| 107 |
48 |
| 116 |
62 |
| 181 |
102 |
| 98 |
61 |
| 100 |
53 |
| 127 |
74 |
| 107 |
67 |
| 116 |
71 |
| 97 |
64 |
| 155 |
85 |
| 106 |
59 |
| 110 |
70 |
| 105 |
69 |
| 118 |
82 |
| 133 |
83 |
| 113 |
75 |
| 113 |
66 |
| 107 |
67 |
| 95 |
59 |
| 108 |
72 |
| 114 |
79 |
| 104 |
73 |
| 125 |
73 |
| 124 |
85 |
| 92 |
46 |
| 119 |
81 |
| 93 |
64 |
| 106 |
64 |
| A: place correlation table here |
|
|
|
SYS |
DIAS |
|
SYS |
|
|
|
DIAS |
|
|
| B: place regression equation table here |
|
SUMMARY OUTPUT |
|
|
|
|
|
Regression Statistics |
|
Multiple R |
|
|
R Square |
|
|
Adjusted R Square |
|
|
Standard Error |
|
|
Observations |
|
| ANOVA |
|
|
|
|
|
| |
df |
SS |
MS |
F |
Significance F |
| Regression |
|
|
|
|
|
| Residual |
|
|
|
|
|
| Total |
|
|
|
|
|
|
|
|
|
|
|
| |
Coefficients |
Standard Error |
t Stat |
P-value |
Lower 95% |
| Intercept |
|
|
|
|
|
| SYS |
|
|
|
|
|
Type the regression equation:
| C: Predicted diastolic pressure |
Show calculations of predicted diastolic pressure.