Madison County Airport handles several daily commuter flights and many private flights. The county budget officer has compiled the following data regarding airport costs and activity over the past year.
Month | Flights Originating at Madison County Airport | Airport Costs |
January | 1,100 | $20,000 |
February | 800 | 17,000 |
March | 1,400 | 19,000 |
April | 900 | 18,000 |
May | 1,000 | 19,000 |
June | 1,200 | 20,000 |
July | 1,100 | 18,000 |
August | 1,400 | 24,000 |
September | 1,000 | 19,000 |
October | 1,200 | 21,000 |
November | 900 | 17,000 |
December | 1,500 | 21,000 |
Required:
1. Draw a scatter diagram of the airport costs shown above.
2.Build aspreadsheet:Construct an Excel spreadsheet and use the Excel commands to perform a least-squares regression. Estimate the variable- and fixed-cost components in the airport’s cost behavior pattern.
3. Write the least-squares regression equation for the airport’s costs.
4. Predict the airport’s costs during a month when 1,600 flights originate at the airport.
5. Using the Excel spreadsheet prepared for requirement (2), compute the coefficient of determination (R2)for the regression equation. Briefly interpret R2
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.