Question

Seatwork no. 1 (Individual Work)h Five years ago, fifty households in City X were randomly sampled for household income, household size, autos per household, and daily trips produced HH Household Household Trips Autos Income Size (Peso) 1 C 2 45000 2 4 70000 10 170000 C 110000 5 1 2 55000 6 15 170000 7 4 95000 90000 6 1 70000 10 13 190000 11 2 180000 17 210000 13 85000 2 14 11 110000 2 15 10 2 110000 5 16 11 130000 6 2 17 12 150000 18 8 110000 3 19 130000 4 20 150000 21 35000 C 22 50000 1 23 4 75000 24 10 155000 5 2 25 2 124000 26 7 140000 3 1 27 200000 28 3 35000 2 C 29 6 100000 4 C 30 8 167000 E 4 31 85000 C 32 5 130000 1 33 10 160000 6 34 90000 7 1 1 35 4 100000 36 5 75000 2 1 37 3 125000 1 1 140000 38 1 2 135000 6 39 7 150000 40 0 1 150000 55000 41 3 2. 42 6 2 3 100000 120000 160000 43 5 44 3 45 6 C 2 85000 46 4 80000 47 3 500000 48 0 48000 49 12 6 110000 50 Develop a trip matrix in terms pf trips per HH based on family income and auto availability using the ranges given below by simple category analysis. a. Autos Available Income (Thousand Pesos) per month S 59.999 2 or more 1 C 60-99.999 100-149.999 150 b. Develop a trip matrix in terms pf trips per HH based on household size and auto availability using the ranges given below by simple category analysis. Autos Available HH Size 2 or more 1 2 3 4 By group: Develop equations using Regression Analysis

Answer 1

a. Autos Available Income (Thousand Pesos) per month 1 2 or more Total C =59.666 31 20 5 6 60-99.999 13 7 44 100-149.999 45 101 17 39 150 28 112 143 319 Total 164 53 102 b. Autos Available HH Size Total 0 1 2 or more 1 6 12 20 2 17 24 12 53 3 10 39 26 75 171 4 20 27 124 Total 53 102 164 319 LO N 24

Regression Statistics Multiple R 0.832521473 R Square 0.693092003 Adjusted R Square 0.680032088 Standard Error 1.89129058 Observations 50 Coefficients Standard Error P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% t Stat 0.84109797 -2.105084812 -0.631993421 0.84109797 Intercept 0.732247216 -0.863087502 0.392472343 -2.105084812 X Variable 1 2.087808707 0.258651655 8.071893865 1.98999E-10 1.567468694 2.608148721 1.567468694 2.608148721 X Variable 2 1.059548434 0.373445901 0.00669622 2,83722068 0.308272185 0.308272185 1.810824683 1.810824683 Y-.63192.0878*X1 + 1.0595X2