DATA SET 2 - SIMPLE-1 - 4/14/11 Data set 2 - Simple...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
4/14/11 Data set 2 - Simple regression Forecasting Regression/Trend analysis Data Forecasts and Error Analysis Period Demand (y) Period(x) Forecast Error Absolute Squared Abs Pct Err Monthly 1 48 8.43 56.6505123982 -8.6505123982 8.6505123982 74.831364751 18.02% Monthly 2 55 8.76 52.6207558685 2.3792441315 2.3792441315 5.6608026375 04.33% Monthly 3 56 8.94 50.4227068522 5.5772931478 5.5772931478 31.106198856 09.96% Monthly 4 53 8.85 51.5217313604 1.4782686396 1.4782686396 2.185278171 02.79% Monthly 5 52 8.67 53.7197803766 -1.7197803766 1.7197803766 2.9576445436 03.31% Monthly 6 53 8.51 55.6736017243 -2.6736017243 2.6736017243 7.1481461803 05.04% Monthly 7 52 8.13 60.3139274252 -8.3139274252 8.3139274252 69.121389232 15.99% Monthly 8 56 7.98 62.1456349387 -6.1456349387 6.1456349387 37.7688288 10.97% Monthly 9 51 7.92 62.8783179441 -11.8783179441 11.8783179441 141.09443718 23.29% Monthly 10 48 8.09 60.8023827621 -12.8023827621 12.8023827621 163.90100439 26.67% Monthly 11 42 8.31 58.115878409 -16.115878409 16.115878409 259.72153689 38.37% Monthly 12 42 8.22 59.2149029171 -17.2149029171 17.2149029171 296.35288245 40.99% Monthly 13 44 8.02 61.6571796018 -17.6571796018 17.6571796018 311.77599149 40.13% Monthly 14 50 7.68 65.8090499657 -15.8090499657 15.8090499657 249.92606082 31.62% Monthly 15 60 7.5 68.007098982 -8.007098982 8.007098982 64.113634107 13.35% Monthly 16 66 7.47 68.3734404847 -2.3734404847 2.3734404847 5.6332197342 03.60% Monthly 17 58 7.47 68.3734404847 -10.3734404847 10.3734404847 107.60826749 17.89% Monthly 18 59 7.42 68.9840096558 -9.9840096558 9.9840096558 99.680448808 16.92% Monthly 19 55 7.21 71.5484001748 -16.5484001748 16.5484001748 273.84954834 30.09% Monthly 20 57 7.11 72.7695385171 -15.7695385171 15.7695385171 248.67834504 27.67% Monthly 21 57 6.92 75.0897013675 -18.0897013675 18.0897013675 327.23729557 31.74% Monthly 22 56 6.83 76.1887258756 -20.1887258756 20.1887258756 407.58465248 36.05% Monthly 23 53 7.16 72.1589693459 -19.1589693459 19.1589693459 367.0661064 36.15% Monthly 24 51 7.17 72.0368555117 -21.0368555117 21.0368555117 442.54928982 41.25% Monthly 25 46 7.06 73.3801076883 -27.3801076883 27.3801076883 749.67029702 59.52% Monthly 26 58 7.15 72.2810831802 -14.2810831802 14.2810831802 203.9493368 24.62% Monthly 27 74 7.68 65.8090499657 8.1909500343 8.1909500343 67.091662464 11.07% Monthly 28 65 8.32 57.9937645748 7.0062354252 7.0062354252 49.087334834 10.78% Monthly 29 65 8.6 54.5745772162 10.4254227838 10.4254227838 108.68944022 16.04% Monthly 30 55 8.4 57.0168539009 -2.0168539009 2.0168539009 4.0676996575 03.67% Monthly 31 52 8.61 54.452463382 -2.452463382 2.452463382 6.0145766399 04.72% Monthly 32 59 8.51 55.6736017243 3.3263982757 3.3263982757 11.064925488 05.64% Monthly 33 54 8.64 54.0861218793 -0.0861218793 0.0861218793 0.0074169781 00.16% Monthly 34 57 8.93 50.5448206865 6.4551793135 6.4551793135 41.66933997 11.32% Monthly 35 45 9.17 47.6140886649 -2.6140886649 2.6140886649 6.8334595478 05.81% Monthly 36 40 9.2 47.2477471622 -7.2477471622 7.2477471622 52.529838927
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/19/2012 for the course ECON 215 taught by Professor Rodgers during the Three '08 term at University of Wollongong, Australia.

Page1 / 2

DATA SET 2 - SIMPLE-1 - 4/14/11 Data set 2 - Simple...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online