QUESTION

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

124

92

119

93

106

DIAS

61

64

65

76

58

66

61

41

72

61

56

62

48

62

102

61

53

74

67

71

64

85

59

70

69

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

124

92

119

93

106

DIAS

61

64

65

76

58

66

61

41

72

61

56

62

48

62

102

61

53

74

67

71

64

85

59

70

69

TUTORIAL PREVIEW

HLT 362 M5 Topic Five: Correlation/Regression and Chi Square

Dated: 5th Jun'16 04:30 PM

Tutorial Rating:

Sold **0** times.