Regression Analysis using Transportation Data

$1.$ Look for the independent variable $($X$)$ and dependent variable $($Y$)$ that can provide policy implications in transportation system analysis. For instance, the population growth of Springfield over the past years and the transit ridership variations for the same time period can be explored.

Part A: Fundamental Analysis

$2.$ Collect the data you need to develop a simple regression model $($Y $=$ a $+$ bX$)$

$3.$ Plot the trend between two variables in Excel.

$4.$ Develop a simple regression model.

$5.$ Discuss the goodness$-$of$-$fit of the model.

$6.$ Explain $($interpret$)$ the model. Also, explain how your model can be used for transportation planning or engineering analysis.

Part B: Extended Analysis

$7.$ Develop a multi$-$variate regression model $($more than one explanatory variable$)$ and explain your model.

$8.$ Explain $($interpret$)$ the model. Also, explain how your model can be used for transportation planning or engineering analysis. If R$2$ is not acceptable, you may want to develop a different model with a different set of variables.