1) Calculate the predicted trend for 2021 Q2 2) Calculate the detrended value for 2019 Q3 3) Calculate the average seasonal variation for Q4 4) Calculate the forecast for 2020 Q1 5) Calculate the forecast error for 2020 Q1 6) Calculate the forecast for 2021 Q2 7) What is the predicted annual increase in visitor numbers? 3 d.p. 3 d.p. 3 d.p. 3 d.p. 3 d.p. 3 d.p. 2 d.p. L(Ctrl) - Actual Year Quarter Datapoint Visitor Predicted Detrende Numbers Trend d Value 2018 Q1 1 Q2 2 (000) 19.0 26.1 29.5 25.7 Q3 3 Q4 4 2019 Q1 5 20.4 Q2 25.9 31.5 Q3 Q4 8 26.4 2020 Q1 9 22.3 30.5 Q2 Q3 35.6 Q4 31.8 2021 Q1 Q2 Q3 04 600 7 10 11 12 13 14 15 16 Average Seasonal Forecast Variation 22.445 -3.445 -5.234 25.801 -5.401 -5.234 29.157 -6.857 -5.234 Forecas Error marks] shows the quarterly visitor numbers to the resort, in which the Excelsior Hotel is located, over the past 3 years. t complete but some Quarter 1 (Q1) values for each year have been calculated for you. edicted trend is given by the equation: Visitor Numbers-21.606+0.839*Datapoint 1: Use values in the same form as they are given in the table; for example, Visitor Numbers = 26.1 etc. do not need Visitor Numbers = 26100 etc E2: If you want to edit the table, you will need to copy and paste it to another sheet. 3 d.p. 1) Calculate the predicted trend for 2021 Q2 3 d.p. 2) Calculate the detrended value for 2019 03 3d.p. 3) Calculate the average seasonal variation for Q4 3 d.p. 4) Calculate the forecast for 2020 01 5) Calculate the forecast error for 2020 01 3 d.p. 3 d.p. 6) Calculate the forecast for 2021 02 7) What is the predicted annual increase in visitor numbers? 2 d.p. TABLE 4 Year Quarter 2018 Q1 Q2 Q3 Q4 2019 Q1 Q2 Q3 04 2020 Q1 Q2 Q3 Q4 2021 Q1 Q2 Q3 Q4 Datapoint Actual Visitor Predicted Detrended Average Seasonal Numbers (000) Trend Value 19.0 22.445 -3.445 Variation -5.234 1 2 26.1 29.5 25.7 20.4 25.801 -5.401 -5.234 25.9 31.5 26.4 22.3 30.5 35.6 31.8 3 4 5 6 7 8 9 10 11 12 13 14 15 16 29.157 -6.857 -5.234 Forecast Forecast Error