17 1 17 1101 1431 101 1417418 18 1 18 1274 1449 1008 1437533 19 1 19 1305 1685

17 1 17 1101 1431 101 1417418 18 1 18 1274 1449 1008

This preview shows page 3 - 6 out of 7 pages.

17 1 0 0 17 1101 1431 1.01 1417.418 18 0 1 0 18 1274 1449 1.008 1437.533 19 0 0 1 19 1305 1685 1.088 1549.008 20 0 0 0 20 1468 Dummy Coding Seasonality model SUMMARY OUTPUT Regression Statistics Multiple R 0.99541 R Square 0.990841 Adjusted R 0.988398 Standard E 31.74836 Observatio 20 ANOVA df SS MS F ignificance F Regression 4 1635605 408901.4 405.6729 4.36E-015 Residual 15 15119.38 1007.958 Total 19 1650725 Coefficients tandard Erro t Stat P-value Lower 95%Upper 95%Lower 95.0% Upper 95.0% Intercept 732.425 20.6974 35.3873 7.21E-016 688.3095 776.5405 688.3095 776.5405 Quarters 45.28125 1.254964 36.08171 5.41E-016 42.60636 47.95614 42.60636 47.95614 Q1 -221.5563 20.42934 -10.84501 1.70E-008 -265.1003 -178.0122 -265.1003 -178.0122 Q2 -98.6375 20.23569 -4.874433 0.000202 -141.7688 -55.50615 -141.7688 -55.50615 Q3 -105.7188 20.11861 -5.254775 9.71E-005 -148.6005 -62.83696 -148.6005 -62.83696 Q21 1462 Q22 1630 Q23 1668
Image of page 3
Q24 1819 2014 revenModel #1 Abuoulte ESquare ErrPwecent Err 1396 1462 66 4356 0.047278 1607 1630 23 529 0.014312 1619 1668 49 2401 0.030266 1995 1819 176 30976 0.088221 MAD MSE MAPE 78.5 9565.5 0.045019
Image of page 4
Sales SI DS Quarters Q1 Q2 Q3 Quarters Lsales 576 0.895 643.828 1 1 0 0 1 714 1.01 707.223 2 0 1 0 2 759 1.008 752.993 3 0 0 1 3 879 1.088 808.058 4 0 0 0 4 777 0.895 868.498 5 1 0 0 5 576 903 1.01 894.429 6 0 1 0 6 714 936 1.008 928.593 7 0 0 1 7 759 1049 1.088 964.338 8 0 0 0 8 879 894 0.895 999.275 9 1 0 0 9 777 1111 1.01 1100.455 10 0 1 0 10 903 1175 1.008 1165.701 11 0 0 1 11 936 1298 1.088 1193.242 12 0 0 0 12 1049 1101 0.895 1230.651 13 1 0 0 13 894 1274 1.01 1261.908 14 0 1 0 14 1111 1305 1.008 1294.672 15 0 0 1 15 1175 1468 1.088 1349.522 16 0 0 0 16 1298 1244 0.895 1390.491 17 1 0 0 17 1101 1431 1.01 1417.418 18 0 1 0 18 1274 1449 1.008 1437.533 19 0 0 1 19 1305 1685 1.088 1549.008 20 0 0 0 20 1468 SUMMARY OUTPUT Regression Statistics Multiple R 0.9890885756 R Square 0.9782962104 Adjusted R 0.9749571659 Standard E 39.222097751 Observatio 16 ANOVA df SS MS F ignificance F Regression 2 901446.2 450723.1 292.9869 1.54E-011 Residual 13 19998.85 1538.373 Total 15 921445 Coefficients tandard Erro
Image of page 5
Image of page 6

You've reached the end of your free preview.

Want to read all 7 pages?

  • Spring '14
  • Danepeterson

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture