Question

The production of wine is a multibillion-dollar world-wide industry. In an attempt to develop a model of wine qual-ity as judged by wine experts, data was collected from red wine variants of Portuguese “Vinho Verde” wine. A sample of 50 wines is stored in VinhoVerde . Develop a multiple linear regression model to predict wine quality, measured on a scale from 0 (very bad) to 10 (excel-lent) based on alcohol content (%) and the amount of chlorides.

State the multiple regression equation. Please use Excel. I cant seem to get it to work with "data analysis"

Alcohol	Chlorides	Quality
10.1	0.067	6
11.8	0.064	6
9	0.076	5
9.6	0.097	5
12.8	0.078	8
9.7	0.077	6
9.6	0.091	6
9.5	0.073	5
10.6	0.071	6
9.4	0.077	5
10.6	0.105	6
10.5	0.074	5
10.8	0.07	6
10.5	0.084	6
11.3	0.174	6
10.7	0.076	5
10.5	0.065	6
9.5	0.069	5
10.8	0.055	5
10.6	0.077	6
11.2	0.055	5
9.5	0.089	5
11	0.067	6
9.9	0.11	6
13.1	0.076	8
12.5	0.072	7
9.6	0.091	6
9.7	0.082	5
11.5	0.091	7
9.2	0.085	6
14	0.065	6
11.1	0.058	6
10	0.053	6
10.8	0.081	7
11.6	0.077	6
9.6	0.073	4
9.7	0.078	4
9.9	0.073	5
11.3	0.053	5
9.8	0.094	5
11.6	0.086	6
9.9	0.145	3
9.9	0.147	4
9.5	0.089	5
11.6	0.077	6
11	0.067	4
10	0.061	8
9.8	0.267	3
14	0.044	8
9	0.086	4

Answer 1

Solution: Here concept of multiple linear regression is used.