excel assignment Math guruu

AliceRanwodds
flightdata.xlsx
Home>Mathematics homework help>Statistics homework help>excel assignment Math guruu

Sheet1

Year Month Domestic International Total Mean 81,620,168
2016 1 52,474,245 16,492,079 68,966,324 Median 82,229,641
2016 2 51,111,616 14,421,545 65,533,161 Range 55,812,275
2016 3 61,593,610 17,382,692 78,976,302 Standard Deviation 9642546.38104557
2016 4 58,894,278 16,596,730 75,491,008 Variance 91155588931975.3
2016 5 62,752,723 17,868,001 80,620,724 June, July, August 2016 2017
2016 6 64,757,943 19,407,251 84,165,194 Mean 85,296,088 89,121,911
2016 7 66,135,126 21,435,123 87,570,249 Median 84,165,194 88,677,138
2016 8 63,498,615 20,654,207 84,152,822 Rnage 3,417,427 3,842,854
2016 9 58,620,581 17,161,889 75,782,470 Standard Deviation 1969490.62449059 1959655.26562437
2016 10 61,709,421 16,905,446 78,614,867 Variance 2585928879970.89 2560165840059.56
2016 11 59,269,837 15,653,035 74,922,872 January, February, March 2016 2017
2016 12 59,178,833 18,014,473 77,193,306 Mean 71,158,596 73,086,734
2017 1 54,109,329 17,488,782 71,598,111 Median 68,966,324 71,598,111
2017 2 51,078,172 14,709,988 65,788,160 Rnage 13,443,141 16,085,770
2017 3 63,963,808 17,910,122 81,873,930 Standard Deviation 6984558.05916325 8145550.76136723
2017 4 61,099,004 18,686,523 79,785,527 Variance 32522700854548.2 44233331470673.6
2017 5 64,442,977 18,865,393 83,308,370 The number of passengers in June, July and August is definitely higher than in January, February and March. The reason is judged to be an increase in passengers due to vacations and student vacations.
2017 6 66,746,463 20,676,407 87,422,870 The range in June, July, and August of 2016 and 2017 is around 3000~4000, but the number of passengers in March is higher than in January and February. Thus, the range for January, February, and March is more than 10,000 different.
2017 7 68,575,481 22,690,243 91,265,724
2017 8 66,664,019 22,013,119 88,677,138
2017 9 57,144,508 17,438,756 74,583,264
2017 10 64,625,405 17,604,236 82,229,641
2017 11 61,911,765 16,476,642 78,388,407
2017 12 61,374,167 18,469,636 79,843,803
2018 1 55,831,159 17,897,787 73,728,946
2018 2 54,078,219 15,720,901 69,799,120
2018 3 66,644,135 19,716,774 86,360,909
2018 4 64,557,780 19,111,955 83,669,735
2018 5 67,846,119 20,126,585 87,972,704
2018 6 70,279,158 22,046,732 92,325,890
2018 7 72,540,389 23,754,573 96,294,962
2018 8 70,338,563 22,909,627 93,248,190
2018 9 60,468,575 18,051,374 78,519,949
2018 10 67,082,086 18,830,854 85,912,940
2018 11 64,660,022 17,552,376 82,212,398
2018 12 63,646,582 19,520,179 83,166,761
2019 1 58,034,262 18,690,817 76,725,079
2019 2 55,679,481 16,280,536 71,960,017
2019 3 70,234,129 20,295,947 90,530,076
2019 4 66,938,654 20,019,304 86,957,958
2019 5 71,364,145 20,995,113 92,359,258
2019 6 72,790,418 22,747,453 95,537,871
2019 7 75,281,916 23,907,859 99,189,775
2019 8 72,729,199 23,239,180 95,968,379
2019 9 63,991,365 18,842,310 82,833,675
2019 10 69,936,836 18,982,654 88,919,490
2019 11 64,827,417 17,575,113 82,402,530
2019 12 69,737,438 19,859,635 89,597,073
2020 1 61,638,893 18,955,398 80,594,291
2020 2 59,879,630 15,829,198 75,708,828
2020 3 34,420,555 8,956,945 43,377,500