Scribd Logo
Upload

Welcome to Scribd!

  • 40 views

    Demand Estimation Using Regression

    Uploaded by

    Moidin Afsan
    The regression analysis found a moderate positive correlation (R=0.593) between the variables. The ANOVA table shows the regression model was statistically significant (p=0.024). Based on the coefficients, increases in annual police funding per resident (β=0.027), population of city (β=0.099), and average parking rates (β=167.945) were associated with higher demand, while increases in monthly income of riders (β=-0.831) were associated with lower demand.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Demand Estimation Using Regression

    Uploaded by

    Moidin Afsan
    40 views7 pages
    The regression analysis found a moderate positive correlation (R=0.593) between the variables. The ANOVA table shows the regression model was statistically significant (p=0.024). Based on the coefficients, increases in annual police funding per resident (β=0.027), population of city (β=0.099), and average parking rates (β=167.945) were associated with higher demand, while increases in monthly income of riders (β=-0.831) were associated with lower demand.

    Original Title

    QT-Project

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The regression analysis found a moderate positive correlation (R=0.593) between the variables. The ANOVA table shows the regression model was statistically significant (p=0.024). Based on the coefficients, increases in annual police funding per resident (β=0.027), population of city (β=0.099), and average parking rates (β=167.945) were associated with higher demand, while increases in monthly income of riders (β=-0.831) were associated with lower demand.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    40 views7 pages

    Demand Estimation Using Regression

    Uploaded by

    Moidin Afsan
    The regression analysis found a moderate positive correlation (R=0.593) between the variables. The ANOVA table shows the regression model was statistically significant (p=0.024). Based on the coefficients, increases in annual police funding per resident (β=0.027), population of city (β=0.099), and average parking rates (β=167.945) were associated with higher demand, while increases in monthly income of riders (β=-0.831) were associated with lower demand.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 7

    Demand Estimation using Regression SUMMARY OUTPUT

    Regression Statistics
    Multiple R
    R Square

    Adjusted R Square
    Standard Error
    Observations

    ANOVA

    Regression
    Residual
    Total

    Intercept
    Price per week

    Population of city
    Monthly income
    of riders
    Average parking
    rates per month
    UMMARY OUTPUT

    egression Statistics
    0.97132295
    0.94346827

    0.93442319
    5186.2581
    30

    df SS MS F Significance F
    4 1.1222E+10 2.8E+09 104.3074 3.240692E-15
    25 672431826 2.7E+07
    29 1.1895E+10

    Standard
    Coefficients Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
    17912.6113 80670.6644 0.2220 0.8261 -148231.732 184056.9546 -148231.732 184056.955
    -659.9491 86.1876 -7.6571 0.0000 -837.4557 -482.4426 -837.456 -482.443

    0.0990 0.0428 2.3140 0.0292 0.0109 0.1871 0.011 0.187

    -0.8310 1.4201 -0.5852 0.5637 -3.7556 2.0937 -3.756 2.094

    167.9447 63.7112 2.6360 0.0142 36.7289 299.1605 36.729 299.160


    SUMMARY OUTPUT

    Regression Statistics
    Multiple R 0.5930481370776
    R Square 0.3517060928912
    Adjusted R Square 0.2479790677538
    Standard Error 8.2447948144221
    Observations 30

    ANOVA
    df SS MS F
    Regression 4 921.95062836865 230.487657092161 3.390689094046
    Residual 25 1699.416038298 67.9766415319209
    Total 29 2621.3666666667

    Coefficients Standard Error t Stat P-value


    Intercept 24.00722108848 6.6001077119522 3.63739837836353 0.001249057547
    X Variable 1 0.026964622082 0.0129486594604 2.08242576495175 0.047691740475
    X Variable 2 -0.010612089796 0.0072409278233 -1.4655704427015 0.15523047254
    X Variable 3 -0.41003224412 0.1339328195773 -3.0614769808786 0.005206520186
    X Variable 4 0.8935307194527 0.3639442192042 2.45513095772325 0.021385163611
    Significance F
    0.0239467974483

    Lower 95% Upper 95% Lower 95.0% Upper 95.0%


    10.41404480339 37.6003973736 10.41404480339 37.6003973736
    0.0002963587168 0.05363288545 0.0002963587168 0.05363288545
    -0.0255250598052 0.00430088021 -0.025525059805 0.00430088021
    -0.6858720495184 -0.13419243872 -0.685872049518 -0.13419243872
    0.1439735689499 1.64308786996 0.1439735689499 1.64308786996
    Y X1 X2 X3
    Reported
    Total overall
    Annual police reported violent % of 18 to 24 year-olds
    Year funding in crime rate per
    crime rate per 1 in college
    $/resident 100,000
    million residents
    residents

    1 40 478 184 31
    2 32 494 213 43
    3 57 643 347 16

    4 31 341 565 25
    5 67 773 327 29
    6 25 603 260 32
    7 34 484 325 24
    8 33 546 102 28
    9 36 424 38 25
    10 31 548 226 58
    11 35 506 137 21
    12 30 819 369 77
    13 44 541 109 37
    14 32 491 809 37

    15 30 514 29 35
    16 16 371 245 42
    17 29 457 118 21
    18 36 437 148 81
    19 30 570 387 31
    20 23 432 98 50
    21 33 619 608 24
    22 35 357 218 27
    23 38 623 254 22
    24 44 547 697 18
    25 28 792 827 23
    26 35 799 693 60
    27 31 439 448 14
    28 39 867 942 31
    29 27 912 1017 24
    30 36 462 216 23
    X4 SUMMARY OUTPUT

    % of people 25
    years+
    with at least 4
    years of college

    20 Regression Statistics
    18 Multiple R 0.593048137078
    16 R Square 0.351706092891
    Adjusted R
    19 Square 0.247979067754
    24 Standard Error 8.244794814422
    15 Observations 30
    14
    11
    12 ANOVA
    15 df SS
    9 Regression 4 921.9506283686
    36 Residual 25 1699.416038298
    12 Total 29 2621.366666667
    16

    11 Coefficients Standard Error


    14 Intercept 24.0072 6.6001
    10 X1 0.0270 0.0129
    27 X2 -0.0106 0.0072
    16 X3 -0.4100 0.1339
    15 X4 0.8935 0.3639
    8
    13
    11
    8
    11
    18
    12
    10
    9
    8
    MS F Significance F
    230.4876570922 3.390689094 0.0239467974
    67.97664153192

    Upper Lower Upper


    t Stat P-value Lower 95% 95% 95.0% 95.0%
    3.6374 0.0012 10.414 37.6004 10.414 37.600
    2.0824 0.0477 0.0003 0.0536 0.000 0.054
    -1.4656 0.1552 -0.0255 0.0043 -0.026 0.004
    -3.0615 0.0052 -0.6859 -0.1342 -0.686 -0.134
    2.4551 0.0214 0.1440 1.6431 0.144 1.643

    You might also like