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

PLDZ-15
In Stock
\$ 15.00 USD
A+ Tutorials
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

Recent Reviews Write a Review
0 0 0 0 reviews