This preview shows page 1. Sign up to view the full content.
Unformatted text preview: MUST use a straight-edge - NO hand-drawn lines.
If there are hand-drawn lines (without a straight edge), the entire assignment will get no credit.
(Sorry to require the straight-edge. It is required because without it some students will turn in a totally
inappropriate graph with supremely unstraight " lines" connecting dots.) 4/23/12 hw.forecasting.doc page 3 Sales 50 40 30 20 10 0
1 2 3 4 5 6 7 8 9 10 Coded X
Graph for hw.forecast.doc
File: Forecast.ESAlpha.cdr 5. ONLY THE ABOVE GRAPH MAY BE USED - THIS IS A REQUIREMENT.
Turn in: answers to the questions; the Excel output; the graph. Multiple papers MUST be stapled - otherwise they
will be ignored. 4/23/12 APPENDIX: 1. 2.
3. hw.forecasting.doc page 4 Using Excel to do Moving Average. If the data are as shown above, then in cell C4 type the formula as shown. The result will be 16, and that is what will be
displayed, not the formula. (Although the formula will display in the formula bar.)
Now we want to copy this formula down and let it adjust the values as it does. Click on cell C4 where your
formula is (displaying the number 16).
Click and hold and move the cursor to B11 so cells B4 through B11 are highlighted.
Press keys Ctrl-d (hold the Ctrl key and press the letter d). This means copy down.
You should now have displayed the 3-term moving average values.
Do the same for column D: in cell D6 type the formula as shown and the display will be 19.4 (depending on your format
statement). Do the same copy-down on that formula and you'll have the 5-term MA values.
If you want to set the format to 1 decimal place: Highlight all the cells you want to have the format (or entire columns),
RT-Click and select Format Cells, select Number, change the Decimal Places to 1....
View Full Document