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.

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now

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?

"Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!":

Get started