The production of wine is a multibillion-dollar worldwide industry. In an attempt to develop a model of wine quality as judged by wine experts, data was collected from red wine variants. A sample of 20 wines is provided in the accompanying table. Develop a multiple linear regression model to predict wine quality, measured on a scale from 0 (very bad) to 10 (excellent) based on alcohol content (%) and the amount of chlorides. Complete parts a through g below.

Quality Alcohol_Content(%) Chlorides

0 7.6 0.064

2 7.6 0.067

3 8.8 0.071

3 7.7 0.075

1 8.1 0.066

2 9.3 0.071

2 8.6 0.075

3 9.2 0.071

5 10.8 0.076

5 10.2 0.084

7 10.8 0.081

7 10.8 0.078

7 10.7 0.084

7 11.9 0.089

8 11.3 0.096

7 11.3 0.099

9 11.9 0.148

8 11.7 0.149

9 12.5 0.155

10 12.9 0.158

State the multiple regression equation. Let X1i represent the alcohol content (%) of wine i and let X2i represent the number of chlorides for wine i.

Yi=_____+_____X1i+________X2i

(Round to two decimal places as needed.)

Predict the mean quality rating for wines that have 10% alcohol content and chlorides of

0.07.

The wine quality prediction for a wine that has 10% alcohol and 0.07 chlorides is _________

(Round to two decimal places as needed.)

Construct a 95% confidence interval estimate for the mean quality rating for wines that have

10% alcohol and 0.07 chlorides.The 95% confidence interval estimate of the mean quality rating for wines that have 10% alcohol and0.07

chlorides is _______ to ________.

(Round to one decimal place as needed.)

Construct a 95% prediction interval estimate for the quality rating for an individual wine that has

10% alcohol and 0.07 chlorides.The 95% prediction interval estimate of the quality rating for an individual wine that has 10% alcohol and 0.07 chlorides is _____ to _____.

(Round to one decimal place as needed.)