Explore BrainMass

Explore BrainMass

    ANOVA Tests

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

    Can you please show me how to perform an ANOVA on the data below using Microsoft Excel. Then I need to understand how to interpret the results of your ANOVA and the significance of the results to the organization as a whole.

    U.S. airlines carried 47.4 million domestic passengers in April, the U.S. Department of Transportation's Bureau of Transportation Statistics reported today in a release of preliminary data. Effective October 2002, commuter and small certificated carriers were required to begin reporting domestic enplaned data. The addition of this new data has a distorting effect on year-over-year domestic enplanement comparisons, but represents the new way that this data will be announced (affected data shown in bold).
    The April 2003 data include 3,163,281 domestic enplanements that were reported by these relatively new reporting carriers. Thus, the same carrier year over year comparison in April 2003 would total 44,234,664 domestic enplanements this year or a 2.6 percent decrease compared to the prior year's April results.
    Total domestic enplanements were 3.8 percent lower in April 2003 compared to March 2003 for all domestic flights operated by U.S. airlines. Month-to-month changes can be affected by seasonal factors.

    Table 1. Industry Domestic Enplanements

    Month 2001 2002 2003
    January 44,107,354 38,557,439 43,067,895
    February 43,177,091 38,644,426 40,981,396
    March 53,054,589 48,501,883 49,292,829
    April 50,791,568 45,437,147 47,397,945
    May 51,119,648 47,114,281
    June 53,471,052 49,188,600
    July 55,802,826 51,155,839
    August 56,404,948 51,226,483
    September 30,546,412 40,223,878
    October 40,290,718 48,273,424
    November 40,691,635 44,226,121
    December 40,901,001 49,864,516
    YTDate 191,130,602 171,140,895 180,740,065
    Annual 560,358,842 552,414,037

    Source: T-100 Domestic Market

    © BrainMass Inc. brainmass.com June 3, 2020, 4:56 pm ad1c9bdddf

    Solution Preview

    The question here is to compare the population means of each year.
    If there is significant difference between these averages, the addition of new data does have effect on the enplanement; if not, no significant effect.
    Since there's a lack in data of May-December 2003, we only use the January - April samples.
    The null hypothesis will be that all population means are equal, the alternative hypothesis is that at least one mean is different:
    H0: D1=D2=D3 vs. H1: at least one D is different

    (Please refer to the attached EXCEL file for calculation.)

    The grand mean of a set of samples is the total of all the data values divided by the total sample size. Dgm=45250964
    The total variation (not variance) is comprised the sum of the squares of the differences of each mean with the grand mean. There is the between group ...

    Solution Summary

    The solution answers the question(s) below.