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

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

Math

Statistics

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.

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.

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

The following refer to the following data set: 92.2 119.4 119.4 72.8 88.2 119.4 88.9 99.6 109.4 96 What is the arithmetic mean of this data set? mean = What is the median of this data set? median = What is the mode of this data set? mode
In a survey the maximum data point was 100 while the minimum data point was 10. if the number of classes was 5 which of the following would be an appropriate class size ? select one: a. 20 b.6 c. 10 d. 18
The U.S. Census Bureau collects data on household size and publishes the information in Current Population Reports. What kind of data is the number of people in your household?
Find the Fan Cost Index for the New York Knicks. Team Ticket Other Drink Soft Drink Hot Dog Parking Hat FCI NY Knicks $190 $11.50 $8 $6 $30 $31
Below is a histogram of the tuition and fee charges for 64 four-year colleges in Massachusetts. What is the number of universities/colleges with tuition and fee charges covered by the leftmost bar in the histogram.
The Census Bureau Web site gives several choices for "average income" in its historical income data. In 2006, the median income of American households was $48,201. The mean household income was $66,570. The median income of families was $58,407, and the mean family income was $77,315. The Census Bureau says, “Households consist of all people who occupy a housing unit. The term ‘family’ refers to a group of two or more people related by birth, marriage, or adoption who reside together.” Identify the reason for mean incomes for households being higher than median incomes for households.
The price drivers pay for gasoline often varies a great deal across regions throughout the United States. The following data show the price per gallon for regular gasoline for a random sample of gasoline service stations for three major brands of gasoline (Shell, BP, and Marathon) located in eleven metropolitan areas across the upper Midwest region (OhioGasPrices.com website, March 18, 2012). Click on the datafile logo to reference the data. DATA file Shell BP Metropolitan Area Marathon Akron, Ohio Cincinnati, Ohio Cleveland, Ohio Columbus, Ohio Ft. Wayne, Indiana Indianapolis, Indiana Lansing, Michigan Lexington, Kentucky Louisville, Kentucky Muncie, Indiana Toledo, Ohio 3.77 3.72 3.87 3.76 3.78 3.87 3.89 3.79 3.83 3.83 3.85 3.77 3.83 3.85 3.93 3.84 3.84 4.04 3.87 3.87 3.99 3.79 3.78 3.81 3.69 3.78 3.84 3.84 3.83 3.79 3.79 3.86 3.86 Use a = .05 to test for any significant difference in the mean price of gasoline for the three brands. Round SS to 6 decimals, MS to 6 decimals, F to 2…
Incorrect answers: -2.81,-2.82,-2.83,-2.70,-2,71,-2.74,-2.56
Calculate the Midrange of the following data set:- 135 168 174 127 115 142 146 122