excel answer questions

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?