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.
a.
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.
CodedX
Sales
alpha 0.2
alpha 0.9
3term MA
5term MA
1
10
2
13
st
3
25
put 1 here
4
15
st
5
34
put 1 here
6
10
7
21
8
18
9
43
17.4
18.2
27.3
25.2
10
7
22.5
40.5
19.8
22.7
a.
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.
b.
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
value, etc.
c.
Use Excel to do a 3term Moving Average for the data above and place the results as shown above.
d.
Use Excel to do a 5term Moving Average for the data above and place the results as shown above.
e.
Either print out your Excel page, or use PrtSc and paste it into Word and print that out. Attach the printed page to
your homework.
f.
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, 3term MA, 5term MA) on this one graph and create a line for each set by
connecting the dots USING A STRAIGHTEDGE ONLY. Do this graph by hand, not in Excel.
ONLY ONLY ONLY this graph may be used. MUST...
View
Full
Document
This note was uploaded on 01/27/2013 for the course STAT 385 taught by Professor Szatrowski during the Spring '08 term at Rutgers.
 Spring '08
 Szatrowski
 Statistics, Forecasting

Click to edit the document details