HLT 362V Module 4 ANOVA Excel Worksheet
HLT 362V Module 4 ANOVA Excel Worksheet
Module 4 ANOVA Excel Worksheet HLT362V
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:
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. Module 4 ANOVA Excel Worksheet