**Comparing Car Values**
**The Regression Values of Used
Cars**
**By Ruth M. Naugle**

** What is important
in a brand new car? Is it the color? Maybe the gas mileage?
Or maybe the resale value? In an unsuccessful attempt to justify
myself buying a new car, five similar cars will be compared for their regressing
value. I'm sad to say my favorite car, Chrysler Sebring, did
the worst!**

**Five similar cars are compared
for the new car cost and then the expected cost for the next five years.
The five cars are convertibles and all within $2,000.00 of the new car
sticker price. Let's look at the cars. Click for details on
edmunds.com**

**Chrysler Sebring
Chevrolet Camaro Pontiac Firebird
Ford Mustang Toyota Camry Solara**
**Convertible GTC 2 dr
Convertible 2dr
Convertible 2dr Deluxe 2dr conv.
SE V6 2dr Convertible**
**(2.7L 6cyl 5M)
(3.8L 6cyl 5M)
(3.8L 6cyl 4A) (3.8L 6cyl 5M)
(3.0 L 6cyl 4A)**
**New: $26,894
$27,990
$27,555
$24.458
$29,600**
**1 Year: $17,076
$19,414
$18,965
$18,103
$21,943**
**2 Year: $14,743
$17,007
$16,922
$16,240
$19,303**
**3 Year: $12,689
$14,888
$15,125
$14,601
$16,981**
**4 Year: $10,869
$13,009
$13,531
$13,148
$14,923**
**5 Year: $9,235
$11,323
$12,101
$11,845
$13,076**

**With the car costs in hand, now
it is time to fit the data to an equation. The values most represent
a cubic regression graph. The R-Sq values are listed below.**

**Chrysler Sebring
Chevrolet Camaro Pontiac Firebird
Ford Mustang Toyota Camry Solara**

0.990
0.992
0.990
0.993
0.995

Now let's find the cubic equation of best fit.

**Sebring y=26609.9-(11596.8*x)+3311.11*x^2-(339.167*x^3)**

**Camaro y=27758.5-(10063.6*x)+2737.89*x^2-(278*x^3)**

**Firebird y=27306.5-(10146.5*x)+2896.63*x^2-(296.704*x^3)**

**Mustang y=24290.1-(7443.6*x)+1995.91*x^2-(202.074*x^3)**

**Solara y=29415.6-(8899.04*x)+2240.32*x^2-(224*x^3)**

Notice which cars held their value. While the Toyato
costs the most new, it also had the highest resale value. On the
other hand, the Mustang cost the least new, but was next to the highest
value after five years. My personal favorite, the Sebring, had the
lowest value after five years.

This graph not only shows the car values of the first five years, but the expected trend of the car values. There are many discussion questions that will benefit classes.

1. Why is the R-Sq value not equal to 1? Would you consider the R-Sq values of 0.990 a strong correlation?

2. Do you think a linear graph would better represent
the data and have a higher R-Sq value? Why?

Do you think a quadratic graph would better represent
the data and have a higher R-Sq value? Why?

3. Looking at the graph, do we need to restrict the range of the graph? What quadrant will the actual graph lie? Why?

4. What do you think the car values will be in years six and seven? Do you think they will continue to follow the cubic regression equations? Explain.

5. In what year does the car value drop the most?
What does this tell you about buying a new car? Almost new car?

Return to Naugle's Homepage