Explore BrainMass

Explore BrainMass

    Testing hypotheses by the Excel

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

    There are four auto body shops in a community and all claim to promptly serve customers. To check if there is any difference in service customers are randomly selected from each repair shop and their waiting times in days are recorded. The out put from a statistical software package is
    Summary
    Groups Count Sum Average Variance

    Group A 3 15.4 5.133333 0.323333
    Group B 4 32 8 1.433333
    Group C 5 25.2 5.04 0.748
    Group D 4 25.9 6.475 0.595833

    ANOVA
    Source of variation SS DF MS F P-value

    Between groups 23.37321 3 7.791069 9.612506 0.001632

    With in groups 9.726167 12 0.810514

    Total 33.09938 15

    Is there evidence to suggest a difference in the mean waiting times at the four body shops? Use the .05 significance level.

    © BrainMass Inc. brainmass.com June 3, 2020, 8:57 pm ad1c9bdddf
    https://brainmass.com/statistics/hypothesis-testing/testing-hypotheses-by-the-excel-159761

    Solution Preview

    From the given ANOVA table I copy it here,

    ----------------------------------------------------------------

    Summary
    Groups Count Sum Average Variance

    Group A 3 15.4 5.133333 ...

    Solution Summary

    The solution contains detailed explanation of testing hypotheses by using Excel.

    $2.19

    ADVERTISEMENT