Share
Explore BrainMass

Anova Function in Excel to test Hypotheses

I need assistance testing these hypotheses using Anova (Single Factor) in Excel. I need to show what is returned( F-statistic, F critical, and a P-value.) I then need to use these values to reject or accept H0.

I have done this in Excel, but need help making sure my figures are right and determining if I accept or reject HO. Please return a help on making sure these are right and determining if i accept or reject the hypothesis.

My first claim is :

There is no difference between the level of intrinsic job satisfaction for employees in the Human Resource Department than in the Information Technology Department.

The Null hypothesis will be: H0: m1 = m2

Where m1 = mean of response to question 2 for those who fall under category 1 for question 1.
Where m2 = mean of response to question 2 for those who fall under category 2 for question 1.

The alternate hypothesis will be: H1: m1 does not equal m2

My work:
Anova: Single Factor

SUMMARY
Groups Count Sum Average Variance
Column 1(Department) 111 211 1.900901 0.09009
Column 2 (Intrinsic Job Satisfaction) 111 559.51 5.040631 1.244655

ANOVA
Source of Variation SS df MS F P-value F crit
Between Groups 547.1136 1 547.1136 819.8024 3.83E-76 3.884074
Within Groups 146.822 220 0.667373

Total 693.9356 221

The second claim is:

I claim that employees in the Administration Dept are Extrinsically more satisfied than other employees in other departments.

The Null hypothesis will be: H0: m1 = m2

Where m1 = mean of response to claim for those who fall under Administrative department
Where m2 = mean of response to question 2 for those who fall under other departments

The alternate hypothesis will be: H1: m1 > m2

My work:

Anova: Single Factor

SUMMARY
Groups Count Sum Average Variance
Column 1 177 531 3 0
Column 2 177 902.2 5.097175 2.593003

ANOVA
Source of Variation SS df MS F P-value F crit
Between Groups 389.2357 1 389.2357 300.22 4.5E-49 3.868012
Within Groups 456.3686 352 1.296502

Total 845.6043 353

Attachments

Solution Summary

The solution is a detailed pdf file. The solution is explained in words and equations.

$2.19