1. SYSTOLIC BLOOD PRESSURE IN DIFFERENT AGE GROUPS
The following table contains a random sample of 40 women partitioned into three groups: Group 1: 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:
Ho:Pi=1/2=P3
H i: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.
Group 1 |
Group 2 |
Group 3 |
104 |
97 |
123 |
106 |
116 |
107 |
104 |
98 |
127 |
92 |
95 |
133 |
112 |
108 |
114 |
107 |
106 |
93 |
|
102 |
113 |
|
108 |
114 |
|
94 |
116 |
|
100 |
155 |
|
101 |
105 |
|
119 |
|
|
89 |
|
|
113 |
|
|
99 |
|
|
93 |
|
|
107 |
|
|
125 |
|
|
104 |
|
|
110 |
|
|
124 |
|
|
181 |
|
|
118 |
|
SUMMARY |
|
|
|
|
Groups |
Count |
Sum |
Average |
Variance |
Group 1 |
|
|
|
|
Group 2 |
|
|
|
|
Group 3 |
|
|
|
|
ANOVA |
|
|
|
|
|
|
Source of Variation |
SS |
df |
MS |
F |
P-value |
F crit |
Between Groups |
|
|
|
|
|
|
Within Groups |
|
|
|
|
|
|
|
|
|
|
|
|
|
Total |
|
|
|
|
|
|