1. Using the quarterly data, develop a 4-period centred moving average. Include your graph and forecast for the second quarter of 2021.

2. Using the quarterly data and a smoothing constant of 0.6, insert your graph and forecast based on an Exponential Smoothing model.

3. Based on the MAD, which smoothing technique is better? Explain. Use the preferred smoothing technique to forecast the next period (quarter). (You are not asked to compare with the actual revenues for the second quarter of 2021 as the results are not reported until July 29, 2021 which is after the due date of this assignment.)

4. Using the quarterly data and Minitab, add columns for Period (representing quarters) and indicator variables for the quarters as demonstrated in the class video. Develop the estimated regression equation to predict ln(Rev) from five predictors: Period, the indicator variables and the lagRES. Include output for the equation and the Durbin-Watson statistic. Assess the D-W statistic.

5. Using Minitab and your model from part l, forecast the revenues for the second quarter of 2021. Include the pertinent output (equation, settings, forecast with CI and PI). State the final answer (in appropriate units).

Please help me solve these questions. Thank you!

46 47 48 49 50 51 52 53 54 55 56 57 58 59 6/30/2016 9/30/2016 12/31/2016 3/31/2017 6/30/2017 9/30/2017 12/31/2017 3/31/2018 6/30/2018 9/30/2018 12/31/2018 3/31/2019 6/30/2019 9/30/2019 12/31/2019 3/31/2020 6/30/2020 9/30/2020 12/31/2020 3/31/2021 $30,404 $32,714 $43,741 $35,714 $37,955 $43,744 $60,453 $51,042 $52,886 $56,576 $72,383 $59,700 $63,404 $69,981 $87,437 $75,452 $88,912 $96,145 $125,555 $108,518 60 61 62 63 64 65 46 47 48 49 50 51 52 53 54 55 56 57 58 59 6/30/2016 9/30/2016 12/31/2016 3/31/2017 6/30/2017 9/30/2017 12/31/2017 3/31/2018 6/30/2018 9/30/2018 12/31/2018 3/31/2019 6/30/2019 9/30/2019 12/31/2019 3/31/2020 6/30/2020 9/30/2020 12/31/2020 3/31/2021 $30,404 $32,714 $43,741 $35,714 $37,955 $43,744 $60,453 $51,042 $52,886 $56,576 $72,383 $59,700 $63,404 $69,981 $87,437 $75,452 $88,912 $96,145 $125,555 $108,518 60 61 62 63 64 65