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.

Are you exhausted from doing student homework?

Get excellent writing help from academic authors!

Order now