Smoothing constant options go from 0.1 to 0.9

Model options (single exponential smoothing - regression - moving average)

PLEASE: do not round intermediate calculations, otherwise, the MSE will be wrong.

Using the factory energy cost data in the table below, find the best moving average and exponential smoothing models. Year 1 2 3 4 5 6 7 Energy Costs 15,365.94 15,408.65 15,921.14 16,611.45 16,926.34 16,829.77 16,808.01 17,107.99 16,827.24 17,845.23 18,188.00 18,783.02 18,868.47 18,908.00 19,311.63 8 9 10 11 12 13 14 15 Find the best number of years to use in a moving average forecast based on MSE. Do not round intermediate calculations. Round your answers to two decimal places. MSE Number of years 2 w 3 4 The -Select- Find -Select- calci 2-year moving average model is better al smoothing model by evaluating the MSE from 0.1 to 0.9, in increments of 0.1. Do not round intermediate ers to two decimal places. Alpha MSE 3-year moving average 0.1 4-year moving average 0.2 Find the best single exponential smoothing model by evaluating the MSE from 0.1 to 0.9, in increments of 0.1. Do not round intermediate calculations. Round your answers to two decimal places. Alpha MSE 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 The model based on a smoothing constant of -Select- is the best. Compare the forecasting ability of the best moving average and single exponential smoothing models with a regression model. The regression equation is Y = 15,089.09 + 278.12(Year) with MSE = 97,885.32. Which model would you choose based on MSE? The -Select- model should be chosen