Description
1. A sample of 50 wines is stored in the VinhoVerde.xlsx Excel file posted in the Datasets for Class folder in Canvas. Develop a simple linear regression model to predict wine quality using alcohol content. Wine quality is measured on a 0 to 10 scale, where 0 is bad and 10 is excellent.
a. Construct a scatter plot. Put wine quality on the Y axis and alcohol content on the X axis.
b. What is the independent variable in this model? What is the dependent variable?
c. Write out the simple linear regression model to be estimated.
d. Estimate the model using least-squares method. What is the prediction line?
e. Interpret the meaning of the Y intercept, b0, in this problem.
f. Interpret the meaning of the slope, b1, in this problem.
g. Using your answer from part d, predict the mean wine quality for wines with a 10% alcohol content.
h. What conclusions can be reached based on your results?
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
The solution is attached.It is contained in the RESULT sheet on the excel file.
Fixed Acidity Volatile Acidity Citric Acid Residual Sugar Chlorides Free Sulfur Dioxide
11.5
0.3
0.6
2
0.067
12
7.7
0.715
0.01
2.1
0.064
31
10.4
0.575
0.61
2.6
0.076
11
9.2
0.63
0.21
2.7
0.097
29
7.9
0.35
0.46
3.6
0.078
15
8.9
0.745
0.18
2.5
0.077
15
7.6
0.51
0.24
2.4
0.091
8
10.8
0.5
0.46
2.5
0.073
5
6.4
0.47
0.4
2.4
0.071
8
9.9
0.63
0.24
2.4
0.077
6
6.9
0.685
0
2.5
0.105
22
7.3
0.45
0.36
5.9
0.074
12
6.8
0.81
0.05
2
0.07
6
7.5
0.51
0.02
1.7
0.084
13
10.4
0.34
0.58
3.7
0.174
6
7.1
0.46
0.14
2.8
0.076
15
9.1
0.5
0.3
1.9
0.065
8
7.3
0.69
0.32
2.2
0.069
35
7.7
0.6
0
2.6
0.055
7
6.7
0.46
0.24
1.7
0.077
18
8.6
0.47
0.27
2.3
0.055
14
8.3
0.65
0.1
2.9
0.089
17
6
0.31
0.47
3.6
0.067
18
8.6
0.49
0.28
1.9
0.11
20
7.9
0.54
0.34
2.5
0.076
8
10.2
0.49
0.6...