Perform a SLR with your dependent variable and the independent quantitative variable having the highest correlation with your dependent variable. a. State the population regression model to be estimated. b. Describe the goodness of fit of the estimated regression line. c. State the least-squares estimates of the slope and the intercept. d. Give practical meanings (interpret the values) to the estimated slope and intercept. Fit a multiple linear regression model to predict sales using all independent variables a. State the population regression model to be estimated. b. Describe the goodness of fit of the estimated regression line. c. State the least-squares estimates of the model. d. Give practical meanings (interpret the values) to the parameters of the model e. Test the individual significance of the parameters. Use alpha=0.05. f. Test the overall significance of the model. Use alpha=0.05. 5. Fit another multiple linear regression to the dependent variable. Use only the variables that you found to be significant on question 4 . a. Use a Partial F-test to compare the model fitted in question 4 to the model fitted in question 5. Based on this test, which of the two models is the preferred one? Comment on why this is the preferred model. Use alpha=0.05 b. Calculate the residuals, standardized residuals, studentized residuals, cook's distance and leverage. Are there any outliers or influential observations? c. make residual plot. Use a Durbin Watson test to evaluate if the assumption of independence of residuals is met for the model fitted in question 5. Please show work using excel with calculations