Suggested retail price of the used 2005 gm car in excellent

Assignment Help Basic Statistics
Reference no: EM13240533

In this case, we are going to study some data collected from Kelly Blue Book for several hundred 2005 used General Motors (GM) cars. This data allows one to develop regression models to determine car values based on a variety of characteristics such as mileage, make, model, engine size, interior style, and cruise control. 

A representative sample of over eight hundred 2005 GM cars were selected, then retail price was calculated from the tables provided in the 2005 Central Edition of the Kelly Blue Book. The data set containing the following variables:

• Price: suggested retail price of the used 2005 GM car in excellent condition. The condition of a car can greatly affect price. All cars in this data set were less than one year old when priced and considered to be in excellent condition. 

• Mileage: number of miles the car has been driven

• Make: manufacturer of the car such as Saturn, Pontiac, and Chevrolet

• Model: specific models for each car manufacturer such as Ion, Vibe, Cavalier

• Trim (of car): specific type of car model such as SE Sedan 4D, Quad Coupe 2D 

• Type: body type such as sedan, coupe, etc. 

• Cylinder: number of cylinders in the engine 

• Liter: a more specific measure of engine size 

• Doors: number of doors 

• Cruise: indicator variable representing whether the car has cruise control (1 = cruise)

• Sound: indicator variable representing whether the car has upgraded speakers (1 = upgraded)

• Leather: indicator variable representing whether the car has leather seats (1 = leather)

 

Please find the data her e.

Let us start by asking a question: "Are cars with lower mileage worth more?" Clearly it seems reasonable to expect to see a relationship between mileage (number of miles the car has been driven) and retail value. Hence we can try to fit a simple linear regression model relating price with mileage, and obtain the following results:

Equation 1: Price = b1 – b2 Mileage

Run the model, get all coefficients and interpret. Draw a scatter plot between Price and Mileage. 

In your paper, please try to address the following questions,

In general, what happens to price when there is one more mile on the car?

Does the fact that b1 is small (-0.17) mean mileage is not very important? 

Does mileage help you predict price? What does the p-value tell you?

Does mileage help you predict price? What does the R-Sq value tell you?

Let us explore a more advanced model.

Equation 2: Price = b0- b1 Mileage + b2 Cylinder - b3 Doors + b4 Cruise - b5 Sound + b6Leather

Show the regression outputs and interpret (include the overall model fit, model implication, and each coefficient). 

Summarize your findings, along with your understanding of regression and its applications in business literatures,

Reference no: EM13240533

Questions Cloud

Find the 95% confidence interval for the true mean length : A meteorologist wishes to estimate the mean amount of snowfall per year in Spokane, Washington. A random sample of the recorded snowfalls for 20 years from a 140 year period produces a sample mean equal to 54.03 inches, with a standard deviation of 9..
Boethius consider the highest form of music : Which of the following did Boethius consider the highest form of music?
Critical analysis how use of ethics by the parties involved : Critique the Ethics of those involved in the News of the World phone hacking scandal. Demonstrate in your critical analysis how the use of Ethics by the parties involved could have assisted in better operation of News Ltd.
Greeks portrayals of mythological events and heroes : Why did roman artist deviated from the greeks portrayals of mythological events and heroes, intead depiciting in their art current events and ral people?
Suggested retail price of the used 2005 gm car in excellent : In this case, we are going to study some data collected from Kelly Blue Book for several hundred 2005 used General Motors (GM) cars. This data allows one to develop regression models to determine car values based on
The pantheon mirrors the roman empire : Why can it be said that in a sence, the Pantheon mirrors the roman empire?
Random samples of five were selected from each of three : Random samples of five were selected from each of three populations. The sum of squares total was 100. The sum of squares due to the treatments was 40.
Why did virgil compose the aeneid : Why did Virgil compose the Aeneid?
A recent study focused on the number of times men : At the .01 significance level, is there a difference in the mean number of times men and women order take-out dinners in a month? What is the p-value?

Reviews

Write a Review

 

Basic Statistics Questions & Answers

  Every student at party has same chance to be interviewed

Interview about attitudes toward alcohol. You have given every student at the party the same chance to be interviewed: what is the chance? Why is your sample not an SRS?

  State null and alternitive hypotheses for conducting anova

Mean satifaction differ according to how they most use the bank? Identifing notation, state the null and alternitive hypotheses for conducting an ANOVA with data from the survey?

  Randomly selected day from distribution of tickets

The university policy department must write, on average, five tickets per day to keep department revenues at budgeted levels. Suppose the number of tickets written per day follows a Poisson distribution with mean of 6.0 tickets per day. Find the p..

  Estimating the proportion of families

In order to estimate the proportion of families who prefer female baby-sitters to male baby-sitters with an error of at most 8 percentage points and with at least 95 percent confidence, how large a sample should be taken?

  Standard deviation of weights equal

A machine fills containers with a mean weight per container of 16oz. If no more than 5% of the containers are to weigh less than 15.8oz, what must the standard deviation of weights equal?

  Application envelopes at random looking for ten applicants

The application envelopes at random looking for 10 applicants with GRE scores over 600. How many envelopes do you think the staff will need to open?

  What premium amount should policy charge

A particular company offers a 500$ deductible policy. If the company wishes its expected profit to be $100, what premium amount should it charge?

  Interval or ratio level of measurement

When we have data that are measured at the interval/ratio level of measurement, there are:

  Poisson approximation binomial proabability

Please use words to describe the solution, not just symbols. (basically, explain what is going on in addition to an answer) Use a math symbol editor where appropriate.

  Impact of campaign film on attitude toward political person

The impact of campaign film on attitudes toward a political candidate was investigated. Prior to showing the film, the attitudes of 15 people toward the candidate were assessed using a political likability scale.

  What does the letter "a" represent

If the decision in the hypothesis test of population correlation is to reject the null hypothesis, what can we conclude about the population correlation.

  Test claim that proportion of consumers ages in range

Make a purchase using the internet. Test the claim that the proportion of consumers ages 35-44 who plan to make purchases using the internet has increased at α = 0.01.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd