Homework answers / question archive / Question 1 Create a spreadsheet template to encapsulate the Simple Moving Average (n=2), Weighted Moving Average (n=2) (0
Question 1 Create a spreadsheet template to encapsulate the Simple Moving Average (n=2), Weighted Moving Average (n=2) (0.4, 0.6 weights – higher weight to the most recent data), and exponential model (alpha = 0.3 and forecast for period 1 given at 100). Use the data shown below in data set 1.
Data

Data Set 1 (frames) 
Data Set 2 (frames) 




















