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
The solution answers the question(s) below.