Fit a linear regression equation to the data

Assignment Help Advanced Statistics
Reference no: EM13486599

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

Reference no: EM13486599

Questions Cloud

Find the electrostatic potential energy of pair of protons : The "size" of the nucleus in Rutherford's model of the atom is about 1.00 fm = 1.00E-15 m. find the electrostatic potential energy of the pair of protons
The electrochemical cell with a cobalt electrode immersed : Consider an electrochemical cell with a cobalt electrode immersed in 1.0 M Co2+ and a lead electrode immersed in 1.0 M Pb2+. Co2+ + 2e- --> Co E0 = -0.28 V Pb2+ + 2e- --> Pb
Does the company have capital leases : What are the company's footnote disclosures relating to impairment? Please also describe how to determine if impairment exists and how to calculate the impairment loss.
Find the spacing between reflecting planes in the crystal : An x-ray tube is operated at 40600 V. Calculate the minimum wavelength of the radiation emitted by this tube. find the spacing between reflecting planes in the crystal
Fit a linear regression equation to the data : Does the scatterplot of the price of wine on the rating suggest a linear or nonlinear relationship and fit a linear regression equation to the data, regressing price on the rating. Does this fitted model make substantive sense?
Calculate the radius of its ground-state orbit : Calculate the energy of the electron in the ground state of triple ionized beryllium, which has an atomic number Z = 4
Explain changes to the cell will increase the voltage : Cu2+(aq) + Zn(s) ---> Cu(s) + Zn2+(aq) A galvanic cell that uses the reaction shown above has a standard state electromotive force of 1.1 volts. Which of the following changes to the cell will increase the voltage
What is the required minimum sample size : What is the required minimum sample size and Construct a table for the minimum sample size required with margin of error ranging from 1% to 3% and actual proportion ranging from 40% to 60%.
How many photons would be produced : A 0.575 kg mass falls from a height of 3.95 m. If all of the energy of this mass could be converted to visible light of wavelength 5.29E-7 m

Reviews

Write a Review

 

Advanced Statistics Questions & Answers

  Estimating common equity from retained earnings

Your firm has been hired to help ABC Company to estimate the cost of common equity. The yield on the firm's bonds is 5.75%, and your firm's economists believe that the cost of common equity can be estimated using a risk premium of 2.5% over a firm..

  Percentage change in shareholder wealth

Facebook sold shares to investors at $38 each in its IPO. One year later, its stock price was hovering around $26. What was the percentage drop in Facebook shares in its first year as a public company?

  Developing appropriate forecast model for bookstore

Develop an appropriate forecast model for bookstore management to use to forecast computer demand for next fall semester and indicate how accurate it appears to be. What other forecasts might be useful to the bookstore?

  Performance and dating policies

What are incentive plans? How can they help the organization to achieve their objectives? Do incentive plans really improve performance and are they cost effective? Why or why not?

  Pujols industries-bond issue entries

On February 28, 2006, Pujols Industries issued 10% bonds, dated January 1, with a face amount of $48 million. The bonds were priced at $42 million (plus accrued interest) to yield is 12%.

  Determining tax saver benefit

A TSB (Tax Saver Benefit) plan allows you to put money into an account at the beginning of the calendar year that can be used for medical expenses. This amount is not subject to federal tax (hence the phrase TBS).

  Earnings available for common stockholders

At the end 2005, the Long Life Light Bulb Company announced had produced a gross profit of $1 million. The company has also established that over the course of this year it has incurred $345,000 in operating expenses and $125,000 interest expenses..

  Analyzing production costs

A small publishing company is planning to publish a new book. The production costs will include onetime fixed costs (such as editing) and variable costs [such as printing).

  Determine least squres line and draw the scatter diagram

Calculate te covarience anf the correlatio coeficient. Comment on the relationship between x and y Determine the least squres line. Draw the scatter diagram and plot the least squres line

  Determining break-even point-profit gained

To produce x number of units of glass vases cost C(x)=12x + 39. My revenue is R(x)=25x. Both cost and revenue and cost are in dollars.

  Cultural dimension comparison of us

Information of a historical, political, economic, or social nature that helps to explain the values and placement on the various cultural dimensions will be helpful. Your results will be presented in a written report.

  Annual rice yield in pounds

Predict the annual rice yield (in pounds) when the number of acres planted is 3275 (in thousands) and the number of acres harvested is 2980 (in thousands).

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd