Question

In: Statistics and Probability

The owner of Maumee Ford-Volvo wants to study the relationship between the age of a car...

The owner of Maumee Ford-Volvo wants to study the relationship between the age of a car and its selling price. Listed below is a random sample of 12 used cars sold at the dealership during the last year.

Car Age (years) Selling Price ($000)
1 15 12.0
2 10 10.1
3 17 5.4
4 19 4.9
5 12 5.6
6 11 12.6
7 13 9.7
8 17 9.0
9 16 9.0
10 19 4.9
11 8 11.4
12 8 9.9
  1. Determine the regression equation. (Negative amounts should be indicated by a minus sign. Round your answers to 3 decimal places.)

  2. A=___________ B=

  3. Estimate the selling price of an 11-year-old car (in $000). (Round your answer to 3 decimal places.)

  4. Interpret the regression equation (in dollars). (Round your answer to the nearest dollar amount.)

Solutions

Expert Solution

x y (x-x̅)² (y-ȳ)² (x-x̅)(y-ȳ)
15 12 1.56 10.84 4.11
10 10.1 14.06 1.94 -5.22
17 5.4 10.56 10.95 -10.75
19 4.9 27.56 14.50 -19.99
12 5.6 3.06 9.66 5.44
11 12.6 7.56 15.15 -10.70
13 9.7 0.56 0.98 -0.74
17 9 10.56 0.09 0.95
16 9 5.06 0.09 0.66
19 4.9 27.56 14.50 -19.99
8 11.4 33.06 7.25 -15.48
8 9.9 33.06 1.42 -6.85
ΣX ΣY Σ(x-x̅)² Σ(y-ȳ)² Σ(x-x̅)(y-ȳ)
total sum 165 104.5 174.25 87.349 -78.575
mean 13.750 8.708 SSxx SSyy SSxy

a)

sample size ,   n =   12          
here, x̅ = Σx / n=   13.75   ,     ȳ = Σy/n =   8.71  
                  
SSxx =    Σ(x-x̅)² =    174.2500          
SSxy=   Σ(x-x̅)(y-ȳ) =   -78.6          
                  
estimated slope , ß1 = SSxy/SSxx =   -78.6   /   174.250   =   -0.45093
                  
intercept,   ß0 = y̅-ß1* x̄ =   14.90866          
                  
so, regression line is   Ŷ =   14.909 - 0.451   *x

b) a = 14.909 , b = -0.451
c) Predicted Y at X=   11   is                  
Ŷ =   14.9087   +   -0.4509   *   11   =   9.948

d) For each additional year, the car decreases $ 451 in value


Related Solutions

The owner of Maumee Ford-Volvo wants to study the relationship between the age of a car...
The owner of Maumee Ford-Volvo wants to study the relationship between the age of a car and its selling price. Listed below is a random sample of 12 used cars sold at the dealership during the last year. Car Age (years) Selling Price ($000) 1 13 13.1 2 10 11.8 3 15 5.7 4 17 4.9 5 11 6.8 6 10 14.0 7 11 11.4 8 15 9.8 9 15 9.8 10 17 4.5 11 8 13.0 12 8 11.0...
The owner of Maumee Ford-Volvo wants to study the relationship between the age of a car...
The owner of Maumee Ford-Volvo wants to study the relationship between the age of a car and its selling price. Listed below is a random sample of 12 used cars sold at the dealership during the last year. Car: 1. 2, 3, 4,5,6,7,8,9,10,11,12 Age (years):9,6,11,15,8,6,8,12,9,15,5,5 Selling Price ($000): 10.4, 8.6, 4.3, 3.5, 5.1, 11.0, 9.1, 7.5, 7.5, 2.1,11.1, 10.1 Click here for the Excel Data File Determine the regression equation. (Negative amounts should be indicated by a minus sign. Round...
The owner of Maumee Ford-Volvo wants to study the relationship between the age of a car...
The owner of Maumee Ford-Volvo wants to study the relationship between the age of a car and its selling price. Listed below is a random sample of 12 used cars sold at the dealership during the last year. Car Age (years) Selling Price ($000) 1 11 12.1 2 8 10.5 3 14 5.7 4 17 4.9 5 9 5.0 6 8 13.4 7 10 10.5 8 14 9.0 9 13 9.0 10 17 4.5 11 6 12.5 12 6 11.5...
The owner of Maumee Ford-Volvo wants to study the relationship between the age of a car...
The owner of Maumee Ford-Volvo wants to study the relationship between the age of a car and its selling price. Listed below is a random sample of 12 used cars sold at the dealership during the last year. Car Age (years) Selling Price ($000) 1 9 12.0 2 8 10.9 3 10 4.6 4 12 4.3 5 9 5.6 6 8 13.5 7 9 8.9 8 11 9.7 9 10 9.7 10 12 2.7 11 6 10.6 12 6 8.9...
The owner of Maumee Ford-Volvo wants to study the relationship between the age of a car...
The owner of Maumee Ford-Volvo wants to study the relationship between the age of a car and its selling price. Listed below is a random sample of 12 used cars sold at the dealership during the last year. Car Age (years) Selling Price ($000) 1 9 8.1 2 7 6.0 3 11 3.6 4 12 4.0 5 8 5.0 6 7 10.0 7 8 7.6 8 11 8.0 9 10 8.0 10 12 6.0 11 6 8.6 12 6 8.0...
The owner of Maumee Ford-Volvo wants to study the relationship between the age of a car...
The owner of Maumee Ford-Volvo wants to study the relationship between the age of a car and its selling price. Listed below is a random sample of 12 used cars sold at the dealership during the last year. Car Age (years) Selling Price ($000) 1 11 12.2 2 8 11.0 3 16 4.9 4 18 4.1 5 9 6.7 6 8 13.6 7 10 11.1 8 16 9.0 9 14 9.0 10 18 4.2 11 6 12.1 12 6 10.4...
The owner of Maumee Ford-Mercury-Volvo wants to study the relationship between the age of a car...
The owner of Maumee Ford-Mercury-Volvo wants to study the relationship between the age of a car and its selling price. Listed below is a random sample of 12 used cars sold at the dealership during the last year. Car Age (years) Selling price 1 9 11.6 2 5 10.0 3 12 3.2 4 15 3.7 5 7 7.0 6 6 12.5 7 8 7.8 8 13 8.4 9 12 8.4 10 15 4.8 11 4 9.2 12    4 7.3...
The owner of Maumee Ford-Mercury-Volvo wants to study the relationship between the age of a car...
The owner of Maumee Ford-Mercury-Volvo wants to study the relationship between the age of a car and its selling price. Listed below is a random sample of 12 used cars sold at the dealership during the last year. Car Age (years) Selling price 1 9 11.6 2 5 10.0 3 12 3.2 4 15 3.7 5 7 7.0 6 6 12.5 7 8 7.8 8 13 8.4 9 12 8.4 10 15 4.8 11 4 9.2 12    4 7.3...
The owner of Maumee Ford-Mercury-Volvo wants to study the relationship between the age of a car...
The owner of Maumee Ford-Mercury-Volvo wants to study the relationship between the age of a car and it selling price. Listed below is a random sample of 12 used cars sold at the dealership during the last year. Car Age (Years) Selling Price ($000) 1 9 8.1 2 7 6.0 3 11 3.6 4 12 4.0 5 8 5.0 6 7 10.0 7 8 7.6 8 11 8.0 9 10 8.0 10 12 6.0 11 6 8.6 12 6 8.0...
The owner of Maumee Motors wants to study the relationship between the age of a car...
The owner of Maumee Motors wants to study the relationship between the age of a car and its selling price. Listed below is a random sample of 12 used cars sold at Maumee Motors last year: Car Age (years) Selling Price ($ ‘000) Car Age (years) Selling Price ($ ‘000) 1 9 8.1 7 8 7.6 2 7 6.0 8 11 8.0 3 11 3.6 9 10 8.0 4 12 4.0 10 12 6.0 5 8 5.0 11 6 8.6...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT