This preview shows page 1. Sign up to view the full content.
Unformatted text preview: MUST use a straightedge  NO handdrawn lines.
If there are handdrawn lines (without a straight edge), the entire assignment will get no credit.
(Sorry to require the straightedge. 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.)
a.
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).
b.
Click and hold and move the cursor to B11 so cells B4 through B11 are highlighted.
c.
Press keys Ctrld (hold the Ctrl key and press the letter d). This means copy down.
d.
You should now have displayed the 3term 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 copydown on that formula and you'll have the 5term 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),
RTClick and select Format Cells, select Number, change the Decimal Places to 1....
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