Purchase Solution

How do you find the regression line for data from a used car dealership?

Not what you're looking for?

Ask Custom Question

See the attachments.
A used-car dealer randomly selects 100 three-year old Holden Barinas that were sold at auction during the past month. Each car was in top condition and was equipped with automatic transmission, AM/FM cassette tape player, and air conditioning. The dealer recorded the price and the number of km on the odometer.
These data are stored in the Excel file that is attached to this;

1. Find the regression line for these data.

2. What interpretation do you give the value of y when x = 0? Justify your answer.

3. Compute the sum of squares for error (SSE) and standard error of the estimate for the data.

4. Test to determine whether there is enough evidence in the data, to infer that there is a linear relationship between the price and the odometer reading, at 5% significance level.

5. Find the coefficient of determination for the data and describe what this statistic tells you about the regression model.

The same used-car dealer has an opportunity to bid on a lot of cars offered by a rental company. The rental company has 250 Holden Barinas, all equipped with automatic transmission, air conditioning and AM/FM cassette tape players. All of the cars in this lot have about 40,000km on the odometer. The dealer would like an estimate of the selling price of all the cars in the lot. Help him find this interval estimate.

Attachments
Purchase this Solution
Solution Summary

This solution provides step by step calculations, graph and interpretation of the results in an attached Word document.

Solution Preview

Please see attached files.

Supplementary exemption test

Question: 20 marks
A used-car dealer randomly selects 100 three-year old Holden Barinas that were sold at auction during the past month. Each car was in top condition and was equipped with automatic transmission, AM/FM cassette tape player, and air conditioning. The dealer recorded the price and the number of km on the odometer.
These data are stored in the Excel file that is attached to this;

Solution: We construct the following table with the given data. The yellow row shows the sums of columns.
explanatory variable, x response variable, ...

Purchase this Solution
Free BrainMass Quizzes
Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

View More Free Quizzes
Related BrainMass Solutions

  • Regression

    In today's economy, how can a business properly use regression? Easily. The trends of the market where the company does business is the regression line that the company will use.

  • Multiple Regression and T- Test

    You will need to do this to learn how to test if a coefficient is different from 1; it will explain how you calculate the t Statistic to test your null hypothesis from the Excel output.

  • Scatter diagram, regression

    Listed below is a random sample of 12 used cars sold at the dealership during the last year.

  • Regression Correlation Using a Data Set

    ANOVA is used to compare the means of three or more groups (however, it is also used in a regression analysis to see how good the regression model is at describing the data).

  • Auto Industry Research Project Examples

    I have an idea about a regression model of the auto industry but how do I determine what the dependent and independent variables are? Okay. Here's the thing about regression and dependent and independent variables.

  • Multiple Regression Analysis

    Owner hires a statistician who enters the data into statistical software package and the following equation is obtained: Y' = 9.606 + 1.998X1 + 0.222X2 A. How is this equation called? B.

  • Excel on the topic of multiple regression

    Listed below is a random sample of 12 used cars sold at the dealership during the last year.

  • Financial Intermediaries Discussion

    Consider whether you would buy a used car from a person or from a dealership. What are the pros and cons of each and how does that relate to the chapter material? 2.

  • consumption theory

    Think about the factors that influence your decision when you go to Walmart to buy shampoo versus the factors that influence your decision when you go to the car dealership to purchase a car.

View More Related Solutions