ANOVA Excel Worksheet
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.
Categories: