Question

In: Math

HOUSEID TRAVDAY SAMPSTRAT HOMEOWN HHSIZE HHVEHCNT HHFAMINC PC SPHONE TAB WALK BIKE CAR TAXI BUS TRAIN...

HOUSEID TRAVDAY SAMPSTRAT HOMEOWN HHSIZE HHVEHCNT HHFAMINC PC SPHONE TAB WALK BIKE CAR TAXI BUS TRAIN PARA PRICE PLACE WALK2SAVE BIKE2SAVE PTRANS HHRELATD DRVRCNT CNTTDHH HHSTATE HHSTFIPS NUMADLT YOUNGCHILD WRKCOUNT TDAYDATE HHRESP LIF_CYC MSACAT MSASIZE RAIL URBAN URBANSIZE URBRUR SCRESP CENSUS_D CENSUS_R CDIVMSAR HH_RACE HH_HISP HH_CBSA RESP_CNT WEBUSE17 SMPLSRCE WTHHFIN HBHUR HTHTNRNT HTPPOPDN HTRESDN HTEEMPDN HBHTNRNT HBPPOPDN HBRESDN
30000007 2 3 1 3 5 7 2 1 2 5 5 1 5 4 5 5 1 2 4 4 4 1 3 6 NC 37 3 0 1 201608 1 10 3 1 2 1 1 1 1 5 3 53 2 2 XXXXX 3 1 2 187.3143 T 50 1500 750 750 20 750 300
30000008 5 2 1 2 4 8 1 1 2 4 4 1 5 5 5 5 5 2 4 4 5 1 2 2 WI 55 2 0 2 201608 2 2 2 5 2 4 6 2 1 3 2 32 1 2 33460 2 1 2 69.51303 R 5 300 300 150 5 300 300
30000012 5 3 1 1 2 10 1 1 3 2 5 1 5 4 4 5 2 1 2 3 5 2 1 9 NY 36 1 0 1 201607 1 1 3 3 2 1 3 1 1 2 1 23 1 2 XXXXX 1 1 2 79.41959 C 80 17000 17000 5000 60 17000 7000
30000019 5 3 1 2 2 3 1 5 5 2 5 1 5 5 5 5 2 3 2 3 3 1 2 4 MD 24 2 0 0 201605 1 2 3 2 2 1 1 1 1 5 3 53 1 2 XXXXX 2 1 2 279.1436 S 40 300 300 150 50 750 300
30000029 3 3 1 2 2 5 2 5 1 -9 -9 1 -9 -9 -9 -9 3 2 5 5 5 1 2 10 WI 55 2 0 0 201610 1 10 3 3 2 1 2 1 1 3 2 33 1 2 XXXXX 2 1 2 103.2403 S 40 1500 750 750 40 1500 750
30000039 5 3 1 2 2 10 1 3 5 5 5 1 5 5 5 5 5 3 5 5 5 1 2 11 PA 42 2 0 1 201609 1 2 3 3 2 1 3 1 1 2 1 23 1 2 XXXXX 2 1 1 2329.525 S 40 7000 1500 1500 5 3000 1500
30000041 4 3 1 2 2 11 1 1 1 1 4 1 3 4 4 5 5 5 5 5 5 1 2 6 CA 6 2 0 2 201606 1 2 3 3 1 1 2 1 1 9 4 93 1 2 XXXXX 2 1 2 788.6142 T 40 300 50 25 40 300 300
30000062 5 4 1 2 6 10 1 1 1 4 5 1 4 5 5 5 3 3 4 5 5 1 2 6 TX 48 2 0 1 201609 1 10 4 6 2 4 6 2 1 7 3 74 1 2 XXXXX 2 1 2 294.5018 R 20 50 50 25 5 50 50
30000082 3 3 2 4 2 8 1 1 5 -9 5 1 5 5 5 5 3 3 5 5 5 1 2 12 NY 36 2 2 2 201605 1 4 3 3 2 1 3 1 1 2 1 23 1 2 XXXXX 4 1 2 1148.809 T 20 1500 300 750 30 750 300
30000085 1 2 1 1 2 9 1 1 4 1 4 2 3 5 5 5 5 3 4 4 3 2 1 6 CA 6 1 0 1 201608 1 1 2 5 2 1 4 1 1 9 4 92 97 1 41740 1 1 2 190.669 U 50 17000 17000 5000 50 30000 17000
30000089 6 3 1 4 2 7 2 1 4 5 5 1 5 5 5 5 5 3 5 5 5 1 2 4 TX 48 2 2 2 201612 1 4 3 3 2 4 6 2 1 7 3 73 1 1 XXXXX 4 1 2 833.6213 T 20 1500 750 750 30 1500 300
30000094 3 3 2 1 1 4 1 1 5 4 4 1 4 5 5 5 2 2 2 2 3 2 1 4 CA 6 1 0 1 201610 1 1 3 1 2 1 1 1 1 9 4 93 1 1 XXXXX 1 1 2 163.3823 T 20 300 300 150 20 300 300
30000095 6 3 1 1 1 6 2 5 5 4 2 1 5 5 5 5 4 3 3 3 5 2 1 9 WI 55 1 0 0 201607 1 9 3 3 2 1 2 1 1 3 2 33 1 2 XXXXX 1 2 2 41.93445 S 5 7000 3000 3000 5 7000 3000
30000107 6 2 1 2 3 8 1 2 5 4 4 1 5 5 4 5 3 4 4 4 5 1 2 11 TX 48 2 0 0 201612 1 2 2 5 2 1 4 1 1 7 3 72 1 2 19100 2 1 2 60.00456 C 5 7000 1500 3000 20 7000 1500
30000128 1 3 2 2 2 1 1 1 5 3 5 1 5 5 4 5 4 4 4 4 4 2 2 2 ME 23 2 0 0 201605 1 2 3 1 2 1 1 1 1 1 1 13 1 2 XXXXX 2 1 1 7092.269 C 30 300 300 150 60 3000 1500

PROBLEM 1: Estimate the average number of trip generated by households in the study area by (a) Number of workers in the household (b) Number of students in the household (c) Number of vehicles in the household (d) Household size (Number of people in the household)

Solutions

Expert Solution

average=sum/n

Estimate the average number of trip generated by households in the study area =4

TRAVDAY
n= 15
sum= 60
average= 4

(a)average Number of workers in the household =1

WRKCOUNT
n= 14
sum= 14
average= 1

(b)average Number of students in the household=?

I could not find appropiate abbreviation for this variable, please re-check your data and find the average for this variable using average=sum/n

(c)Average Number of vehicles in the household=2.5333

HHVEHCNT
n= 15
sum= 38
average= 2.53333333

(d) average house hold size=2.0667

HHSIZE
n= 15
sum= 31
average= 2.0667

following information has been generated using ms-excel

HOUSEID TRAVDAY SAMPSTRAT HOMEOWN HHSIZE HHVEHCNT HHFAMINC PC SPHONE TAB WALK BIKE CAR TAXI BUS TRAIN PARA PRICE PLACE WALK2SAVE BIKE2SAVE PTRANS HHRELATD DRVRCNT CNTTDHH HHSTATE HHSTFIPS NUMADLT YOUNGCHILD WRKCOUNT TDAYDATE HHRESP LIF_CYC MSACAT MSASIZE RAIL URBAN URBANSIZE URBRUR SCRESP CENSUS_D CENSUS_R CDIVMSAR HH_RACE HH_HISP HH_CBSA RESP_CNT WEBUSE17 SMPLSRCE WTHHFIN HBHUR HTHTNRNT HTPPOPDN HTRESDN HTEEMPDN HBHTNRNT HBPPOPDN HBRESDN
30000007 2 3 1 3 5 7 2 1 2 5 5 1 5 4 5 5 1 2 4 4 4 1 3 6 NC 37 3 0 1 201608 1 10 3 1 2 1 1 1 1 5 3 53 2 2 XXXXX 3 1 2 187.3143 T 50 1500 750 750 20 750 300
30000008 5 2 1 2 4 8 1 1 2 4 4 1 5 5 5 5 5 2 4 4 5 1 2 2 WI 55 2 0 2 201608 2 2 2 5 2 4 6 2 1 3 2 32 1 2 33460 2 1 2 69.51303 R 5 300 300 150 5 300 300
30000012 5 3 1 1 2 10 1 1 3 2 5 1 5 4 4 5 2 1 2 3 5 2 1 9 NY 36 1 0 1 201607 1 1 3 3 2 1 3 1 1 2 1 23 1 2 XXXXX 1 1 2 79.41959 C 80 17000 17000 5000 60 17000 7000
30000019 5 3 1 2 2 3 1 5 5 2 5 1 5 5 5 5 2 3 2 3 3 1 2 4 MD 24 2 0 0 201605 1 2 3 2 2 1 1 1 1 5 3 53 1 2 XXXXX 2 1 2 279.1436 S 40 300 300 150 50 750 300
30000029 3 3 1 2 2 5 2 5 1 -9 -9 1 -9 -9 -9 -9 3 2 5 5 5 1 2 10 WI 55 2 0 0 201610 1 10 3 3 2 1 2 1 1 3 2 33 1 2 XXXXX 2 1 2 103.2403 S 40 1500 750 750 40 1500 750
30000039 5 3 1 2 2 10 1 3 5 5 5 1 5 5 5 5 5 3 5 5 5 1 2 11 PA 42 2 0 1 201609 1 2 3 3 2 1 3 1 1 2 1 23 1 2 XXXXX 2 1 1 2329.525 S 40 7000 1500 1500 5 3000 1500
30000041 4 3 1 2 2 11 1 1 1 1 4 1 3 4 4 5 5 5 5 5 5 1 2 6 CA 6 2 0 2 201606 1 2 3 3 1 1 2 1 1 9 4 93 1 2 XXXXX 2 1 2 788.6142 T 40 300 50 25 40 300 300
30000062 5 4 1 2 6 10 1 1 1 4 5 1 4 5 5 5 3 3 4 5 5 1 2 6 TX 48 2 0 1 201609 1 10 4 6 2 4 6 2 1 7 3 74 1 2 XXXXX 2 1 2 294.5018 R 20 50 50 25 5 50 50
30000082 3 3 2 4 2 8 1 1 5 -9 5 1 5 5 5 5 3 3 5 5 5 1 2 12 NY 36 2 2 2 201605 1 4 3 3 2 1 3 1 1 2 1 23 1 2 XXXXX 4 1 2 1148.809 T 20 1500 300 750 30 750 300
30000085 1 2 1 1 2 9 1 1 4 1 4 2 3 5 5 5 5 3 4 4 3 2 1 6 CA 6 1 0 1 201608 1 1 2 5 2 1 4 1 1 9 4 92 97 1 41740 1 1 2 190.669 U 50 17000 17000 5000 50 30000 17000
30000089 6 3 1 4 2 7 2 1 4 5 5 1 5 5 5 5 5 3 5 5 5 1 2 4 TX 48 2 2 2 201612 1 4 3 3 2 4 6 2 1 7 3 73 1 1 XXXXX 4 1 2 833.6213 T 20 1500 750 750 30 1500 300
30000094 3 3 2 1 1 4 1 1 5 4 4 1 4 5 5 5 2 2 2 2 3 2 1 4 CA 6 1 0 1 201610 1 1 3 1 2 1 1 1 1 9 4 93 1 1 XXXXX 1 1 2 163.3823 T 20 300 300 150 20 300 300
30000095 6 3 1 1 1 6 2 5 5 4 2 1 5 5 5 5 4 3 3 3 5 2 1 9 WI 55 1 0 0 201607 1 9 3 3 2 1 2 1 1 3 2 33 1 2 XXXXX 1 2 2 41.93445 S 5 7000 3000 3000 5 7000 3000
30000107 6 2 1 2 3 8 1 2 5 4 4 1 5 5 4 5 3 4 4 4 5 1 2 11 TX 48 2 0 0 201612 1 2 2 5 2 1 4 1 1 7 3 72 1 2 19100 2 1 2 60.00456 C 5 7000 1500 3000 20 7000 1500
30000128 1 3 2 2 2 1 1 1 5 3 5 1 5 5 4 5 4 4 4
n= 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 14 14 14 14 14 0 14 14 14 14 14 14 14 14 14 14 14 14 14 14 14 14 14 14 14 3 14 14 14 14 0 14 14 14 14 14 14 14
sum= 60 43 18 31 38 107 19 30 53 26 53 16 55 58 57 61 52 43 58 57 63 18 25 100 0 502 25 4 14 2822516 15 60 40 46 27 23 44 17 14 73 36 770 111 25 94300 29 15 27 6569.692 0 435 62250 43550 21000 380 70200 32900
average= 4 2.866667 1.2 2.066667 2.533333 7.133333 1.266667 2 3.533333 1.733333 3.533333 1.066667 3.666667 3.866667 3.8 4.066667 3.466667 2.866667 3.866667 4.071429 4.5 1.285714 1.785714 7.142857 #DIV/0! 35.85714 1.785714 0.285714 1 201608.3 1.071429 4.285714 2.857143 3.285714 1.928571 1.642857 3.142857 1.214286 1 5.214286 2.571429 55 7.928571 1.785714 31433.33 2.071429 1.071429 1.928571 469.2637 #DIV/0! 31.07143 4446.429 3110.714 1500 27.14286 5014.286 2350

Related Solutions

There are 3 users, Smart, Tab, or PC that attempt to access an online store. The...
There are 3 users, Smart, Tab, or PC that attempt to access an online store. The probability that seeing a smart is 0.5, Tab is 0.25, PC is 0.25. They either request either audio or video. Smart request audio with probability 0.5; tab request audio with probability of 0.4; and PC request audio with probability 0.3. a) What is the probability that a user request video is a tablet? b) What is the probability that a user request audio is...
Write the standard momentum equation for one train car colliding and hooking with another immobile train...
Write the standard momentum equation for one train car colliding and hooking with another immobile train car if both cars have a mass of M: What type of collision? If the second car was to jump ahead and the two didn’t connect together what would be the new equation? What type of collision? C. If the mass of each car is 7000kg and the final velocity of the trains after collision is 2m/s. Then solve the equation described above.   ...
Consider shaping and chaining procedures. You need to train a teenager to take a public bus...
Consider shaping and chaining procedures. You need to train a teenager to take a public bus to school every day. The teen has never taken this bus or traveled this bus route before. Describe the procedure you would use. Describe the steps that would be involved. In other words create a task analysis. Consider the use of prompts and prompt fading. Given the current world events we need to teach middle school kids how to social distance while in school....
A train car with mass m1 = 576 kg is moving to the right with a...
A train car with mass m1 = 576 kg is moving to the right with a speed of v1 = 7 m/s and collides with a second train car. The two cars latch together during the collision and then move off to the right at vf = 4.4 m/s. A)What is the initial momentum of the first train car? B)What is the mass of the second train car? C)What is the change in kinetic energy of the two train system...
A cannon on a train car fires a projectile to the right with speed v0, relative...
A cannon on a train car fires a projectile to the right with speed v0, relative to the train, from a barrel elevated at angle θ. The cannon fires just as the train, which had been cruising to the right along a level track with speed vtrain, begins to accelerate with acceleration a, which can be either positive (speeding up) or negative (slowing down). Find an expression for the angle at which the projectile should be fired so that it...
You are trying to decide between taking the bus to work or buying a car and...
You are trying to decide between taking the bus to work or buying a car and driving. Assume that a bus pass costs $100/month but that when you use the bus you also need to take a taxi to/from the bus stop at an additional cost of $120/month. You can buy a good used car for $5000. It will last for 5 years and be worthless at the end of that time. In addition, gas and parking cost $125/month. Your...
1. The taxi company you work for is considering buying a $50,000 car which they expect...
1. The taxi company you work for is considering buying a $50,000 car which they expect to last two years. Operating & Maintenance O&M costs are $12,000 per year. The car is expected to generate $32,000 in revenues per year. The tax rate is 30%. The company’s minimum acceptable rate of return (MARR) is 20%. The taxi company uses a declining balance method for depreciation. The book balance of the car value at the end of year 0 is the...
A taxi driver in Manhattan is sitting in his car passing time until someone needs a...
A taxi driver in Manhattan is sitting in his car passing time until someone needs a ride. Unbeknownst to the taxi driver, a man in a nearby alley is robbing two people. After the robber has completed the crime, he runs around the corner and jumps into the taxi. The robber tells the driver to floor it, and to emphasize his point, he puts a gun to the taxi driver's head. The driver puts the car in gear and takes...
PC.62 Trek is a manufacturing company that produces high-end bicycles. Their prime road bike, the MadOne,...
PC.62 Trek is a manufacturing company that produces high-end bicycles. Their prime road bike, the MadOne, can be fully customized through a program called Project One. Last year they rolled out 1,270 bikes which sold on average for $7,900 and used the following inputs as found in the table below: Inputs Amount   Cost ($) Labor Hours 17,400 $19.00 OCLV Carbon (square feet)   1,600 $14.07 Rubber (pounds) 3,375 $4.16 Paint (gallons) 420 $21.84 Energy (kWh) 12,287,180 $0.11 What was last year's...
3. While practicing social distancing, it’s good to still go outside for a walk, bike ride,...
3. While practicing social distancing, it’s good to still go outside for a walk, bike ride, or observing nature. While going on a walk and making sure there is always at least 6 ft between you and others, you discover a new tree. In fact, you discover a whole forest of this tree that grows ICE CREAM. Some trees grow pistachio ice cream, and others grow chocolate peanut butter ice cream (to clarify, I mean chocolate ice cream with peanut...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT