HLT-362V Week 5 Correlation/Regression and Chi Square Excel Worksheet

HLT-362V Week 5 Correlation/Regression and Chi Square Excel Worksheet
Applied Statistics for Health Care Professionals - Discovering Relationships and Building Models           
Grand Canyon University      

 
Refer to the "Visual Learner: Statistics" for examples to help complete the problems in the attached worksheet. Also, to aide in the Excel calculations, view the appropriate section of the Excel tutorials. Answer each question completely in the Excel worksheet provided.

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

            
Powered by