Scribd Logo
Upload

Welcome to Scribd!

  • 12 views

    Atlanta

    Uploaded by

    ayyappakumar
    The regression model predicts revenue with 97% accuracy based on % occupancy. %Individual occupancy and %Group occupancy were then added as predictors, improving the model to 93% accuracy. The model was statistically significant. Residuals were small, showing close prediction values.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLSX, PDF, TXT or read online from Scribd

    Atlanta

    Uploaded by

    ayyappakumar
    12 views6 pages
    The regression model predicts revenue with 97% accuracy based on % occupancy. %Individual occupancy and %Group occupancy were then added as predictors, improving the model to 93% accuracy. The model was statistically significant. Residuals were small, showing close prediction values.

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The regression model predicts revenue with 97% accuracy based on % occupancy. %Individual occupancy and %Group occupancy were then added as predictors, improving the model to 93% accuracy. The model was statistically significant. Residuals were small, showing close prediction values.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    12 views6 pages

    Atlanta

    Uploaded by

    ayyappakumar
    The regression model predicts revenue with 97% accuracy based on % occupancy. %Individual occupancy and %Group occupancy were then added as predictors, improving the model to 93% accuracy. The model was statistically significant. Residuals were small, showing close prediction values.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 6

    SUMMARY OUTPUT

    Regression Statistics
    Multiple R 0.958063860050994
    R Square 0.91788635993581 0.917886359936 regression/total
    Adjusted R Square 0.909674995929391
    Standard Error 22417.5660077923 22417.56600779 squareroot of mean square
    Observations 12

    ANOVA
    df SS MS F Significance F
    Regression 1 56175962977.78 56175962978 111.78244677 9.5190523E-07
    Residual 10 5025472657.137 502547265.71
    Total 11 61201435634.92

    Coefficients Standard Error t Stat P-value Lower 95%


    Intercept -60376.5461530729 54097.9473437 -1.1160598344 0.2904962701 -180914.28393
    %Occupancy 8231.77766832191 778.5864231899 10.572721824 9.519052E-07 6496.97901663

    RESIDUAL OUTPUT

    Observation Predicted Revenue Residuals


    1 480451.246655676 33988.75334432
    2 442585.069381396 20529.9306186
    3 583348.4675097 14833.5324903
    4 477981.71335518 -23057.7133552
    5 462341.335785368 -8538.33578537
    6 520786.957230454 -18558.9572305
    7 608043.800514666 18218.19948533
    8 532311.445966104 -33608.4459661
    9 539720.045867594 -25262.0458676
    10 612159.689348827 11131.31065117
    11 450816.847049718 3951.152950282
    12 379200.381335317 6372.618664683
    22417.566008

    Upper 95% Lower 95.0% Upper 95.0%


    60161.191619 -180914.28393 60161.191619
    9966.57632 6496.9790166 9966.57632
    Actual 2204

    Revenue %Occupancy
    514,440 65.7
    463,115 61.1
    598,182 78.2
    454,924 65.4
    453,803 63.5
    502,228 70.6
    626,262 81.2
    498,703 72
    514,458 72.9
    623,291 81.7
    454,768 62.1
    385,573 53.4
    SUMMARY OUTPUT

    Regression Statistics
    Multiple R 0.963018886833875
    R Square 0.927405376398755
    Adjusted R Square 0.911273237820701
    Standard Error 22218.3487329544
    Observations 12

    ANOVA
    df SS MS F Significance F
    Regression 2 56758540451.14 2.84E+10 57.48806 7.483E-06
    Residual 9 4442895183.773 4.94E+08
    Total 11 61201435634.92

    Coefficients Standard Error t Stat P-value Lower 95%Upper 95%


    Intercept -110019.843543877 83252.84536309 -1.321515 0.218936 -298351 78311.18

    %Individual
    Occupancy 9649.99295790563 2166.381353219 4.454429 0.00159 4749.298 14550.69

    %Group
    Occupancy 8170.80694921749 983.6873468872 8.306305 1.637E-05 5945.552 10396.06

    RESIDUAL OUTPUT

    Observation Predicted Revenue Residuals


    1 489698.573465189 24741.42653481
    2 444006.922171177 19108.07782882
    3 596010.59660988 2171.40339012
    4 482122.304699333 -27198.3046993
    5 471655.881967505 -17852.8819675
    6 522555.802571473 -20327.8025715
    7 600851.159073235 25410.84092676
    8 523852.601269947 -25149.6012699
    9 531199.990111243 -16741.9901112
    10 610940.673765575 12350.32623442
    11 444104.860835328 10663.13916467
    12 372747.633460114 12825.36653989
    Lower 95.0% Upper 95.0%
    -298350.86362 78311.176533

    4749.2978724 14550.688043

    5945.5515761 10396.062322
    %Individual %Group
    Revenue Occupancy Occupancy
    Jan 514,440 42.3 23.44
    Feb 463,115 36.82 24.32
    Mar 598,182 45.4 32.79
    Apr 454,924 38.78 26.67
    May 453,803 42.31 21.22
    Jun 502,228 40.65 29.41
    Jul 626,262 40 39.76
    Aug 498,703 37.66 33.1
    Sep 514,458 37.49 34.2
    Oct 623,291 41.96 38.68
    Nov 454,768 34.29 27.32
    Dec 385,573 36.04 16.52

    You might also like