4.25 - 4/14/11 Simple regression Forecasting If this is...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
4/14/11 Simple regression Forecasting Regression/Trend analysis Data Forecasts and Error Analysis Period Demand (y) Period(x) Forecast Error Absolute Squared Abs Pct Err Weekly 1 10226 1107 10303.505 -77.505006 77.5050055617 6007.02589 00.76% Weekly 2 10473 1141 10525.6144 -52.614386 52.6143863552 2768.27365 00.50% Weekly 3 10452 1135 10486.4186 -34.418613 34.418613274 1184.64094 00.33% Weekly 4 10442 1139 10512.5491 -70.549129 70.5491286615 4977.17955 00.68% Weekly 5 10471 1142 10532.147 -61.147015 61.1470152021 3738.95747 00.58% Weekly 6 10213 1108 10310.0376 -97.037634 97.0376344086 9416.30249 00.95% Weekly 7 10187 1110 10323.1029 -136.10289 136.102892102 18523.9972 01.34% Weekly 8 10240 1121 10394.9618 -154.96181 154.961809418 24013.1624 01.51% Weekly 9 10596 1157 10630.1364 -34.136448 34.1364479051 1165.29708 00.32% Weekly 10 10584 1145 10551.7449 32.2550983 32.2550982573 1040.39136 00.30% Weekly 11 10619 1144 10545.2123 73.7877271 73.7877271042 5444.62867 00.69% Weekly 12 10628
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.
Ask a homework question - tutors are online