Below is the annual tourist number of a country. Please forecast for year 13 using a....

Transcribed Image Text:

Below is the annual tourist number of a country. Please forecast for year 13 using a. Moving average with 3 years window. b.Simple exponential smoothing with the best alpha (you need use solver to find the best alpha) Year(t) Visitors(in million) 1 26.57 2 23.75 3 27.51 4 25.83 5 27.03 6 28.91 7 31.69 8 31.18 9 28.94 10 34.27 11 32.12 12 30.12 13 Below is the annual tourist number of a country. Please forecast for year 13 using a. Moving average with 3 years window. b.Simple exponential smoothing with the best alpha (you need use solver to find the best alpha) Year(t) Visitors(in million) 1 26.57 2 23.75 3 27.51 4 25.83 5 27.03 6 28.91 7 31.69 8 31.18 9 28.94 10 34.27 11 32.12 12 30.12 13