Influential wine critics such as Robert Parker publish their personal ratings of wines and many consumers pay close attention. Do these ratings affect the price? The data in wine.xlsx are a sample of ratings and prices found online at the website of an internet wine merchant.

(a) Does the scatterplot of the price of wine on the rating suggest a linear or nonlinear relationship?

(b) Fit a linear regression equation to the data, regressing price on the rating. Does this fitted model make substantive sense?

(c) Create a scatterplot for the natural logarithm of the price on the rating. Does the relationship seem more suited to regression?

(d) Fit a regression of the natural logarithm of price on the rating. Does this model provide a better description of the pattern in the data?

(e) Compare the fit of the two models to the data.

Attachment:- Assignment.rar