HLT 362V Week 4 Assignment; ANOVA Excel Worksheet

HLT 362V Applied Statistics for Health Care Professionals – Grand Canyon

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.