ISDS 361B CASE STUDY 1.xlsx - SUMMARY OUTPUT Regression Statistics Multiple R 0.908407 R Square 0.82520327 Adjusted R S 0.81860717 Standard Erro

ISDS 361B CASE STUDY 1.xlsx - SUMMARY OUTPUT Regression...

This preview shows page 1 - 6 out of 10 pages.

SUMMARY OUTPUT Regression Statistics Multiple R 0.908407 R Square 0.82520327 Adjusted R S 0.81860717 Standard Erro 26.0677329 Observations 56 ANOVA df SS MS F Significance F Regression 2 170023.924 85011.9622 125.104669 8.4554E-021 Residual 53 36014.9149 679.526697 Total 55 206038.839 CoefficientsStandard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Intercept 315.026156 7.24247598 43.4970246 3.8065E-043 300.499589 329.552723 300.499589 Day 0.7163216 0.21655543 3.30779799 0.00169374 0.28196642 1.15067678 0.28196642 Weekend 116.767874 7.74810074 15.0705158 8.3205E-021 101.227152 132.308596 101.227152 RESIDUAL OUTPUT Observation cted Daily Dem Residuals 1 315.742478 -18.7424776 2 316.458799 -23.4587992 3 317.175121 9.82487923 4 317.891442 -2.89144237 5 318.607764 29.392236 6 436.09196 10.90804 7 436.808282 -5.80828157 8 320.756729 -37.7567288 9 321.47305 4.52694962 10 322.189372 -5.18937198 11 322.905694 22.0943064 12 323.622015 31.3779848 13 441.106211 -13.1062112 14 441.822533 12.1774672 15 325.77098 -20.77098 16 326.487302 -16.4873016 17 327.203623 22.7963768 18 327.919945 -19.9199448 19 328.636266 37.3637336 20 446.120462 13.8795376 21 446.836784 -19.836784 22 330.785231 -39.7852312 23 331.501553 -6.5015528 0 10 20 30 40 -100 -50 0 50 100 Day Residual Plot Day Residuals 0 10000 20000 30000 40000 50000 60000 700 -40 -20 0 20 40 Weekend Residual Plot Weekend Residuals
Image of page 1
24 332.217874 21.7821256 25 332.934196 -10.934196 26 333.650518 71.3494824 27 451.134714 -9.1347136 28 451.851035 2.1489648 29 335.799482 -17.7994824 30 336.515804 -38.515804 31 337.232126 17.7678744 32 337.948447 17.0515528 33 338.664769 35.3352312 34 456.148965 -9.1489648 35 456.865286 6.1347136 36 340.813734 -49.8137336 37 341.530055 -22.5300552 38 342.246377 -9.24637681 39 342.962698 -3.96269841 40 343.67902 72.32098 41 461.163216 13.836784 42 461.879538 -2.87953761 43 345.827985 -26.8279848 44 346.544306 -20.5443064 45 347.260628 8.73937198 46 347.97695 -7.97694962 47 348.693271 46.3067288 48 466.177467 -1.17746722 49 466.893789 -13.8937888 50 350.842236 -43.842236 51 351.558558 -27.5585576 52 352.274879 -2.27487923 53 352.991201 -4.99120083 54 353.707522 30.2924776 55 471.191718 2.80828157 56 471.90804 13.09196
Image of page 2
Upper 95.0% 329.552723 1.15067678 132.308596 50 60 000 80000 90000
Image of page 3
Image of page 4
Date Weekday Weekend Day Daily Demand Weekday Average - Weekend 4/25/2016 Mon 0 1 297 Sun 1 4/26/2016 Tue 0 2 293 Mon 0 4/27/2016 Wed 0 3 327 Tue 0 4/28/2016 Thu 0 4 315 Wed 0 4/29/2016 Fri 0 5
Image of page 5
Image of page 6

You've reached the end of your free preview.

Want to read all 10 pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture