You are a transportation planner with MPO. Using the data below, you are requested

by the MPO technical committee to perform the following

$1)$ Estimate the correlation coefficient for the bivariate data $($trip ends and

dwelling units$)$ and determine whether or not there is a significant Correlation

between these pair of data sets

$2)$ Develop a regression model, which you would use later to undertake a trip

generation analysis. Use trip ends as dependent variable and dwelling units as

the independent variable in your regression analysis

$3)$ Make a recommendation to the committee regarding the suitability of your

regression model for the trip generation analysis. In other words, determine

whether or not the regression coefficient is significant

$4)$ Using Excel or a software of your choice, perform a multiple regression

analysis. Use trip ends as the dependent variable and dwelling units, auto

ownership, and family income as the independent variables. Is this model

suitable for planning applications?

Subdivision Trip Ends Dwelling

Units

Avg

Vehicles$/$DU

Avg

Income

Fine Oak $100151\mathrm{.}215000$

Fine Ebony $150251\mathrm{.}520000$

Grape Vine $250302\mathrm{.}130000$

Saka Esate $200301\mathrm{.}835000$

Oak Woods $75101\mathrm{.}830000$

Pine Tar $120152\mathrm{.}540000$

Quantum $250153\mathrm{.}150000$

Rooster Haven $5071\mathrm{.}625000$

Zodiac $10092\mathrm{.}230000$