Assignment 4 (1) - ExcelP SearchA Emerson Oakes困AutoSaveffEOFileHomeInsertPage LayoutFormulasDataReviewViewHelpA ShareP CommentsC3fePA BIn the past a number of car makers produced a wide range of classic cars that continue to increase in value. The following data, based upon the Martin5 Rating System for Collectible Cars, show the rarity rating (1- 20) and the highest sales price ($1000s) for 15 Classic cars.EFGHJKLNQR467Model YearMakeModelRatingPrice ($1000s)81984Chevrolet1816001956Chevrolet194000101963Chevrolet181000111978Chevrolet191300121963Ferrari16350131964Ferrari192650141962Ferrari18375151968Ferrari17450161973Ferrari17140171967Jaguar1577.5181971Jaguar1462JaguarJaguar1919741612520195417400211953Jaguar16250221967Jaguar13702324A. Develop a scatter diagram of the data using rarity rating as the independent variable and price as the dependent variable. Does thesimple linear regression model appear to be appropriate ? Explain your Answer.2526B. Develp an estimated multiple regresssion equation with x = rarity and x as the two independent variables.271. What is your regression equation ?282. What are this equations R² and Adjusted R2 statistics ?293. What are your significance values for the entire equation and for the two independent varaibles ?304. Plot the standardized residual values vs y*. Does it show that the distribution of the standardized residuals31fit the assumption of a normal distribution?C. Develop a linear regression equation using logrithmic functions and fully evaluate the quality of that regression equation.321. What is your regression equation ?2233342. What are this equations R and Adjusted R* statistics ?353. What are your significance values for the entire equation and for the two independent varaibles ?364. Plot the standardized residual values vs y*. Does it show that the distribution of the standardized residualsO 4)37fit the assumption of a normal distribution?38D. Which model do you prefer ? Why ? What is the predicted price for a Martin Rating of 19 ? How did that compare to the mean7:07 PM39price of cars in the original sample that had a rating of 19?3/11/202140Problem 1Problem 2Problem 3Problem 4Problem 5+囲65%H Q o i C E O O

Name: Assignment 4 (1) - ExcelP SearchA Emerson Oakes困AutoSaveffEOFileHomeI
Uploaded: 2024-03-20T07:06:27.000Z
Channel: Bartleby
Description: Assignment 4 (1) - ExcelP SearchA Emerson Oakes困AutoSaveffEOFileHomeInsertPage LayoutFormulasDataReviewViewHelpA ShareP CommentsC3fePA BIn the past a number of car makers produced a wide range of classic cars that continue to increase in value. The

Question

Accepted Answer

Note:
Hi there! Thank you for posting the question. As your question has more than 3 parts, as per…

In the past a number of car makers produced a wide range of classic cars that continue to increase in value. The following data, based upon the Martin Rating System for Collectible Cars, show the rarity rating (1 - 20) and the highest sales price ($1000s) for 15 Classic cars.