Purchase Solution

Anova Function in Excel to test Hypotheses

Not what you're looking for?

Ask Custom Question

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
Purchase this Solution

Solution Summary

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

Purchase this Solution


Free BrainMass Quizzes
Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.