Answered step by step
Verified Expert Solution
Question
1 Approved Answer
write a report to forecast monthly passenger flow (number of passengers flying in and out) through the airport for planning and budgeting purposes. using the
write a report to forecast monthly passenger flow (number of passengers flying in and out) through the airport for planning and budgeting purposes. using the table that is provided under the question which is historical monthly airport passenger data over last five years - ending in December, 2021 .
how to explore the idea of exponential smoothing to model the history and prepare a forecast for next year (January 2022 to December 2022).
- Use SPSS to fit a Multiplicative Trend-Seasonal Model and forecast monthly passenger flow this airport can expect for next year.
- Use SPSS to fit an additive Trend-Seasonal Model (Winters Model) and forecast next 12 months passenger flow this airport can expect. Compare all relevant statistics for this model to one you developed in part (a).
2,644,539 |
2,359,800 |
2,925,918 |
3,024,973 |
3,177,100 |
3,419,595 |
3,649,702 |
3,650,668 |
3,191,526 |
3,249,428 |
2,971,484 |
3,074,209 |
2,785,466 |
2,515,361 |
3,105,958 |
3,139,059 |
3,380,355 |
3,612,886 |
3,765,824 |
3,771,842 |
3,356,365 |
3,490,100 |
3,163,659 |
3,167,124 |
2,883,810 |
2,610,667 |
3,129,205 |
3,200,527 |
3,547,804 |
3,766,323 |
3,935,589 |
3,917,884 |
3,564,970 |
3,602,455 |
3,326,859 |
3,441,693 |
3,211,600 |
2,998,119 |
3,472,440 |
3,563,007 |
3,820,570 |
4,107,195 |
4,284,443 |
4,356,216 |
3,819,379 |
3,844,987 |
3,478,890 |
3,443,039 |
3,204,637 |
2,966,477 |
3,593,364 |
3,604,104 |
3,933,016 |
4,146,797 |
4,176,486 |
4,347,059 |
3,781,168 |
3,858,196 |
3,562,680 |
3,633,798 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started