Question

Problem 1 You are given the following information for 20 Office buildings located in downtown Brooklyn. (Refer to table below). Using Excel estimate the following: 1. Average office building space (in sq. ft.). (1/10 pts) 2. Average number of employees per building. (1/10 pts) 3. Total number of person-trips which use auto mode (assuming 15% are auto users). Note: Each employee makes two trips per day. (1/10 pts) 4. Total number of person-trips which use bus mode (assuming 15% are bus users). (1/10 pts) 5. Total number of person-trips which use the subway mode (assuming 60% are subway users). (1/10 pts) 6. Total number of person-trips which use the rail mode (LIRR) (assuming are 10% rail users). (1/10 pts) 7. Vehicle-trips per building (auto + bus) assuming auto occupancy of 1.25 persons/auto and a bus occupancy of 40 persons/bus. (1/10 pts) 8. Plot a scatter chart of office building space (sq. ft.) on X-axis vs. total number of vehicle-trips on Y-axis. (1/10 pts) 9. Calculate a best-fit linear regression equation and graph/trendline which can be used to estimate future planned developments of this type. Make sure to fit a model whose y-intercept is zero (i.e., when size of building is zero the vehicle-trips should also be zero. (1/10 pts) 10.Estimate the number of vehicle-trips for a planned office building of 280,000 sq.ft. using the generated regression equation. (1/10 pts)