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

1-Determine the regression equation.

a=

b=

2- Estimate the selling price of an 7-year-old car (in $000).

3-Interpret the regression equation (in dollars).

Solutions

Expert Solution

Age(x) Price(y) xy x2
11 12.1 133.1 121
8 10.5 84 64
14 5.7 79.8 196
17 4.9 83.3 289
9 5 45 81
8 13.4 107.2 64
10 10.5 105 100
14 9 126 196
13 9 117 169
17 4.5 76.5 289
6 12.5 75 36
6 11.5 69 36
133.00 108.60 1100.90 1641.00 Total
11.08333 9.05 Average

=========================================

y = a + bx

  

==========================================

==================================================

y = 15.877 - 0.616*7= 11.565

==================================================

By Increasing one unit in age there is on an average 0.616 unit decrease in Price


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