Explore BrainMass

Explore BrainMass

    Anova Function in Excel to test Hypotheses

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    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 March 4, 2021, 6:29 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.49

    ADVERTISEMENT