hw.forecast

If there are hand drawn lines without a straight edge

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: 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.) 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 Ctrl-d (hold the Ctrl key and press the letter d). This means copy down. d. 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

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