0 0 0 0 652 1364 11076 6585 0216 0138 0002 1543 0686 0514 0343 0171 0171 0822

0 0 0 0 652 1364 11076 6585 0216 0138 0002 1543 0686

This preview shows page 9 - 14 out of 14 pages.

0 | 0 | 0 | 0 | 652 | ## | 1.364 | 11.076 | 6.585 | 0.216 | 0.138 | 0.002 | 1.543 | 0.686 | 0.514 | 0.343 | 0.171 | 0.171 | | ## | 0.822 | 0.080 | 0.072 | 0.012 | 0.011 | 0.003 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.171 | ## | 0.163 | 0.271 | 0.249 | 0.145 |
Image of page 9
10 K.PRAVALLIKA | CE15B079 0.149 | 0.167 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | | ## | 0.141 | 0.014 | 0.012 | 0.002 | 0.002 | 0.001 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | | ## ------------------------|-----------|-----------|-----------|-----------|- ----------|-----------|-----------|-----------|-----------|-----------|------ -----|-----------|-----------| ## 4 | 482 | 30 | 41 | 16 | 8 | 3 | 6 | 2 | 2 | 1 | 1 | 1 | 593 | ## | 1.840 | 0.000 | 4.518 | 6.432 | 0.062 | 0.682 | 15.062 | 3.038 | 5.021 | 1.519 | 4.571 | 4.571 | | ## | 0.813 | 0.051 | 0.069 | 0.027 | 0.013 | 0.005 | 0.010 | 0.003 | 0.003 | 0.002 | 0.002 | 0.002 | 0.156 | ## | 0.147 | 0.156 | 0.217 | 0.291 | 0.170 | 0.250 | 0.667 | 0.500 | 0.667 | 0.500 | 1.000 | 1.000 | | ## | 0.127 | 0.008 | 0.011 | 0.004 | 0.002 | 0.001 | 0.002 | 0.001 | 0.001 | 0.000 | 0.000 | 0.000 | | ## ------------------------|-----------|-----------|-----------|-----------|- ----------|-----------|-----------|-----------|-----------|-----------|------ -----|-----------|-----------| ## 5 | 186 | 21 | 17 | 8 | 13 | 3 | 2 | 1 | 0 | 1 | 0 | 0 | 252 | ## | 4.666 | 5.391 | 1.603 | 5.209 | 31.392 | 6.116 | 3.305 | 2.039 | 0.199 | 5.680 | 0.066 | 0.066 | | ## | 0.738 | 0.083 | 0.067 | 0.032 | 0.052 | 0.012 | 0.008 | 0.004 | 0.000 | 0.004 | 0.000 | 0.000 | 0.066 | ## | 0.057 | 0.109 | 0.090 | 0.145 | 0.277 | 0.250 | 0.222 | 0.250 | 0.000 | 0.500 | 0.000 | 0.000 | | ## | 0.049 | 0.006 | 0.004 | 0.002 | 0.003 | 0.001 | 0.001 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | | ## ------------------------|-----------|-----------|-----------|-----------|- ----------|-----------|-----------|-----------|-----------|-----------|------ -----|-----------|-----------| ## 6 | 54 | 4 | 6 | 1 | 2 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 69 | ## | 0.537 | 0.077 | 1.929 | 0.000 | 1.544 | 0.218 | 0.163 | 11.855 | 16.431 | 0.036 | 0.018 | 0.018 | |
Image of page 10
11 K.PRAVALLIKA | CE15B079 ## | 0.783 | 0.058 | 0.087 | 0.014 | 0.029 | 0.000 | 0.000 | 0.014 | 0.014 | 0.000 | 0.000 | 0.000 | 0.018 | ## | 0.016 | 0.021 | 0.032 | 0.018 | 0.043 | 0.000 | 0.000 | 0.250 | 0.333 | 0.000 | 0.000 | 0.000 | | ## | 0.014 | 0.001 | 0.002 | 0.000 | 0.001 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | | ## ------------------------|-----------|-----------|-----------|-----------|- ----------|-----------|-----------|-----------|-----------|-----------|------ -----|-----------|-----------| ## 7 | 13 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | ## | 0.000 | 0.757 | 0.745 | 2.828 | 0.185 | 19.181 | 0.035 | 0.016 | 0.012 | 0.008 | 0.004 | 0.004 | | ## | 0.867 | 0.000 | 0.000 | 0.067 | 0.000 | 0.067 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.004 | ## | 0.004 | 0.000 | 0.000 | 0.018 | 0.000 | 0.083 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | | ## | 0.003 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | | ## ------------------------|-----------|-----------|-----------|-----------|- ----------|-----------|-----------|-----------|-----------|-----------|------ -----|-----------|-----------| ## 8 | 3 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | ## | 0.405 | 2.215 | 0.248 | 11.905 | 0.062 | 0.016 | 0.012 | 0.005 | 0.004 | 0.003 | 0.001 | 0.001 | | ## | 0.600 | 0.200 | 0.000 | 0.200 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.001 | ## | 0.001 | 0.005 | 0.000 | 0.018 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | | ## | 0.001 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | | ## ------------------------|-----------|-----------|-----------|-----------|- ----------|-----------|-----------|-----------|-----------|-----------|------ -----|-----------|-----------| ## 9 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Image of page 11
12 K.PRAVALLIKA | CE15B079 0 | 1 | ## | 0.021 | 0.050 | 0.050 | 0.014 | 0.012 | 0.003 | 0.002 | 0.001 | 0.001 | 0.001 | 0.000 | 0.000 | | ## | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | ## | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | | ## | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | | ## ------------------------|-----------|-----------|-----------|-----------|- ----------|-----------|-----------|-----------|-----------|-----------|------ -----|-----------|-----------| ## 10 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | ## | 0.021 | 0.050 | 0.050 | 0.014 | 0.012 | 0.003 | 0.002 | 0.001 | 0.001 | 0.001 | 0.000 | 0.000 | | ## | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | ## | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | | ## | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | | ## ------------------------|-----------|-----------|-----------|-----------|- ----------|-----------|-----------|-----------|-----------|-----------|------ -----|-----------|-----------| ## Column Total | 3289 | 192 | 189 | 55 | 47 | 12 | 9 | 4 | 3 | 2 | 1 | 1 | 3804 | ## | 0.865 | 0.050 | 0.050 | 0.014 | 0.012 | 0.003 | 0.002 | 0.001 | 0.001 | 0.001 | 0.000 | 0.000 | | ## ------------------------|-----------|-----------|-----------|-----------|- ----------|-----------|-----------|-----------|-----------|-----------|------ -----|-----------|-----------| ## ## ## Statistics for All Table Factors ## ## ## Pearson's Chi-squared test ## ------------------------------------------------------------
Image of page 12
13 K.PRAVALLIKA | CE15B079 ## Chi^2 = 299.9987 d.f. = 110 p = 1.559457e-19 ## ## ## From the above chi-square test result, since p-value is very less, thus the null hypothesis can be rejected and it can be said that they are dependent variables. (i) fit = lm (tottrips ~ data2 $ hhsize + data2 $ hhincdd + data2 $ numvehrc + data2 $ males + data2 $ parttime) x = summary (fit) summary (fit) ## ## Call: ## lm(formula = tottrips ~ data2$hhsize + data2$hhincdd + data2$numvehrc + ## data2$males + data2$parttime) ## ## Residuals: ## Min 1Q Median 3Q Max ## -17.7564 -2.4438 -0.4664 1.8257 25.1126 ## ## Coefficients: ## Estimate Std. Error t value Pr(>|t|) ## (Intercept) 2.36850 0.17957 13.190 < 2e-16 *** ## data2$hhsize 1.67557 0.07795 21.496 < 2e-16 *** ## data2$hhincdd 0.11112 0.05273 2.108 0.035148 * ## data2$numvehrc 1.09339 0.08427 12.975 < 2e-16 *** ## data2$males 0.40849 0.10511 3.886 0.000104 *** ## data2$parttime 0.55531 0.11037 5.032 5.12e-07 *** ## --- ## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1 ## ## Residual standard error: 4.064 on 3326 degrees of freedom ## (472 observations deleted due to missingness) ## Multiple R-squared: 0.4125, Adjusted R-squared: 0.4116 ## F-statistic: 467.1 on 5 and 3326 DF, p-value: < 2.2e-16 summary = data.frame (x $ coefficients) summary ## Estimate Std..Error t.value Pr...t.. ## (Intercept) 2.3685020 0.17957247 13.189672 9.301125e-39 ## data2$hhsize 1.6755714 0.07794888 21.495772 4.413432e-96 ## data2$hhincdd 0.1111204 0.05272599 2.107507 3.514829e-02 ## data2$numvehrc 1.0933861 0.08426938 12.974891 1.367120e-37 ## data2$males 0.4084915 0.10510890 3.886365 1.037408e-04 ## data2$parttime 0.5553149 0.11036762 5.031502 5.124555e-07
Image of page 13
14 K.PRAVALLIKA | CE15B079 The above model can explain about 41% of the total trips data. All the variables used in the above odel are signficant.The coefficients of the variables do make sense as it is expected that the number of trips increases with an increase in household size, number of vehicles, household income, number of males and number of part-time workers.This can be seen in the model as the coefficients of all the vaiables are positive. VARIABLE CO-EFFICIENT STD. ERROR T-STATISTIC P-VALUE (Intercept) 2.3685020 0.17957247 13.189672 9.301125e-39 data2$hhsize 1.6755714 0.07794888 21.495772 4.413432e-96 data2$hhincdd 0.1111204 0.05272599 2.107507 3.514829e-02 data2$numvehrc 1.0933861 0.08426938 12.974891 1.367120e-37 data2$males 0.4084915 0.10510890 3.886365 1.037408e-04 data2$parttime 0.5553149 0.11036762 5.031502 5.124555e-07
Image of page 14

You've reached the end of your free preview.

Want to read all 14 pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes