hw.forecast

# Tools data analysis exponential smoothing using excel

This preview shows page 1. Sign up to view the full content.

This is the end of the preview. Sign up to access the rest of the document.

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 3-term MA 5-term 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 3-term Moving Average for the data above and place the results as shown above. d. Use Excel to do a 5-term 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, 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

## This note was uploaded on 01/27/2013 for the course STAT 385 taught by Professor Szatrowski during the Spring '08 term at Rutgers.

Ask a homework question - tutors are online