Explore BrainMass
Share

Explore BrainMass

    Anova Function in Excel to test Hypotheses

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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

    © BrainMass Inc. brainmass.com October 9, 2019, 5:03 pm ad1c9bdddf
    https://brainmass.com/statistics/analysis-of-variance/anova-function-in-excel-to-test-hypotheses-46723

    Attachments

    Solution Summary

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

    $2.19