Answered step by step
Verified Expert Solution
Link Copied!

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).

  1. Use SPSS to fit a Multiplicative Trend-Seasonal Model and forecast monthly passenger flow this airport can expect for next year.
  2. 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Mathematics For The Liberal Arts

Authors: Donald Bindner, Martin J Erickson, Joe Hemmeter

1st Edition

1118371747, 9781118371749

More Books

Students also viewed these Mathematics questions

Question

1. Background knowledge of the subject and

Answered: 1 week ago