This preview shows page 1. Sign up to view the full content.
Unformatted text preview: irst value to go.
(Tools, Data Analysis, Exponential Smoothing)
Using Excel to do Moving Average.
See comment (appendix) at the end of this assignment for guidance if needed. Here is a new set of data on which to perform the ES described below and the Moving Averages mentioned above. You'll do 2
ES runs (with 0.20 and 0.90) and 2 runs of Moving Averages (3 and 5 term). The result from the four runs should go in the
table as shown below. I've shown the values for the last 2 rows so you can see if you are approaching this properly.
put 1 here
put 1 here
For the new data above, use Excel to perform ES with α = 0.20 (in Excel the "damping factor" is 1-α so you
have to enter 0.80 for that instead of 0.20) . The smoothed values must line up next to the original values: 4th
smoothed value in the same row as 4th original value.
For the new data above, use Excel to perform ES with α = 0.90 (in Excel the "damping factor" is 1-α) . The
smoothed values must line up next to other smoothed values: 4th smoothed value in the same row as 4th original
Use Excel to do a 3-term Moving Average for the data above and place the results as shown above.
Use Excel to do a 5-term Moving Average for the data above and place the results as shown above.
Either print out your Excel page, or use PrtSc and paste it into Word and print that out. Attach the printed page to
For the new data above, use the graph below of Sales on the y axis and codedX on the x axis. Plot the 5 sets of
numbers (original, α=0.20, α=0.90, 3-term MA, 5-term MA) on this one graph and create a line for each set by
connecting the dots USING A STRAIGHT-EDGE ONLY. Do this graph by hand, not in Excel.
ONLY ONLY ONLY this graph may be used. MUST...
View Full Document