problem 1 you are given the following information for 20 office buildi

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)