Posted: October 24th, 2022
Place your order now for a similar assignment and have exceptional work written by our team of experts, At affordable rates
For This or a Similar Paper Click To Order Now
Obtain the passenger data and load factor from The Bureau of Transportation Statistics (U.S. Department of Transportation). If you do not have the Data Analysis Add-In for Excel, complete the steps in the Data Analysis Excel® Add-In. Note: Data will not always be obtained in this precise way. You will need to perform the analysis you wish.
For the time period of January 1, 2016, to the end of March 2020, what were the mean and median monthly passengers? What is the range, standard deviation, and variance? In other words, what were the summary statistics?
For the months of June, July, and August, for the time period indicated above, provide the same summary statistics. For example, you will have June, July, and August 2016, June, July, and August 2017, et cetera, in one data set. What are the summary statistics for these months?
For the months of January, February, and March, aggregated as described for June, July, and August; what are the summary statistics?
Do you note any differences between the two samples above: June, July, August vs January, February March? Do you have any reasons why these could be different?
Place an order in 3 easy steps. Takes less than 5 mins.