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) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
