Loading...

MBA 6211 Managerial Decision Making (excel)

Open Posted By: surajrudrajnv33 Date: 28/02/2021 High School Assignment Writing

  Your team is establishing a used car dealership and would like to develop a pricing model to help set sticker prices. 

You have been given a set of car sales data for a large set of cars of the same make and model you intend to sell. 

An investor group would like to invest $5 million, but they want to see that you have a solid tool to help you price cars appropriately.

Review the car sales data on the "Cars Lab Data" tab.  Identify which variables are most likely to give you the best model.  Apply your general knowledge about car prices.  

You have decided to exclude Trim and Model.  Generate a correlation matrix for the remaining variables. Comment on the values and what concerns if any you might have with the variables. NOTE:  Make should be set-up as an indicator variable.

Develop two simple regression models for Price.  For one model use Mileage as the independent variable. For the 2nd model use Make as the independent variable.  Define the model equation  for each regression.  Comment on the results of the two models and how they predict price.

Run a multiple regression model for price with all variables EXCEPT Trim and Model. Comment on the results and the validity of the model parameters as predictors.

Starting with your model from Q4, follow a step-wise regression process to eliminate independent variables that fail one of the regression assumptions or statistical tests (i.e., p-values).  Write your final model equation.   Comment on the final regression results. 

please see attachment

Category: Mathematics & Physics Subjects: Calculus Deadline: 24 Hours Budget: $80 - $120 Pages: 2-3 Pages (Short Assignment)

Attachment 1

Instructions

Team Members
1
2
3
POINTS INSTRUCTIONS
Q1 10 Review the car sales data on the "Cars Lab Data" tab. Identify which variables are most likely to give you the best model. Apply your general knowledge about car prices.
Q2 20 You have decided to exclude Trim and Model. Generate a correlation matrix for the remaining variables. Comment on the values and what concerns if any you might have with the variables. NOTE: Make should be set-up as an indicator variable.
Q3 20 Develop two simple regression models for Price. For one model use Mileage as the independent variable. For the 2nd model use Make as the independent variable. Define the model equation for each regression. Comment on the results of the two models and how they predict price.
Q4 20 Run a multiple regression model for price with all variables EXCEPT Trim and Model. Comment on the results and the validity of the model parameters as predictors.
Q5 30 Starting with your model from Q4, follow a step-wise regression process to eliminate independent variables that fail one of the regression assumptions or statistical tests (i.e., p-values). Write your final model equation. Comment on the final regression results.
100
Your team is establishing a used car dealership and would like to develop a pricing model to help set sticker prices. You have been given a set of car sales data for a large set of cars of the same make and model you intend to sell. An investor group would like to invest $5 million, but they want to see that you have a solid tool to help you price cars appropriately.

Cars Lab Data

Price Mileage Make Model Trim Type Cylinder Liter Doors Cruise Sound Leather
17314.1031289016 8221 Buick Century Sedan 4D Sedan 6 3.1 4 1 1 1
17542.0360832793 9135 Buick Century Sedan 4D Sedan 6 3.1 4 1 1 0
16218.8478619377 13196 Buick Century Sedan 4D Sedan 6 3.1 4 1 1 0
16336.9131400486 16342 Buick Century Sedan 4D Sedan 6 3.1 4 1 0 0
16339.1703239255 19832 Buick Century Sedan 4D Sedan 6 3.1 4 1 0 1
15709.0528210833 22236 Buick Century Sedan 4D Sedan 6 3.1 4 1 1 0
15230.0033898479 22576 Buick Century Sedan 4D Sedan 6 3.1 4 1 1 0
15048.042184116 22964 Buick Century Sedan 4D Sedan 6 3.1 4 1 1 0
14862.0938695978 24021 Buick Century Sedan 4D Sedan 6 3.1 4 1 0 1
15295.0182668788 27325 Buick Century Sedan 4D Sedan 6 3.1 4 1 1 1
21335.852484891 10237 Buick Lacrosse CX Sedan 4D Sedan 6 3.6 4 1 0 0
20538.0875102254 15066 Buick Lacrosse CX Sedan 4D Sedan 6 3.6 4 1 1 0
20512.0940912389 16633 Buick Lacrosse CX Sedan 4D Sedan 6 3.6 4 1 1 0
19924.159052404 19800 Buick Lacrosse CX Sedan 4D Sedan 6 3.6 4 1 1 1
19774.2490660661 23359 Buick Lacrosse CX Sedan 4D Sedan 6 3.6 4 1 1 1
19344.1655373569 23765 Buick Lacrosse CX Sedan 4D Sedan 6 3.6 4 1 1 0
19105.1301244159 24008 Buick Lacrosse CX Sedan 4D Sedan 6 3.6 4 1 0 0
18543.4270453653 26034 Buick Lacrosse CX Sedan 4D Sedan 6 3.6 4 1 1 1
17808.1989960206 32896 Buick Lacrosse CX Sedan 4D Sedan 6 3.6 4 1 1 0
17968.8382782646 34665 Buick Lacrosse CX Sedan 4D Sedan 6 3.6 4 1 1 1
22358.8776781171 8970 Buick Lacrosse CXL Sedan 4D Sedan 6 3.6 4 1 1 0
23785.9225263772 10577 Buick Lacrosse CXL Sedan 4D Sedan 6 3.6 4 1 1 1
22926.0903712553 14363 Buick Lacrosse CXL Sedan 4D Sedan 6 3.6 4 1 1 1
21895.7587842006 16508 Buick Lacrosse CXL Sedan 4D Sedan 6 3.6 4 1 0 1
21273.0617139201 18908 Buick Lacrosse CXL Sedan 4D Sedan 6 3.6 4 1 0 0
21460.0139528911 19467 Buick Lacrosse CXL Sedan 4D Sedan 6 3.6 4 1 0 1
21183.1235874235 21394 Buick Lacrosse CXL Sedan 4D Sedan 6 3.6 4 1 0 0
20406.0995028936 22596 Buick Lacrosse CXL Sedan 4D Sedan 6 3.6 4 1 0 0
21058.1395799539 24469 Buick Lacrosse CXL Sedan 4D Sedan 6 3.6 4 1 1 1
19556.8993202892 25245 Buick Lacrosse CXL Sedan 4D Sedan 6 3.6 4 1 0 0
23447.6865610148 15755 Buick Lacrosse CXS Sedan 4D Sedan 6 3.8 4 1 1 0
23547.2394428773 16235 Buick Lacrosse CXS Sedan 4D Sedan 6 3.8 4 1 1 0
23016.0080086817 18147 Buick Lacrosse CXS Sedan 4D Sedan 6 3.8 4 1 1 1
22230.0275025572 22102 Buick Lacrosse CXS Sedan 4D Sedan 6 3.8 4 1 0 1
22625.0735660496 23612 Buick Lacrosse CXS Sedan 4D Sedan 6 3.8 4 1 0 1
21799.1720968887 24439 Buick Lacrosse CXS Sedan 4D Sedan 6 3.8 4 1 0 0
21341.2572070745 25212 Buick Lacrosse CXS Sedan 4D Sedan 6 3.8 4 1 1 1
21683.0314635547 26779 Buick Lacrosse CXS Sedan 4D Sedan 6 3.8 4 1 1 0
20986.0160174846 27096 Buick Lacrosse CXS Sedan 4D Sedan 6 3.8 4 1 0 0
20902.1037943119 29649 Buick Lacrosse CXS Sedan 4D Sedan 6 3.8 4 1 1 1
20698.077083173 2992 Buick Lesabre Custom Sedan 4D Sedan 6 3.8 4 1 0 1
20099.25684484 10036 Buick Lesabre Custom Sedan 4D Sedan 6 3.8 4 1 1 1
18145.1264890935 18339 Buick Lesabre Custom Sedan 4D Sedan 6 3.8 4 1 1 0
17944.8569234593 19592 Buick Lesabre Custom Sedan 4D Sedan 6 3.8 4 1 0 0
19027.8623054345 21797 Buick Lesabre Custom Sedan 4D Sedan 6 3.8 4 1 0 1
18348.8985716945 23852 Buick Lesabre Custom Sedan 4D Sedan 6 3.8 4 1 1 0
17750.8845746284 25040 Buick Lesabre Custom Sedan 4D Sedan 6 3.8 4 1 1 0
17772.9696800412 25052 Buick Lesabre Custom Sedan 4D Sedan 6 3.8 4 1 1 0
17394.0213978031 25464 Buick Lesabre Custom Sedan 4D Sedan 6 3.8 4 1 1 0
17645.7450441435 27830 Buick Lesabre Custom Sedan 4D Sedan 6 3.8 4 1 1 1
21908.3666246247 17353 Buick Lesabre Limited Sedan 4D Sedan 6 3.8 4 1 0 0
21956.3426627084 17787 Buick Lesabre Limited Sedan 4D Sedan 6 3.8 4 1 1 0
21646.1169235536 19562 Buick Lesabre Limited Sedan 4D Sedan 6 3.8 4 1 1 1
21575.4568270006 20137 Buick Lesabre Limited Sedan 4D Sedan 6 3.8 4 1 1 0
20952.2178015953 20158 Buick Lesabre Limited Sedan 4D Sedan 6 3.8 4 1 1 0
21562.0475778626 23767 Buick Lesabre Limited Sedan 4D Sedan 6 3.8 4 1 0 1
19981.1279114169 24323 Buick Lesabre Limited Sedan 4D Sedan 6 3.8 4 1 1 0
19425.848616327 27839 Buick Lesabre Limited Sedan 4D Sedan 6 3.8 4 1 1 0
19191.9896168454 29187 Buick Lesabre Limited Sedan 4D Sedan 6 3.8 4 1 1 1
19641.7419023285 31324 Buick Lesabre Limited Sedan 4D Sedan 6 3.8 4 1 1 1
25589.9831546314 2308 Buick Park Avenue Sedan 4D Sedan 6 3.8 4 1 1 0
25098.6290571529 10014 Buick Park Avenue Sedan 4D Sedan 6 3.8 4 1 1 0
23420.7069479383 18910 Buick Park Avenue Sedan 4D Sedan 6 3.8 4 1 0 1
22661.0484850784 20105 Buick Park Avenue Sedan 4D Sedan 6 3.8 4 1 0 0
23493.0822950037 20453 Buick Park Avenue Sedan 4D Sedan 6 3.8 4 1 1 0
22435.2028189367 22287 Buick Park Avenue Sedan 4D Sedan 6 3.8 4 1 1 1
21878.1199960255 23237 Buick Park Avenue Sedan 4D Sedan 6 3.8 4 1 1 0
23077.5659102738 23798 Buick Park Avenue Sedan 4D Sedan 6 3.8 4 1 0 1
21698.0147455068 25489 Buick Park Avenue Sedan 4D Sedan 6 3.8 4 1 1 1
21831.8229163745 25564 Buick Park Avenue Sedan 4D Sedan 6 3.8 4 1 1 1
26831.1940371618 4695 Buick Park Avenue Special Ed Ultra 4D Sedan 6 3.8 4 1 1 0
26060.3353495608 9795 Buick Park Avenue Special Ed Ultra 4D Sedan 6 3.8 4 1 1 0
26781.8146452916 12052 Buick Park Avenue Special Ed Ultra 4D Sedan 6 3.8 4 1 1 0
26302.0742843396 13050 Buick Park Avenue Special Ed Ultra 4D Sedan 6 3.8 4 1 1 0
26190.271467539 17335 Buick Park Avenue Special Ed Ultra 4D Sedan 6 3.8 4 1 0 1
25508.2109561095 17480 Buick Park Avenue Special Ed Ultra 4D Sedan 6 3.8 4 1 1 0
23348.0169540994 24027 Buick Park Avenue Special Ed Ultra 4D Sedan 6 3.8 4 1 0 1
23406.6898198106 25387 Buick Park Avenue Special Ed Ultra 4D Sedan 6 3.8 4 1 0 1
23159.5437816049 25869 Buick Park Avenue Special Ed Ultra 4D Sedan 6 3.8 4 1 0 0
21536.7417301751 37128 Buick Park Avenue Special Ed Ultra 4D Sedan 6 3.8 4 1 1 1
51154.0472155256 2202 Cadillac CST-V Sedan 4D Sedan 8 5.7 4 1 1 1
49248.1589666802 6685 Cadillac CST-V Sedan 4D Sedan 8 5.7 4 1 0 1
46747.6732703394 15343 Cadillac CST-V Sedan 4D Sedan 8 5.7 4 1 1 1
44130.6170551092 21341 Cadillac CST-V Sedan 4D Sedan 8 5.7 4 1 0 1
44084.9142115635 21367 Cadillac CST-V Sedan 4D Sedan 8 5.7 4 1 1 1
43892.4678804136 23371 Cadillac CST-V Sedan 4D Sedan 8 5.7 4 1 0 1
44300.6399582244 23751 Cadillac CST-V Sedan 4D Sedan 8 5.7 4 1 0 1
42677.6011170355 24052 Cadillac CST-V Sedan 4D Sedan 8 5.7 4 1 0 1
43374.0524199581 25199 Cadillac CST-V Sedan 4D Sedan 8 5.7 4 1 1 1
40619.0722701075 30082 Cadillac CST-V Sedan 4D Sedan 8 5.7 4 1 1 1
33417.9650130136 6598 Cadillac CTS Sedan 4D Sedan 6 2.8 4 1 1 1
30957.0807492764 10625 Cadillac CTS Sedan 4D Sedan 6 2.8 4 1 1 1
31431.1303699804 11013 Cadillac CTS Sedan 4D Sedan 6 2.8 4 1 1 1
30781.5156334759 14937 Cadillac CTS Sedan 4D Sedan 6 2.8 4 1 1 1
30646.4377005909 17094 Cadillac CTS Sedan 4D Sedan 6 2.8 4 1 1 1
30792.149028548 17870 Cadillac CTS Sedan 4D Sedan 6 2.8 4 1 1 1
30392.7501583834 18449 Cadillac CTS Sedan 4D Sedan 6 2.8 4 1 1 1
28817.081846577 21039 Cadillac CTS Sedan 4D Sedan 6 2.8 4 1 0 1
29275.2087136945 21056 Cadillac CTS Sedan 4D Sedan 6 2.8 4 1 1 1
28040.1285291642 27484 Cadillac CTS Sedan 4D Sedan 6 2.8 4 1 1 1
39801.5513542673 14095 Cadillac Deville DHS Sedan 4D Sedan 8 4.6 4 1 0 1
40335.7373136253 14743 Cadillac Deville DHS Sedan 4D Sedan 8 4.6 4 1 0 1
39307.0091649632 16041 Cadillac Deville DHS Sedan 4D Sedan 8 4.6 4 1 0 1
38600.2395609372 17138 Cadillac Deville DHS Sedan 4D Sedan 8 4.6 4 1 0 1
38445.8971686577 18661 Cadillac Deville DHS Sedan 4D Sedan 8 4.6 4 1 0 1
36077.7961212207 21966 Cadillac Deville DHS Sedan 4D Sedan 8 4.6 4 1 0 1
35866.5827089002 24415 Cadillac Deville DHS Sedan 4D Sedan 8 4.6 4 1 1 1
35338.6536895564 25163 Cadillac Deville DHS Sedan 4D Sedan 8 4.6 4 1 0 1
36154.30354834 25339 Cadillac Deville DHS Sedan 4D Sedan 8 4.6 4 1 1 1
34685.6629801958 25421 Cadillac Deville DHS Sedan 4D Sedan 8 4.6 4 1 0 1
42820.3290225306 5499 Cadillac Deville DTS Sedan 4D Sedan 8 4.6 4 1 0 1
41378.0480886471 8125 Cadillac Deville DTS Sedan 4D Sedan 8 4.6 4 1 0 1
40856.3908954186 12791 Cadillac Deville DTS Sedan 4D Sedan 8 4.6 4 1 1 1
41419.0372622102 14452 Cadillac Deville DTS Sedan 4D Sedan 8 4.6 4 1 0 1
37510.2535700618 21593 Cadillac Deville DTS Sedan 4D Sedan 8 4.6 4 1 0 1
37215.1693828106 22211 Cadillac Deville DTS Sedan 4D Sedan 8 4.6 4 1 0 1
36332.8946850132 25153 Cadillac Deville DTS Sedan 4D Sedan 8 4.6 4 1 0 1
36245.1582278249 26250 Cadillac Deville DTS Sedan 4D Sedan 8 4.6 4 1 1 1
32954.1413357696 36074 Cadillac Deville DTS Sedan 4D Sedan 8 4.6 4 1 0 1
32537.1867506849 41829 Cadillac Deville DTS Sedan 4D Sedan 8 4.6 4 1 1 1
35715.7685557755 6447 Cadillac Deville Sedan 4D Sedan 8 4.6 4 1 0 1
35651.6800199489 10555 Cadillac Deville Sedan 4D Sedan 8 4.6 4 1 1 1
35129.3407710218 11975 Cadillac Deville Sedan 4D Sedan 8 4.6 4 1 1 1
35165.7593689444 13449 Cadillac Deville Sedan 4D Sedan 8 4.6 4 1 1 1
32501.2451886184 17508 Cadillac Deville Sedan 4D Sedan 8 4.6 4 1 0 1
33220.0284461651 18661 Cadillac Deville Sedan 4D Sedan 8 4.6 4 1 0 1
32509.4782883263 20910 Cadillac Deville Sedan 4D Sedan 8 4.6 4 1 0 1
31132.2134919243 23124 Cadillac Deville Sedan 4D Sedan 8 4.6 4 1 1 1
31181.7151590146 26222 Cadillac Deville Sedan 4D Sedan 8 4.6 4 1 0 1
31059.1810267505 27544 Cadillac Deville Sedan 4D Sedan 8 4.6 4 1 1 1
42741.5236662022 2846 Cadillac STS-V6 Sedan 4D Sedan 6 3.6 4 1 0 1
40966.607412216 7476 Cadillac STS-V6 Sedan 4D Sedan 6 3.6 4 1 1 1
38795.379094999 13973 Cadillac STS-V6 Sedan 4D Sedan 6 3.6 4 1 1 1
38297.4625362805 16754 Cadillac STS-V6 Sedan 4D Sedan 6 3.6 4 1 0 1
37192.8963660869 19100 Cadillac STS-V6 Sedan 4D Sedan 6 3.6 4 1 0 1
36210.1229959601 21778 Cadillac STS-V6 Sedan 4D Sedan 6 3.6 4 1 0 1
36633.6338191184 22042 Cadillac STS-V6 Sedan 4D Sedan 6 3.6 4 1 1 1
35895.4994099277 23056 Cadillac STS-V6 Sedan 4D Sedan 6 3.6 4 1 1 1
34974.3780366418 25796 Cadillac STS-V6 Sedan 4D Sedan 6 3.6 4 1 1 1
32038.3395625994 35326 Cadillac STS-V6 Sedan 4D Sedan 6 3.6 4 1 1 1
48310.3295448604 788 Cadillac STS-V8 Sedan 4D Sedan 8 4.6 4 1 0 1
48365.9808965303 2616 Cadillac STS-V8 Sedan 4D Sedan 8 4.6 4 1 1 1
45061.9519351521 13829 Cadillac STS-V8 Sedan 4D Sedan 8 4.6 4 1 1 1
44205.8758848709 15104 Cadillac STS-V8 Sedan 4D Sedan 8 4.6 4 1 0 1
42377.9554420775 18581 Cadillac STS-V8 Sedan 4D Sedan 8 4.6 4 1 0 1
41671.5831400912 20575 Cadillac STS-V8 Sedan 4D Sedan 8 4.6 4 1 0 1
41516.4298622847 23861 Cadillac STS-V8 Sedan 4D Sedan 8 4.6 4 1 1 1
41053.4821681014 25717 Cadillac STS-V8 Sedan 4D Sedan 8 4.6 4 1 1 1
38208.5010233112 31303 Cadillac STS-V8 Sedan 4D Sedan 8 4.6 4 1 1 1
39072.3920526084 31587 Cadillac STS-V8 Sedan 4D Sedan 8 4.6 4 1 0 1
70755.4667165429 583 Cadillac XLR-V8 Hardtop Conv 2D Convertible 8 4.6 2 1 1 1
68566.1871889452 6420 Cadillac XLR-V8 Hardtop Conv 2D Convertible 8 4.6 2 1 1 1
69133.7317224283 7892 Cadillac XLR-V8 Hardtop Conv 2D Convertible 8 4.6 2 1 1 1
66374.307040191 12021 Cadillac XLR-V8 Hardtop Conv 2D Convertible 8 4.6 2 1 1 1
65281.4812369002 15600 Cadillac XLR-V8 Hardtop Conv 2D Convertible 8 4.6 2 1 1 1
63913.117247728 18200 Cadillac XLR-V8 Hardtop Conv 2D Convertible 8 4.6 2 1 1 1
60567.5490933118 23193 Cadillac XLR-V8 Hardtop Conv 2D Convertible 8 4.6 2 1 1 1
57154.4434368902 29260 Cadillac XLR-V8 Hardtop Conv 2D Convertible 8 4.6 2 1 1 1
55639.087653624 31805 Cadillac XLR-V8 Hardtop Conv 2D Convertible 8 4.6 2 1 0 1
52001.9943785519 42691 Cadillac XLR-V8 Hardtop Conv 2D Convertible 8 4.6 2 1 1 1
12146.188030901 10011 Chevrolet AVEO LS Hatchback 4D Hatchback 4 1.6 4 0 0 1
12163.8204246793 12101 Chevrolet AVEO LS Hatchback 4D Hatchback 4 1.6 4 0 0 1
11472.0227614221 19699 Chevrolet AVEO LS Hatchback 4D Hatchback 4 1.6 4 0 0 1
11017.1687101034 20100 Chevrolet AVEO LS Hatchback 4D Hatchback 4 1.6 4 0 1 0
11096.8572677413 20334 Chevrolet AVEO LS Hatchback 4D Hatchback 4 1.6 4 1 0 0
10386.0402183223 22225 Chevrolet AVEO LS Hatchback 4D Hatchback 4 1.6 4 0 0 0
11137.0456549156 22484 Chevrolet AVEO LS Hatchback 4D Hatchback 4 1.6 4 0 1 1
11045.1088444444 24568 Chevrolet AVEO LS Hatchback 4D Hatchback 4 1.6 4 1 0 1
10777.0525369432 27906 Chevrolet AVEO LS Hatchback 4D Hatchback 4 1.6 4 0 0 0
9928.18817462 29680 Chevrolet AVEO LS Hatchback 4D Hatchback 4 1.6 4 0 0 1
12649.1108932523 3629 Chevrolet AVEO LS Sedan 4D Sedan 4 1.6 4 0 1 0
12314.5912168875 4142 Chevrolet AVEO LS Sedan 4D Sedan 4 1.6 4 0 1 0
11318.0080892492 11156 Chevrolet AVEO LS Sedan 4D Sedan 4 1.6 4 0 1 1
12409.9490936339 11981 Chevrolet AVEO LS Sedan 4D Sedan 4 1.6 4 1 1 1
11555.2674020388 13404 Chevrolet AVEO LS Sedan 4D Sedan 4 1.6 4 1 1 0
11700.1114861059 15253 Chevrolet AVEO LS Sedan 4D Sedan 4 1.6 4 1 0 0
11215.0186466687 19945 Chevrolet AVEO LS Sedan 4D Sedan 4 1.6 4 0 0 0
10144.9520806874 23963 Chevrolet AVEO LS Sedan 4D Sedan 4 1.6 4 1 1 0
10491.0751985073 30948 Chevrolet AVEO LS Sedan 4D Sedan 4 1.6 4 0 1 0
9954.0541735153 37345 Chevrolet AVEO LS Sedan 4D Sedan 4 1.6 4 0 1 1
11031.1299312763 20156 Chevrolet AVEO LT Hatchback 4D Hatchback 4 1.6 4 0 1 1
11343.0540104663 20186 Chevrolet AVEO LT Hatchback 4D Hatchback 4 1.6 4 1 1 1
11391.2137175199 21421 Chevrolet AVEO LT Hatchback 4D Hatchback 4 1.6 4 0 1 1
11247.8625348134 21427 Chevrolet AVEO LT Hatchback 4D Hatchback 4 1.6 4 1 1 1
10921.9453718505 23119 Chevrolet AVEO LT Hatchback 4D Hatchback 4 1.6 4 0 1 1
11179.9535714763 23121 Chevrolet AVEO LT Hatchback 4D Hatchback 4 1.6 4 0 1 1
11394.8864029007 25107 Chevrolet AVEO LT Hatchback 4D Hatchback 4 1.6 4 0 1 1
11070.0606430562 25476 Chevrolet AVEO LT Hatchback 4D Hatchback 4 1.6 4 0 1 1
11013.8713677377 25746 Chevrolet AVEO LT Hatchback 4D Hatchback 4 1.6 4 1 1 1
11115.0136403057 30056 Chevrolet AVEO LT Hatchback 4D Hatchback 4 1.6 4 1 1 1
11918.4560683637 7278 Chevrolet AVEO LT Sedan 4D Sedan 4 1.6 4 0 0 0
12408.8061477178 10213 Chevrolet AVEO LT Sedan 4D Sedan 4 1.6 4 0 0 1
11302.9029854314 14627 Chevrolet AVEO LT Sedan 4D Sedan 4 1.6 4 0 1 0
11615.0210175723 19014 Chevrolet AVEO LT Sedan 4D Sedan 4 1.6 4 0 1 1
10805.1300898776 21013 Chevrolet AVEO LT Sedan 4D Sedan 4 1.6 4 1 1 1
11169.9183881598 22380 Chevrolet AVEO LT Sedan 4D Sedan 4 1.6 4 0 1 0
10770.1065537592 25065 Chevrolet AVEO LT Sedan 4D Sedan 4 1.6 4 0 1 0
10872.0139256473 25869 Chevrolet AVEO LT Sedan 4D Sedan 4 1.6 4 0 0 0
10921.9453718505 27776 Chevrolet AVEO LT Sedan 4D Sedan 4 1.6 4 1 0 0
9919.0481851502 34621 Chevrolet AVEO LT Sedan 4D Sedan 4 1.6 4 0 1 0
10813.3435213691 266 Chevrolet AVEO SVM Hatchback 4D Hatchback 4 1.6 4 1 0 1
11167.8610026522 4716 Chevrolet AVEO SVM Hatchback 4D Hatchback 4 1.6 4 1 1 0
10897.0765061322 6699 Chevrolet AVEO SVM Hatchback 4D Hatchback 4 1.6 4 0 1 1
10106.0164308559 14200 Chevrolet AVEO SVM Hatchback 4D Hatchback 4 1.6 4 1 0 0
10354.043852073 14521 Chevrolet AVEO SVM Hatchback 4D Hatchback 4 1.6 4 0 1 0
10287.9773632912 16521 Chevrolet AVEO SVM Hatchback 4D Hatchback 4 1.6 4 1 1 1
9720.978889532 20836 Chevrolet AVEO SVM Hatchback 4D Hatchback 4 1.6 4 1 1 0
9506.0479365628 22169 Chevrolet AVEO SVM Hatchback 4D Hatchback 4 1.6 4 0 0 1
9789.0376755218 22986 Chevrolet AVEO SVM Hatchback 4D Hatchback 4 1.6 4 0 1 1
9220.8296768938 29992 Chevrolet AVEO SVM Hatchback 4D Hatchback 4 1.6 4 1 0 1
10971.095614346 7091 Chevrolet AVEO SVM Sedan 4D Sedan 4 1.6 4 1 0 0
10315.0182335679 14438 Chevrolet AVEO SVM Sedan 4D Sedan 4 1.6 4 0 0 1
9654.0601415554 19183 Chevrolet AVEO SVM Sedan 4D Sedan 4 1.6 4 0 0 0
9563.7893088035 19273 Chevrolet AVEO SVM Sedan 4D Sedan 4 1.6 4 1 1 0
9665.8488597254 19565 Chevrolet AVEO SVM Sedan 4D Sedan 4 1.6 4 0 1 1
9482.2194038519 24842 Chevrolet AVEO SVM Sedan 4D Sedan 4 1.6 4 1 0 0
8638.9308952607 25216 Chevrolet AVEO SVM Sedan 4D Sedan 4 1.6 4 0 0 0
9041.9062544231 26191 Chevrolet AVEO SVM Sedan 4D Sedan 4 1.6 4 0 0 1
8870.9473158828 32914 Chevrolet AVEO SVM Sedan 4D Sedan 4 1.6 4 1 1 0
8768.9985850476 35299 Chevrolet AVEO SVM Sedan 4D Sedan 4 1.6 4 0 0 0
13007.9841778516 7372 Chevrolet Cavalier Coupe 2D Coupe 4 2.2 2 1 1 1
13041.8739972685 13607 Chevrolet Cavalier Coupe 2D Coupe 4 2.2 2 0 1 1
12045.9207049382 19136 Chevrolet Cavalier Coupe 2D Coupe 4 2.2 2 0 1 1
12469.5275763349 19712 Chevrolet Cavalier Coupe 2D Coupe 4 2.2 2 0 1 1
11539.8456500509 22405 Chevrolet Cavalier Coupe 2D Coupe 4 2.2 2 0 1 1
11726.0029740958 23103 Chevrolet Cavalier Coupe 2D Coupe 4 2.2 2 0 1 1
12207.8729264778 23512 Chevrolet Cavalier Coupe 2D Coupe 4 2.2 2 1 1 1
11203.1461094233 27364 Chevrolet Cavalier Coupe 2D Coupe 4 2.2 2 1 1 1
10788.9703604113 31436 Chevrolet Cavalier Coupe 2D Coupe 4 2.2 2 1 1 1
11149.6183039318 34447 Chevrolet Cavalier Coupe 2D Coupe 4 2.2 2 1 1 1
14584.4481222842 1160 Chevrolet Cavalier LS Coupe 2D Coupe 4 2.2 2 1 1 1
13681.6980034947 10210 Chevrolet Cavalier LS Coupe 2D Coupe 4 2.2 2 1 1 1
13446.2134153449 17741 Chevrolet Cavalier LS Coupe 2D Coupe 4 2.2 2 0 1 1
12327.6416083986 19347 Chevrolet Cavalier LS Coupe 2D Coupe 4 2.2 2 0 1 1
12274.957581255 19612 Chevrolet Cavalier LS Coupe 2D Coupe 4 2.2 2 1 1 1
12630.775033594 22571 Chevrolet Cavalier LS Coupe 2D Coupe 4 2.2 2 1 1 1
12425.389171155 22771 Chevrolet Cavalier LS Coupe 2D Coupe 4 2.2 2 0 1 1
12319.6962456923 24568 Chevrolet Cavalier LS Coupe 2D Coupe 4 2.2 2 1 1 1
12549.8923338761 25816 Chevrolet Cavalier LS Coupe 2D Coupe 4 2.2 2 0 1 1
12234.8880532682 30297 Chevrolet Cavalier LS Coupe 2D Coupe 4 2.2 2 1 1 1
14894.9825925289 2464 Chevrolet Cavalier LS Sedan 4D Sedan 4 2.2 4 0 1 1
14198.0924588603 11322 Chevrolet Cavalier LS Sedan 4D Sedan 4 2.2 4 1 1 1
14678.1053344102 11488 Chevrolet Cavalier LS Sedan 4D Sedan 4 2.2 4 1 1 1
13167.7023212763 14630 Chevrolet Cavalier LS Sedan 4D Sedan 4 2.2 4 0 1 1
13471.005082758 18910 Chevrolet Cavalier LS Sedan 4D Sedan 4 2.2 4 1 1 1
12573.8999394396 25048 Chevrolet Cavalier LS Sedan 4D Sedan 4 2.2 4 1 1 1
12383.4028106156 25069 Chevrolet Cavalier LS Sedan 4D Sedan 4 2.2 4 1 1 1
13230.9186744652 25862 Chevrolet Cavalier LS Sedan 4D Sedan 4 2.2 4 0 1 1
11080.5163779118 36855 Chevrolet Cavalier LS Sedan 4D Sedan 4 2.2 4 0 1 1
11328.9588677842 39946 Chevrolet Cavalier LS Sedan 4D Sedan 4 2.2 4 1 1 1
15053.9337347275 4652 Chevrolet Cavalier LS Sport Coupe 2D Coupe 4 2.2 2 1 1 1
14397.9280845869 5189 Chevrolet Cavalier LS Sport Coupe 2D Coupe 4 2.2 2 0 1 1
14642.3235774312 6224 Chevrolet Cavalier LS Sport Coupe 2D Coupe 4 2.2 2 0 1 1
13464.8028838785 14231 Chevrolet Cavalier LS Sport Coupe 2D Coupe 4 2.2 2 1 1 1
13678.863002609 17971 Chevrolet Cavalier LS Sport Coupe 2D Coupe 4 2.2 2 1 1 1
12507.4852674251 19715 Chevrolet Cavalier LS Sport Coupe 2D Coupe 4 2.2 2 1 1 1
13141.047950472 19898 Chevrolet Cavalier LS Sport Coupe 2D Coupe 4 2.2 2 1 1 1
13594.085591089 20682 Chevrolet Cavalier LS Sport Coupe 2D Coupe 4 2.2 2 1 1 1
12733.8579244968 21386 Chevrolet Cavalier LS Sport Coupe 2D Coupe 4 2.2 2 1 1 1
12230.0997724465 28408 Chevrolet Cavalier LS Sport Coupe 2D Coupe 4 2.2 2 0 1 1
14222.3053952433 8427 Chevrolet Cavalier LS Sport Sedan 4D Sedan 4 2.2 4 0 1 1
14266.9125758461 8615 Chevrolet Cavalier LS Sport Sedan 4D Sedan 4 2.2 4 0 1 1
14255.7476815217 16958 Chevrolet Cavalier LS Sport Sedan 4D Sedan 4 2.2 4 0 1 1
13762.9014468935 18040 Chevrolet Cavalier LS Sport Sedan 4D Sedan 4 2.2 4 1 1 1
14275.1276351584 18533 Chevrolet Cavalier LS Sport Sedan 4D Sedan 4 2.2 4 1 1 1
13688.0001092708 18766 Chevrolet Cavalier LS Sport Sedan 4D Sedan 4 2.2 4 1 1 1
13308.8337494544 20043 Chevrolet Cavalier LS Sport Sedan 4D Sedan 4 2.2 4 0 1 1
14145.8809893247 20512 Chevrolet Cavalier LS Sport Sedan 4D Sedan 4 2.2 4 1 1 1
12944.9387536629 21684 Chevrolet Cavalier LS Sport Sedan 4D Sedan 4 2.2 4 0 1 1
12846.0615931645 27560 Chevrolet Cavalier LS Sport Sedan 4D Sedan 4 2.2 4 1 1 1
14061.1227650226 4922 Chevrolet Cavalier Sedan 4D Sedan 4 2.2 4 0 1 1
13072.8416305329 14311 Chevrolet Cavalier Sedan 4D Sedan 4 2.2 4 0 1 1
11699.0339156388 19816 Chevrolet Cavalier Sedan 4D Sedan 4 2.2 4 1 1 1
12257.1640856157 21492 Chevrolet Cavalier Sedan 4D Sedan 4 2.2 4 1 1 1
11574.1738126532 21525 Chevrolet Cavalier Sedan 4D Sedan 4 2.2 4 0 1 1
11539.0485332856 24163 Chevrolet Cavalier Sedan 4D Sedan 4 2.2 4 0 1 1
12243.0606241256 25014 Chevrolet Cavalier Sedan 4D Sedan 4 2.2 4 1 1 1
11671.8581267356 25727 Chevrolet Cavalier Sedan 4D Sedan 4 2.2 4 1 1 1
11464.6288587837 29410 Chevrolet Cavalier Sedan 4D Sedan 4 2.2 4 1 1 1
10546.7827451076 38866 Chevrolet Cavalier Sedan 4D Sedan 4 2.2 4 1 1 1
15553.2087144133 7695 Chevrolet Classic Sedan 4D Sedan 4 2.2 4 0 1 1
15047.0027380893 12305 Chevrolet Classic Sedan 4D Sedan 4 2.2 4 1 1 1
13540.0416416542 17343 Chevrolet Classic Sedan 4D Sedan 4 2.2 4 0 1 1
14077.9688527613 17445 Chevrolet Classic Sedan 4D Sedan 4 2.2 4 0 1 1
12981.9520292971 20309 Chevrolet Classic Sedan 4D Sedan 4 2.2 4 1 1 1
13436.0001494398 20530 Chevrolet Classic Sedan 4D Sedan 4 2.2 4 0 1 1
13161.9428277679 21145 Chevrolet Classic Sedan 4D Sedan 4 2.2 4 1 1 1
14220.0132151888 23069 Chevrolet Classic Sedan 4D Sedan 4 2.2 4 1 1 1
12379.1264733486 31199 Chevrolet Classic Sedan 4D Sedan 4 2.2 4 1 1 1
11581.9050444543 36566 Chevrolet Classic Sedan 4D Sedan 4 2.2 4 0 1 1
14023.9385467303 13776 Chevrolet Cobalt Coupe 2D Coupe 4 2.2 2 0 1 1
12810.9105849645 19461 Chevrolet Cobalt Coupe 2D Coupe 4 2.2 2 1 1 1
13135.9050323183 21796 Chevrolet Cobalt Coupe 2D Coupe 4 2.2 2 1 1 1
13106.9004236608 21910 Chevrolet Cobalt Coupe 2D Coupe 4 2.2 2 0 1 1
12845.1742493148 22382 Chevrolet Cobalt Coupe 2D Coupe 4 2.2 2 1 1 1
12570.1366810142 22479 Chevrolet Cobalt Coupe 2D Coupe 4 2.2 2 0 1 1
12897.9295369167 23200 Chevrolet Cobalt Coupe 2D Coupe 4 2.2 2 1 1 1
11961.6199584128 27394 Chevrolet Cobalt Coupe 2D Coupe 4 2.2 2 1 1 1
12706.9113479764 27521 Chevrolet Cobalt Coupe 2D Coupe 4 2.2 2 1 1 1
12487.0542927355 28492 Chevrolet Cobalt Coupe 2D Coupe 4 2.2 2 0 1 1
15635.7961597274 1169 Chevrolet Cobalt LS Coupe 2D Coupe 4 2.2 2 0 1 1
15747.8039693734 6048 Chevrolet Cobalt LS Coupe 2D Coupe 4 2.2 2 0 1 1
14619.0785627339 15768 Chevrolet Cobalt LS Coupe 2D Coupe 4 2.2 2 1 1 1
14185.0215527411 20374 Chevrolet Cobalt LS Coupe 2D Coupe 4 2.2 2 0 1 1
13699.0357802751 25845 Chevrolet Cobalt LS Coupe 2D Coupe 4 2.2 2 1 1 1
13310.0595947936 26143 Chevrolet Cobalt LS Coupe 2D Coupe 4 2.2 2 1 1 1
13530.0686449196 27249 Chevrolet Cobalt LS Coupe 2D Coupe 4 2.2 2 1 1 1
13019.0711364536 27942 Chevrolet Cobalt LS Coupe 2D Coupe 4 2.2 2 1 1 1
12684.9862266111 29891 Chevrolet Cobalt LS Coupe 2D Coupe 4 2.2 2 1 1 1
12553.0714279172 32844 Chevrolet Cobalt LS Coupe 2D Coupe 4 2.2 2 1 1 1
14997.8843363888 8880 Chevrolet Cobalt LS Sedan 4D Sedan 4 2.2 4 0 1 1
14847.0441508521 12980 Chevrolet Cobalt LS Sedan 4D Sedan 4 2.2 4 0 1 1
15128.9922358386 13828 Chevrolet Cobalt LS Sedan 4D Sedan 4 2.2 4 1 1 1
15000.9927098969 14504 Chevrolet Cobalt LS Sedan 4D Sedan 4 2.2 4 0 1 1
14593.8540952799 18790 Chevrolet Cobalt LS Sedan 4D Sedan 4 2.2 4 0 1 1
14304.7410353626 21128 Chevrolet Cobalt LS Sedan 4D Sedan 4 2.2 4 0 1 1
13688.9456754793 21611 Chevrolet Cobalt LS Sedan 4D Sedan 4 2.2 4 1 1 1
13744.8498521312 23748 Chevrolet Cobalt LS Sedan 4D Sedan 4 2.2 4 0 1 1
13545.0308963393 27431 Chevrolet Cobalt LS Sedan 4D Sedan 4 2.2 4 0 1 1
12741.1902325605 34815 Chevrolet Cobalt LS Sedan 4D Sedan 4 2.2 4 0 1 1
16116.8439161411 865 Chevrolet Cobalt LT Sedan 4D Sedan 4 2.2 4 1 1 1
16428.5789813727 9882 Chevrolet Cobalt LT Sedan 4D Sedan 4 2.2 4 0 1 1
15084.8154042675 14824 Chevrolet Cobalt LT Sedan 4D Sedan 4 2.2 4 1 1 1
15163.1698589644 17158 Chevrolet Cobalt LT Sedan 4D Sedan 4 2.2 4 1 1 1
14897.0405525771 18210 Chevrolet Cobalt LT Sedan 4D Sedan 4 2.2 4 1 1 1
14508.7500852241 18910 Chevrolet Cobalt LT Sedan 4D Sedan 4 2.2 4 0 1 1
14418.1652909085 19818 Chevrolet Cobalt LT Sedan 4D Sedan 4 2.2 4 0 1 1
14191.8822773606 21181 Chevrolet Cobalt LT Sedan 4D Sedan 4 2.2 4 1 1 1
14401.9069288085 21527 Chevrolet Cobalt LT Sedan 4D Sedan 4 2.2 4 0 1 1
14175.8790788752 21627 Chevrolet Cobalt LT Sedan 4D Sedan 4 2.2 4 0 1 1
14429.7896427032 6114 Chevrolet Cobalt Sedan 4D Sedan 4 2.2 4 1 1 1
14696.0289897965 6709 Chevrolet Cobalt Sedan 4D Sedan 4 2.2 4 1 1 1
14582.7691222953 7115 Chevrolet Cobalt Sedan 4D Sedan 4 2.2 4 1 1 1
14194.8236036111 9561 Chevrolet Cobalt Sedan 4D Sedan 4 2.2 4 0 1 1
14072.135231942 15233 Chevrolet Cobalt Sedan 4D Sedan 4 2.2 4 0 1 1
13994.906458446 17270 Chevrolet Cobalt Sedan 4D Sedan 4 2.2 4 0 1 1
13830.2490247204 17594 Chevrolet Cobalt Sedan 4D Sedan 4 2.2 4 0 1 1
13159.8215441932 22740 Chevrolet Cobalt Sedan 4D Sedan 4 2.2 4 1 1 1
12495.9707512187 26204 Chevrolet Cobalt Sedan 4D Sedan 4 2.2 4 0 1 1
12678.853974694 28683 Chevrolet Cobalt Sedan 4D Sedan 4 2.2 4 0 1 1
46732.6060296375 3625 Chevrolet Corvette Conv 2D Convertible 8 6 2 1 1 1
47065.2099128135 5239 Chevrolet Corvette Conv 2D Convertible 8 6 2 1 1 1
44749.6867932853 12115 Chevrolet Corvette Conv 2D Convertible 8 6 2 1 0 1
42773.0283900247 14546 Chevrolet Corvette Conv 2D Convertible 8 6 2 1 1 1
41371.3792727352 20000 Chevrolet Corvette Conv 2D Convertible 8 6 2 1 0 1
39547.5878996389 23826 Chevrolet Corvette Conv 2D Convertible 8 6 2 1 1 1
39691.7274009474 25169 Chevrolet Corvette Conv 2D Convertible 8 6 2 1 1 1
38824.8690859321 25960 Chevrolet Corvette Conv 2D Convertible 8 6 2 1 0 1
36970.8980474434 30502 Chevrolet Corvette Conv 2D Convertible 8 6 2 1 1 1
37288.9367376769 32039 Chevrolet Corvette Conv 2D Convertible 8 6 2 1 1 1
39875.8542553224 7054 Chevrolet Corvette Coupe 2D Coupe 8 6 2 1 0 1
39713.6679219378 8967 Chevrolet Corvette Coupe 2D Coupe 8 6 2 1 1 1
38990.6073346213 9410 Chevrolet Corvette Coupe 2D Coupe 8 6 2 1 1 1
39092.1899183221 10717 Chevrolet Corvette Coupe 2D Coupe 8 6 2 1 1 1
39365.8832384862 11619 Chevrolet Corvette Coupe 2D Coupe 8 6 2 1 1 1
35261.436430686 21350 Chevrolet Corvette Coupe 2D Coupe 8 6 2 1 1 1
35575.417048945 22740 Chevrolet Corvette Coupe 2D Coupe 8 6 2 1 0 1
34297.3053502994 24259 Chevrolet Corvette Coupe 2D Coupe 8 6 2 1 0 1
34739.2149603993 25747 Chevrolet Corvette Coupe 2D Coupe 8 6 2 1 0 1
31186.741462751 34191 Chevrolet Corvette Coupe 2D Coupe 8 6 2 1 0 1
21757.049509258 1853 Chevrolet Impala LS Sedan 4D Sedan 6 3.8 4 1 0 0
19528.1004334074 14115 Chevrolet Impala LS Sedan 4D Sedan 6 3.8 4 1 1 0
19075.6787522022 18198 Chevrolet Impala LS Sedan 4D Sedan 6 3.8 4 1 0 1
19409.7526074867 18795 Chevrolet Impala LS Sedan 4D Sedan 6 3.8 4 1 1 1
18527.2089705632 19874 Chevrolet Impala LS Sedan 4D Sedan 6 3.8 4 1 1 0
18912.9815981283 21512 Chevrolet Impala LS Sedan 4D Sedan 6 3.8 4 1 1 0
17839.8007705925 25453 Chevrolet Impala LS Sedan 4D Sedan 6 3.8 4 1 0 1
17789.3467308115 26980 Chevrolet Impala LS Sedan 4D Sedan 6 3.8 4 1 1 0
17294.181001319 29368 Chevrolet Impala LS Sedan 4D Sedan 6 3.8 4 1 1 0
18083.3962990146 29420 Chevrolet Impala LS Sedan 4D Sedan 6 3.8 4 1 1 1
20021.1952055266 1787 Chevrolet Impala Sedan 4D Sedan 6 3.8 4 1 0 0
18835.1897611439 8211 Chevrolet Impala Sedan 4D Sedan 6 3.8 4 1 0 1
18727.5083766846 14054 Chevrolet Impala Sedan 4D Sedan 6 3.8 4 1 1 1
16805.057392224 19498 Chevrolet Impala Sedan 4D Sedan 6 3.8 4 1 0 0
17154.5764616521 21567 Chevrolet Impala Sedan 4D Sedan 6 3.8 4 1 0 1
16644.0878730491 22383 Chevrolet Impala Sedan 4D Sedan 6 3.8 4 1 1 1
15951.8111690734 26070 Chevrolet Impala Sedan 4D Sedan 6 3.8 4 1 1 1
16508.5906948624 27460 Chevrolet Impala Sedan 4D Sedan 6 3.8 4 1 1 1
15832.5183481771 31202 Chevrolet Impala Sedan 4D Sedan 6 3.8 4 1 1 1
15554.2831291178 33357 Chevrolet Impala Sedan 4D Sedan 6 3.8 4 1 1 1
25948.9625940461 636 Chevrolet Impala SS Sedan 4D Sedan 6 3.8 4 1 0 0
27714.0502451392 5379 Chevrolet Impala SS Sedan 4D Sedan 6 3.8 4 1 1 0
25097.4732491841 14461 Chevrolet Impala SS …