Please use Excel worksheet completed these questions. Excel worksheet with a separate tab for each question. Must use Excel worksheet, this is not paper, or essay.
A: Develop a table that shows the number of wines that were classified as classic, outstanding, very good, good, mediocre, and not recommended and the average price. Does there appear to be any relationship between the price of the wine and the Wine Spectator rating? Are there any other aspects of your initial summary of the data that stand out?
B: Develop a scatter diagram with price on the horizontal axis and the Wine Spectator score on the vertical axis. Does the relationship between price and score appear to be linear?
C: Using linear regression, develop an estimated regression equation that can be used to predict the score given the price of the wine.
D: Using a second-order model, develop an estimated regression equation that can be used to predict the score given the price of the wine.
