The quality of wine is impacted by the wine's Density, Volatile Acidity (%), Residual Sugar (grams), and Alcohol (%). A sommelier is trying to estimate the quality of the wine based on these four variables. The sommelier has collected some data on 200 wines. The sommelier would like to build a multiple regression model to estimate the quality based on these four variables. a) Using Excel's Correlation procedure, determine which of these variables has the highest correlation with quality.

Which variable has the highest correlation with quality?

b) Prepare a scatter plot showing the relationship between the quality and variable you identified in part a. Properly format (trend line with equation, modify equation with variable names rather than x & y, axes labels, etc.) this scatterplot and paste into a Word document with a Figure number. Write an interpretation which discusses the model fit and write the regression equation.

c) Perform the backward stepwise procedure, which is the first variable that is removed in the procedure?

d) After completing the backward stepwise procedure, which independent variables remain in the model?

e) Create an ANOVA table for your best model (based on your answer to part (d) (using Excel's Regression procedure), format it to show no more than 3 decimal places and remove duplicate columns. Copy and paste it at of the end of the Word document you created in part (b).

f) How do you use the value of Significance F in the multiple regression model?

g) Based on your best model (part d), how should the sommelier estimate the quality of a wine with a Density of 1.0, Volatile Acidity of 0.70%, Residual Sugar of 2 grams, and Alcohol of 12%?

h) Considering all four independent variables, does there appear to be any multicollinearity among the independent variables? i) How can you tell if you have multicollinearity