HLT-362V Week 4 ANOVA Excel Worksheet

  HLT-362V Week 4 ANOVA Excel Worksheet

Applied Statistics for Health Care Professionals - Analysis of Variance (ANOVA)

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.

Topic 4: ANOVA Excel Worksheet

Directions:  Answer all questions and submit to instructor at the end of Module 4

1. Systolic Blood Pressure in Different Age Groups

the following table contains a random sample of 40 women partitioned into three groups:

Group1 : ages below 20

Group 2: ages 20 through 40

Group 3: ages over 40

The values in the table are the systolic blood pressure levels.

The hypothesis Test:

H0:U1=U2=U3

H1:at least one of the treatment means is different.

Use the Excel Analysis ToolPak to create an Anova-Single Factor Table.

Is there sufficient evidence to support the claim that women in the different age categories have different mean blood pressure levels? Give reasons for your decision.

Statistical Conclusion:

Experimental Conclusion:

Group 1 Group 2 Group 3 [Place your Anova table here]

104 97 123

106 116 107 Anova: Single Factor

104 98 127

92 95 133 SUMMARY

112 108 114 Groups Count Sum Average Variance

107 106 93 Group

1 102 113 Group2

108 114 Group 3

94 116

100 155

101 105 ANOVA

119 Source of Variation SS df MS F

P-value F crit

89 Between Groups

113 Within Groups

99

93 Total

107

125

104

110

124

181

118