Question

In: Statistics and Probability

Used Cars - Actual Data: Below are the scatterplots, regression equations, and corresponding statistics for mileage,...

Used Cars - Actual Data: Below are the scatterplots, regression equations, and corresponding statistics for mileage, model year, and price for 15 different Honda Civics found on craigslist in May 2012.

         

Mileage -vs- Price:
x = Mileage (in thousands of miles)
y = Price (in dollars)

correlation coefficient:
r = −0.880

regression equation:
ŷ = −75.50x + 15,553.6

sample size:
n = 15

         

Model Year -vs- Price:
x = Model Year
y = Price (in dollars)

correlation coefficient:
r = 0.891

regression equation:
ŷ = 999.91x − 1,995,733.3

sample size:
n = 15

Suppose you see a 2004 Honda Civic with 140 thousand miles on it. Estimate a reasonable price for this car via the following methods.

(a) Estimate the price using the mileage. Round your answer to the nearest dollar.
$

(b) Estimate the price using the year. Round your answer to the nearest dollar.
$

(c) Estimate the price using the multiple linear regression equation given by

ŷ = 716.9x1 − 42.9x2 − 1,424,349

where x1 is the model year and x2 is the mileage (in thousands). Round your answer to the nearest dollar.
$

(d) Which of the following statements are valid?

The estimate based only on mileage (part a) is too low because it doesn't consider the model year.

The estimate based only on the year (part b) is too high because it doesn't consider the mileage.     

The estimate from part (c) considers both variables (year and mileage) to produce a better estimate.

All of these are valid statements.

Solutions

Expert Solution

a)

x = Mileage (in thousands of miles) = 140 thousand miles
y = Price (in dollars)

Predicted Price = −75.50*(140) + 15,553.6 = $ 4983.6

b)

x = Model Year = 2004
y = Price (in dollars)

Predicted price = 999.91 *(2004) − 1,995,733.3 = $ 8086.34

c)

x1 is the model year = 2004

x2 is the mileage (in thousands) = 140 thousand miles

Predicted price = 716.9*(2004) − 42.9*(140) − 1,424,349 = $ 6312.6

d)

The estimate based only on mileage (part a) is too low because it doesn't consider the model year. as price and model year are positively correlated the statement is true

The estimate based only on the year (part b) is too high because it doesn't consider the mileage.    as milage and price are negatively correlated the statement is true

The estimate from part (c) considers both variables (year and mileage) to produce a better estimate. as both milage and model year have high correlation with price.

hence, All of these are valid statements.


Related Solutions

Mileage ratings for cars and trucks generally come with a qualifier stating actual mileage will depend...
Mileage ratings for cars and trucks generally come with a qualifier stating actual mileage will depend on driving conditions and habits. A car manufacturer states that its new truck will average 19 miles per gallon with combined town and country driving. Assume the mean stated by the manufacturer is the actual​ average, and the distribution has a standard deviation of 3.6 mpg. Complete parts a and b below a. Given the above mean and standard deviation, what is the probability...
The data below is the mileage (thousands of miles) and age of your cars . Year...
The data below is the mileage (thousands of miles) and age of your cars . Year Miles Age 2017    8.5    1 2009 100.3    9 2014   32.7    4 2004 125.0   14 2003 115.0   15 2011   85.5    7 2012   23.1    6 2012   45.0    6 2004 123.0   14 2013   51.2    5 2013 116.0    5 2009 110.0    9 2003 143.0   15 2017   12.0    1 2005 180.0   13 2008 270.0   10 Please include appropriate Minitab Results when important a. Identify terms in the simple linear...
The data below is the mileage (thousands of miles) and age of your cars as sample....
The data below is the mileage (thousands of miles) and age of your cars as sample. Year Miles Age 2017    8.5    1 2009 100.3    9 2014   32.7    4 2004 125.0   14 2003 115.0   15 2011   85.5    7 2012   23.1    6 2012   45.0    6 2004 123.0   14 2013   51.2    5 2013 116.0    5 2009 110.0    9 2003 143.0   15 2017   12.0    1 2005 180.0   13 2008 270.0   10 Please include appropriate Minitab Results when important a. Identify terms in the simple...
The data below is the mileage (thousands of miles) and age of your cars . Year...
The data below is the mileage (thousands of miles) and age of your cars . Year Miles Age 2017    8.5    1 2009 100.3    9 2014   32.7    4 2004 125.0   14 2003 115.0   15 2011   85.5    7 2012   23.1    6 2012   45.0    6 2004 123.0   14 2013   51.2    5 2013 116.0    5 2009 110.0    9 2003 143.0   15 2017   12.0    1 2005 180.0   13 2008 270.0   10 Please include appropriate Minitab Results when important a. Identify terms in the simple linear...
1. The data below is the city gas mileage for a sample of hybrid cars, as...
1. The data below is the city gas mileage for a sample of hybrid cars, as reported by the Environmental Protection Agency in 2007. 30, 36, 33, 27, 31, 25, 28, 31, 45 mpg Construct and interpret a 95% confidence interval for the population mean for the miles per gallon of hybrids. You may assume that the population of gas mileage normally distributed with no outliers. Answer the following:                         a What is...
Based on the below data what will be the value of standard error? Regression Statistics Multiple...
Based on the below data what will be the value of standard error? Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 8 ANOVA df SS MS F Regression 1 33 33.0 16.5 Residual 6 12 2.0 Total 7 Coefficients Standard Error t Stat P-value Intercept 9 31.274666 3.984284 0.007248 Advertising (thousands of $) 24 6.19330674 1.610802 0.158349 Submit Answer format: Number: Round to: 2 decimal places.
​​​​​Below is the regression of units sold on the average price of the product. Regression Statistics...
​​​​​Below is the regression of units sold on the average price of the product. Regression Statistics Multiple R 0.2461 R Square 0.2000 Adjusted R Square 0.1649 Standard Error 26.128 Observations 20 ANOVA Df SS MS F Significance F Regression 1 3080.89 3080.89 4.51 0.0478 Residual 18 12288.31 682.68 Total 19 15369.20 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 614.9300 51.2343 12.002 0.0000 507.2908 722.5692 X -109.1120 51.3623 -2.124 0.0478 -217.0202 -1.2038 What is the estimated regression...
It is known that several factors effect the gas mileage of cars. Complete the F-test below...
It is known that several factors effect the gas mileage of cars. Complete the F-test below that was performed on 25 sedans measuring (3 factors): weight, horsepower, and number of cylinders, and their respective gas mileage. Use alpha = 0.05. F-Test and A t-Test Multiple Regression Source                   SS                        DF                          MS               F(stat) Regression            250 Error                Total                    400 Given the regression equation below, perform three t-tests to determine if each variable is significant at the 0.05 level. STATE WHICH VARIABLES HAVE A...
Below is a list of gas mileage ratings for selected passenger cars in miles per gallon....
Below is a list of gas mileage ratings for selected passenger cars in miles per gallon. 16.2 20.3 31.5 30.5 21.5 31.9 37.3 27.5 27.2 34.1 35.1 29.5 31.8 22.0 17.0 21.6 Find the mean, standard deviation, five - number summary, IQR, and identify any outliers. Use the five - number summary to sketch a boxplot. What does the boxplot tell you about the distribution of the data? (20 points)
In the market for used cars, the demand and supply equations are given by QD=12,000 -.4P...
In the market for used cars, the demand and supply equations are given by QD=12,000 -.4P and QS=.1P+5000, where P is the price per car and Q measures the quantity of cars. What is the size of the deadweight loss at a price floor of $15,000?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT