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