Explore BrainMass

Explore BrainMass

    Conducting an ANOVA testng using excel with single factor

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

    Dr. Michaella Evans, a statistics professor at the University of Maryland University College, drives from her home to the school every weekday. She has three options to drive there. She can take the Beltway, or she can take a main highway with some traffic lights, or she can take the back road, which has no traffic lights but is a longer distance. Being as data-oriented as she is, she is interested to know if there is a difference in the time it takes to drive each route.

    As an experiment she randomly selected the route on 21 different days and wrote down the time it took her for the round trip, getting to work in the morning and back home in the evening. At the .01 significance level, can she conclude that there is a difference between the driving times using the different routes?

    Time (in minutes) it took to get to work and back using:

    Beltway Main highway Back road
    88 79 86
    94 86 78
    91 75 79
    88 83 96
    98 74 97
    84 72 73
    90 68
    77

    © BrainMass Inc. brainmass.com June 4, 2020, 5:03 am ad1c9bdddf
    https://brainmass.com/statistics/type-i-and-type-ii-errors/conducting-an-anova-testng-using-excel-with-single-factor-596027

    Attachments

    Solution Summary

    The solution gives detailed steps on conducting an ANOVA testng using excel with single factor.

    $2.19

    ADVERTISEMENT