Search 82,143 tutors
FIND TUTORS
Ask a question
0 0

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 systolic blood pressure levels
The Hypothesis test:
H0: μ123
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 different age categories have different mean blood pressure levels? Give for your decision.


Group 1    Group 2    Group 3    [Place your Anova table here]
   104           97            123
   106           116          107       Anova: Single Factor
   104           98            127
   92             95            133      SUMMARY
   112           108          114      Groups    Count    Sum    Average    Variance
   107           106          93        Group 1
                   102          113      Group 2
                   108          114      Group 3
                   94            116
                   100          155
                   101          105       ANOVA
                   119                     Source of Variation    SS    df    MS   F    P-value    F-crit
                   89                       Between Groups
                   113                     Within Groups
                   99
                   93                       Total
                   107
                   125
                   104
                   110
                   124
                   181
                   118
Tutors, please sign in to answer this question.

1 Answer

late to the party! But I think this is what the asker meant for people coming back later.
Anova: Single Factor

SUMMARY
Groups Count Sum Average Variance
group 1 6 625 104.1666667 44.17
group 2 23 2507 109 344.91
group 3 11 1300 118.1818182 267.56


ANOVA
Source of Variation SS df MS F P-value F crit
Between Groups 937.93 2 468.97 1.655 0.205 3.252
Within Groups 10484.47 37 283.36

Total 11422.4 39

 And the P-Value of .205 is greater .05 so I believe we can say with 95% confidence that the populations are different. But I'm not a stats guy so take that with a grain of salt.