Question

In: Statistics and Probability

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 14 37.0
B 19 1,300.0
C 16 125.0
D 17 140.0
E 18 1,575.0
F 16 250.0
G 17 375.0
H 17 425.0
I 18 400.0
J 19 2,650.0
K 19 4,000.0
L 18 975.0
M 15 77.5
N 16 325.0
O 13 95.0

(a)

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

a

Does a simple linear regression model appear to be appropriate?

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

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

No, there appears to be a curvilinear 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.)ŷ =

34426−4645x+155.8x2 (Wrong)

(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(ŷ) =

−10.280+10.5200log(x) (Wrong)

(d)

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

The model in part (c) is preferred because r2 is lower 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 higher and the p-value is lower. (wrong)

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

Solutions

Expert Solution

____________________________________________________________________________________________

________________________________________________________________________________________

x y logx logy
14 37 1.146128 1.568202
19 1300 1.278754 3.113943
16 125 1.20412 2.09691
17 140 1.230449 2.146128
18 1575 1.255273 3.197281
16 250 1.20412 2.39794
17 375 1.230449 2.574031
17 425 1.230449 2.628389
18 400 1.255273 2.60206
19 2650 1.278754 3.423246
19 4000 1.278754 3.60206
18 975 1.255273 2.989005
15 77.5 1.176091 1.889302
16 325 1.20412 2.511883
13 95 1.113943 1.977724

Related Solutions

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 16 275.0 B 19 1,325.0 C 17 140.0 D 16 100.0 E 18 975.0 F 15 77.5 G 16 325.0 H 18 350.0 I 13 70.0 J 17 450.0 K 17 375.0...
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 16 275.0 B 19 1,325.0 C 17 140.0 D 16 100.0 E 18 975.0 F 15 77.5 G 16 325.0 H 18 350.0 I 13 70.0 J 17 450.0 K 17 375.0...
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 16 225.0 B 16 375.0 C 19 1,325.0 D 18 1,625.0 E 19 4,025.0 F 17 400.0 G 15 102.5 H 14 87.0 I 17 450.0 J 17 140.0 K 19 2,675.0...
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 16 125.0 B 13 70.0 C 17 140.0 D 19 1,325.0 E 19 3,975.0 F 18 1,025.0 G 14 87.0 H 17 425.0 I 19 2,675.0 J 16 350.0 K 16 250.0...
A statistical program is recommended. Car manufacturers produced a variety of classic cars that continue to...
A statistical program is recommended. 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 18 1,575.0 B 14 37.0 C 15 52.5 D 18 1,000.0 E 13 95.0 F 19 1,275.0 G 19 2,675.0 H 17 375.0 I 16 325.0 J...
A statistical program is recommended. Car manufacturers produced a variety of classic cars that continue to...
A statistical program is recommended. 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 14 62.0 B 19 1,325.0 C 17 165.0 D 13 70.0 E 19 3,975.0 F 16 225.0 G 16 325.0 H 18 1,625.0 I 17 450.0 J...
Corvette, Ferrari, and Jaguar produced a variety of classic cars that continue to increase in value....
Corvette, Ferrari, and Jaguar produced a variety of classic cars that continue to increase in value. The data showing the rarity rating (1–20) and the high price ($1000s) for 15 classic cars is contained in the Excel Online file below. Construct a spreadsheet to answer the following questions. Develop an estimated multiple regression equation with  rarity rating and  as the two independent variables Price = (___) + (___) Rating + (___) Rating^2 (to whole numbers) What is the value of the coefficient...
Two major automobile manufacturers have produced compact cars with the same size engines. We are interested...
Two major automobile manufacturers have produced compact cars with the same size engines. We are interested in determining whether or not there is a significant difference in the MPG (miles per gallon) of the two brands of automobiles. A random sample of eight cars from each manufacturer is selected, and eight drivers are selected to drive each automobile for a specified distance. The following data show the results of the test and if the variance of MPG is the same,...
Suppose the following data were collected from a sample of 5 car manufacturers relating monthly car...
Suppose the following data were collected from a sample of 5 car manufacturers relating monthly car sales to the number of dealerships and the quarter of the year. Use statistical software to find the following regression equation: SALESi=b0+b1DEALERSHIPSi+b2QUARTER1i+b3QUARTER2i+b4QUARTER3i+ei Is there enough evidence to support the claim that on average, car sales are higher in the 4th quarter than in the 3rd quarter at the 0.05 level of significance? If yes, write the regression equation in the spaces provided, rounded to...
Consider a market for used cars. Suppose that each car on the market is 1 of...
Consider a market for used cars. Suppose that each car on the market is 1 of seven possible levels of quality x={1000,2000,…,7000}. There is an equal amount of cars at each quality level. Each current owner (and potential seller) knows the quality (x) of the car that they have. (Note: We did not do a problem like this explicitly in class, but it is a very simplified version of the “A” insurance example from the notes.) a. Suppose that buyers...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT