This preview shows pages 1–4. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.
View Full DocumentThis preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
Unformatted text preview: Put cursor in C14: PASTE Put cursor in C18: PASTE 2. Move Column B in front of column A (if necessary) so that Period and Seasons columns are next to each other. 3. Highlight B1:B25 Select: CUT 4. Right Mouse Click on cell A1 Select: INSERT CUT 3. Perform Regression on Values vs. Period, S 1 , S 2 and S 3 . RESULT 5. Fill in Regression dialogue box 4. Do forecast. NOTES: 1. In this case, MMULT (row, column) is equivalent to SUMPRODUCT. SUMPRODUCT, however, requires both entries be rows or both entries be columns. 2. Check to see if all pvalues for the period and seasons are low. If not, a modified Ftest can be performed to determine if seasonal variables should be included. 6. In cell F22 enter: =$H$17+ 7. Drag F22 to F23:F25...
View
Full
Document
 Spring '11
 Gupta

Click to edit the document details