1. It is common to use multiple regression in the transportation planning process to predict the number of trips that will be made in any geographic area (zone) of a region. Trip frequency is generally expressed as a function of distance of a zone to the Central Business District {CBDj and number of autos owned within the zone. The following data come from the Penn-Jerseyr Transportation Study. Use or = .01. Total Person Linear Distance Number ofAutos Zone Trips leUOsi to the CED jMilesj Owned leUDsj 1 592 1.6 69 Z 31? 2.1 11 3 135 3.9 22 4 178 3.0 60 5 262 (1.3 38 6 82 6.1 15 7 392 5.9 6:1 8 156 6.0 67 9 88 9.8 13 10 136 6.1 22 11 39 9.1 3 1. To carry out the forecasting procedure, a regression model is used to determine the relationship between the dependent variable total person trips and the independent variables distance to the CBD and number ofoutos owned. Derive the regression equation for the sample data using R, generating the parameter estimates. standard errors for the estimates of B2 and I31. and the R2 and adjusted R2. 2. Interpret the parameter estimates in the regression equation, the R2. the adjusted R2, the standard error of the regression, the coefficient of variation, and the standardized beta values. 3. Generate and interpret two scattergrams that include the bivariate regression line, one for total person trips and distance, and one for totoi' person trips and autos owned. Include appropriate descriptive labels. 4. Test the hypothesis that there is no relationship between the dependent variable and the independent variables taken jointly [i.e., test the significance of the regression]. Then test the hypotheses that distance and autos owned are each unrelated to the dependent variable. Interpret your results. 5. Generate and interpret the diagnostic plots for the regression and indicate whether any issues or problems are present. If an issue or problem is present, describe it and identify the possible causes that might contribute to its shape. 6. Predict the number of total person trips that would occur if the number of autos owned in zone 9 increased from 13 thousand to 15 thousand. Then predict total person trips for a new zone that was 8.2 miles from the CBD and contained 18 thousand owned autos. [Note that you do NOT need to rerun the regression analysis. Simply use the parameter estimates derived above and plug in the indicated values of the independent variables, being consistent in units of measurement.) Are these predictions reliable? Why or whyr not? 7. Predict the number of total person trips for a new zone that was 62.4 miles from the CBD and contained 600 owned autos. Are these predictions reliable? Why or why not? ]