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

Not what you're looking for?

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.

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