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 |
|
|
|
|
|
|