Question

Car manufacturers produced a variety of classic cars that continue to increase in value. Suppose the...

Car manufacturers produced a variety of classic cars that continue to increase in value. Suppose the following data is based upon the Martin Rating System for Collectible Cars, and shows the rarity rating (1–20) and the high price ($1,000) for 15 classic cars.

Model Rating Price ($1,000)
A 19 2,650.0
B 13 45.0
C 14 62.0
D 18 1,025.0
E 18 375.0
F 15 102.5
G 19 1,325.0
H 18 1,575.0
I 17 475.0
J 16 250.0
K 17 375.0
L 19 4,000.0
M 16 125.0
N 16 375.0
O 17 165.0

(a) Develop a scatter diagram of the data using the rarity rating as the independent variable and price as the independent variable.

Does a simple linear regression model appear to be appropriate?

No, there doesn't appear to be a relationship between the two variables.

No, there appears to be a curvilinear relationship between the two variables.   

Yes, there appears to be a linear relationship between the two variables.

(b)Develop an estimated multiple regression equation with x = rarity rating and x2  as the two independent variables. (Round b0 and b1 to the nearest integer and b2 to one decimal place.)

ŷ =

(c) Consider the nonlinear relationship shown by equation (16.7): E(y) = β0β1x

Use logarithms to develop an estimated regression equation for this model. (Round b0 to three decimal places and b1 to four decimal places.)

log(ŷ) =

(d)Do you prefer the estimated regression equation developed in part (b) or part (c)? Explain.

The model in part (b) is preferred because r2 is higher and the p-value is lower.

The model in part (c) is preferred because r2 is higher and the p-value is lower.  

  The model in part (b) is preferred because r2 is lower and the p-value is lower.

The model in part (c) is preferred because r2 is lower and the p-value is lower.

Homework Answers

Answer #1

We input the given data set in R and use the summary(lm(.)) and plot(.) functions to answer the given questions.
The R code is given below.
x=c(19,13,14,18,18,15,19,18,17,16,17,19,16,16,17)
y=c(2650,45,62,1025,375,102.5,1325,1575,475,250,375,4000,125,375,165)
plot(x,y,pch=16,xlab="rating",ylab="price")
x2=x^2
mb=lm(y~x+x2)
mb1=lm(log(y)~x)
summary(mb)
summary(mb1)


(a) The scatter diagram is given below.


Does a simple linear regression model appear to be appropriate? No, there appears to be a curvilinear relationship between the two variables.

(b) ŷ = 33357 + (-4513) x + 151.9 x2.

(c) log(ŷ) = (-5.515) + 0.6839 x.

(d) The model in part (c) is preferred because r2 (0.8486) is higher and the p-value (0.000001093) is lower.  

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Car manufacturers produced a variety of classic cars that continue to increase in value. Suppose the...
Car manufacturers produced a variety of classic cars that continue to increase in value. Suppose the following data is based upon the Martin Rating System for Collectible Cars, and shows the rarity rating (1–20) and the high price ($1,000) for 15 classic cars. Model Rating Price ($1,000) A 17 400.0 B 16 325.0 C 15 102.5 D 13 70.0 E 14 37.0 F 16 225.0 G 18 350.0 H 17 140.0 I 18 1,575.0 J 16 150.0 K 18 1,000.0...
Consider the following data for two variables, x and y. x 22 24 26 30 35...
Consider the following data for two variables, x and y. x 22 24 26 30 35 40 y 13 22 34 34 41 35 (a) Develop an estimated regression equation for the data of the form ŷ = b0 + b1x.  (Round b0 to one decimal place and b1 to three decimal places.) ŷ = (b) Use the results from part (a) to test for a significant relationship between x and y. Use α = 0.05 Find the value of the...
A statistical program is recommended. A highway department is studying the relationship between traffic flow and...
A statistical program is recommended. A highway department is studying the relationship between traffic flow and speed. The following model has been hypothesized: y = β0 + β1x + ε where y = traffic flow in vehicles per hour x = vehicle speed in miles per hour. The following data were collected during rush hour for six highways leading out of the city. Traffic Flow (y) Vehicle Speed (x) 1,257 35 1,328 40 1,225 30 1,333 45 1,348 50 1,122...
A highway department is studying the relationship between traffic flow and speed. The following model has...
A highway department is studying the relationship between traffic flow and speed. The following model has been hypothesized: y = β0 + β1x + ε y = traffic flow in vehicles per hour x = vehicle speed in miles per hour. The following data were collected during rush hour for six highways leading out of the city. Traffic Flow (y) Vehicle Speed (x) 1,257 35 1,331 40 1,227 30 1,336 45 1,349 50 1,125 25 In working further with this...
8. Consider the following data for a dependent variable y and two independent variables, x1 and...
8. Consider the following data for a dependent variable y and two independent variables, x1 and x2. x1 x2 y 30 12 94 47 10 108 25 17 112 51 16 178 40 5 94 51 19 175 74 7 170 36 12 117 59 13 142 76 16 211 (a) Develop an estimated regression equation relating y to x1. (Round your numerical values to one decimal place.) ŷ = ______   Predict y if x1 = 51. (Round your answer...
Use the following dataset and answer the following questions. x 6 15 9 21 20 18...
Use the following dataset and answer the following questions. x 6 15 9 21 20 18 y 16 25 20 35 40 29 Please do problems (b), and (c) BY HAND. You may use your calculator. a) The following scatter diagram has been taken from Minitab for the above data. What does the above scatter diagram indicate about the relationship between the two variables? b) Find the intercept of the estimated regression equation (b0). c) Find the slope of the...
Companies in the U.S. car rental market vary greatly in terms of the size of the...
Companies in the U.S. car rental market vary greatly in terms of the size of the fleet, the number of locations, and annual revenue. In 2011, Hertz had 320,000 cars in service and annual revenue of approximately $4.2 billion. Suppose the following data show the number of cars in service (1,000s) and the annual revenue ($ millions) for six smaller car rental companies. Company Cars (1,000s) Revenue ($ millions) Company A 11.5 120 Company B 10.0 135 Company C 9.0...
Data needs to be analyzed For this assignment I have to analyze the regression (relationship between...
Data needs to be analyzed For this assignment I have to analyze the regression (relationship between 2 independent variables and 1 dependent variable). Below is all of my data and values. I need help answering the questions that are at the bottom. Questions regarding the strength of the relationship   Sum of X1 = 184.6 Sum of X2 = 21307.03 Sum of Y = 2569.1 Mean X1 = 3.6196 Mean X2 = 417.7849 Mean Y = 50.3745 Sum of squares (SSX1)...
Assignment Problem: Matt Profitt, an MBA student, is studying companies that are going public for the...
Assignment Problem: Matt Profitt, an MBA student, is studying companies that are going public for the first time. He is curious about whether or not there is a significant relationship between the size of the offering (in millions of dollars) and the price per share. Size 108 4.4 3.5 8.6 139 228 47.5 5.5 175 12 51 66 Price 12 4 5 6 13 19 8.5 5 15 6 12 12 a. Develop the appropriate scatterplot for the two variables...
A sociologist was hired by a large city hospital to investigate the relationship between the number...
A sociologist was hired by a large city hospital to investigate the relationship between the number of unauthorized days that employees are absent per year and the distance (miles) between home and work for the employees. A sample of 10 employees was chosen, and the following data were collected. Distance to Work Number of Days Absent 1 7 3 4 4 7 6 6 8 5 10 2 12 5 14 1 14 4 18 1 Which of the following...