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 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
L 18 1,000.0
M 18 350.0
N 16 100.0
O 13 95.0

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

A scatter diagram has 15 points. The horizontal axis ranges from 12 to 20 and is labeled: Rating. The vertical axis ranges from 0 to 4500 and is labeled: Price. Moving from left to right, the first point is located at approximately (13, 4300), with the general trend of the next 5 points moving downward rapidly, ending around 750 on the vertical axis. The next 9 points move downward much more slowly in a diagonal direction, staying fairly clustered between 250 and 750 on the vertical axis.

A scatter diagram has 15 points. The horizontal axis ranges from 12 to 20 and is labeled: Rating. The vertical axis ranges from 0 to 4500 and is labeled: Price. Moving from left to right, the first point is located at approximately (13, 100) and the next 9 points stay fairly clustered between 0 and 500 on the vertical axis. The next 5 points move up rapidly, beginning at approximately 1000 on the vertical axis and ending with the last point around 4000 on the vertical axis.

A scatter diagram has 15 points. The horizontal axis ranges from 12 to 20 and is labeled: Rating. The vertical axis ranges from 0 to 4500 and is labeled: Price. Moving from left to right, the first point is located at approximately (13, 300) and the next 9 points stay fairly clustered between 250 and 750 on the vertical axis. The next 5 points move up rapidly, beginning at approximately 1250 on the vertical axis and ending with the last point around 4250 on the vertical axis.

A scatter diagram has 15 points. The horizontal axis ranges from 12 to 20 and is labeled: Rating. The vertical axis ranges from 0 to 4500 and is labeled: Price. Moving from left to right, the first point is located at approximately (13, 4000), with the general trend of the next 5 points moving downward rapidly, ending around 500 on the vertical axis. The next 9 points move downward much more slowly in a diagonal direction, staying fairly clustered between 0 and 500 on the vertical axis.

Does a simple linear regression model appear to be appropriate?

No, there appears to be a curvilinear relationship between the two variables.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.

(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 (b) 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 (c) is preferred because r2 is lower and the p-value is lower.

Solutions

Expert Solution

(a) The scatter diagram isa s follows:

Looking at the diagram, the relationship doesn't appear to be linear. The corerct option to be chosen is:

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

(b) To find the regression equation, we select the trend line option on the scatter plot and then select polynomial of order 2. The result is as shown below:

(c) To find the required equation, we select "Power" option in the choices for trendline. The result is as follows:

Log (y) = Log (8 x 10-10) + 9.5558 x Log (x)

(d) Comparing the above two plots, we see that R2 is higher in the equation shown in part (c). Hence the correct option to be chosen is: The model in part (c) is preferred because r2 is higher and the p-value is lower.


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 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...
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