Upload the Neth.CSV data file to google colab. Estimate a linear regression model of number of weekly trips per household as a function of the remaining variables (to the extent possible). In the final model identify which variables contribute to an increase in number of weekly trips and which variables contribute to a decrease in the number of weekly trips.
In estimating a linear regression model these are the steps I want you to do:
- Run multiple linear regression by including all variables
- Check for multi-collinearity and remove appropriate variables.
- Check if all variables are significant and remove the variables which are not significant one by one.
- Report the R2 and Adjusted R2 of the final model
- Check if the mean of the residuals is close to zero. Comment on the mean.
- Plot the histogram of the standardized residuals. Comment on whether the standardized residuals look normal.
- Check for outliers.
- Plot the residuals vs fitted values and comment.
The variable definitions are:
• HHSIZE household size
• NCAR number of cars in household
• HEMPSTS number of workers in household
• HSTUDEN number of students in household
• HTTRPS number of weekly trips per household
• NUCHLT12 number of children < 12 years in household
• CITY household residence in city (dummy variable)
• SUBURB household residence in suburb (dummy variable) • RURAL household residence in rural area (dummy variable)• INCOME continuous household income value
• NUCHGT12 number of children >= 12 yrs in household
