What is the best-predicted value for diastolic pressure given that a woman has a systolic level of 100?
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
107
116
181
98
100
127
107
116
97
155
106
110
105
118
133
113
113
107
95
108
114
104
125
"Looking for a Similar Assignment? Order now and Get a Discount!
"Looking for a Similar Assignment? Order now and Get a Discount!
