HLT-362V Week 5 Correlation/Regression and Chi Square Excel Worksheet
HLT-362V Week 5 Correlation/Regression and Chi Square Excel Worksheet
PLDZ-15
In Stock
Buy and Download >
Description
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
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 t