Kyrsti Deane

BCIS 1330 – Data Analytics

Assessment 2: Carvana Data Set

Aggregation By 1 Variable of 5 Metrics:

Entire Data Se t
 Is Bad Buy: Ba d Buy ? Re f. Id Ba d Buy %
Ave ra g e
Ve [Link] e
Avg .Ve h. Avg .Ve h
Odom e te r BCos t
0 64007 87.70% 4.069 71049.260 $ 6,797
1 8976 12.30% 4.941 74714.148 $ 6,259
Gra nd Tota l 72983 100.00% 4.177 71499.996 $ 6,731

Sam ple Data Se t

Ave ra g e Avg .Ve h. Avg .Ve h
Ba d Buy ? Re f. Id Ba d Buy %
Ve [Link] e Odom e te r BCos t
0 6370 87.28% 4.078 71054.740 $ 6,786
1 928 12.72% 4.870 74747.765 $ 6,278
Gra nd Tota l 7298 100.00% 4.178 71524.338 $ 6,721

Both in the original data set and in my sample data set, between 12-13% of
purchases were bad buys, and between 87-88% of purchases were good buys.

Entire Data Se t
Auc tion Auc tion Ave ra g e Avg .Ve h. Avg .Ve h
Re f. Id
Provide r Provide r % Ve [Link] e Odom e te r BCos t
ADESA 14439 19.78% 4.319 72407.715 $ 6,662
MANHEIM 41043 56.24% 4.340 72575.391 $ 6,724
OTHER 17501 23.98% 3.677 68229.098 $ 6,804
 Auction Provider: Gra nd Tota l 72983 100.00% 4.177 71499.996 $ 6,731

Sam ple Data Se t

Auc tion Auc tion Ave ra g e Avg .Ve h. Avg .Ve h
Re f. Id
Provide r Provide r % Ve [Link] e Odom e te r BCos t
ADESA 1416 19.40% 4.300 72208.209 $ 6,595
MANHEIM 4116 56.40% 4.340 72657.431 $ 6,703
OTHER 1766 24.20% 3.704 68335.110 $ 6,864
Gra nd Tota l 7298 100.00% 4.178 71524.338 $ 6,721

Manheim as the auction provider for over 50% of all purchases.

Entire Data Se t Sam ple Data Se t
Ve hic le Ve h. Ave ra g e Avg .Ve h. Avg .Ve h Ve hic le Ve h. Ave ra g e Avg .Ve h. Avg .Ve h
Re f. Id Re f. Id
Ye a r Ye a r % Ve [Link] e Odom e te r BCos t Ye a r Ye a r % Ve [Link] e Odom ete r BCos t
2001 1481 2.03% 8.436 78441.552 $ 4,784 2001 152 2.08% 8.434 79542.928 $4,679
 Vehicle Year: 2002
2003
3405
6227
4.67%
8.53%
7.407
6.422
77189.572
76860.362
$ 5,386
$ 6,043
2002
2003
345
579
4.73%
7.93%
7.397
6.394
76888.896
76188.967
$5,283
$5,937
2004 10207 13.99% 5.433 74781.316 $ 6,476 2004 1054 14.44% 5.448 74845.680 $6,523
2005 15489 21.22% 4.463 72849.913 $ 6,536 2005 1557 21.33% 4.457 73397.598 $6,556
2006 17043 23.35% 3.510 70663.237 $ 6,873 2006 1703 23.34% 3.502 70449.796 $6,853
2007 11423 15.65% 2.661 70021.846 $ 7,326 2007 1164 15.95% 2.671 69742.554 $7,342
2008 6885 9.43% 1.670 61327.513 $ 7,727 2008 662 9.07% 1.692 61608.218 $7,698
2009 822 1.13% 0.999 51715.743 $ 8,285 2009 82 1.12% 1.000 50556.451 $8,323
2010 1 0.00% 0.000 83729.000 $ 9,270 Tota l 7298 100.00% 4.178 71524.338 $6,721
Tota l 72983 100.00% 4.177 71499.996 $ 6,731

Over half of all purchases in the years 2009 and 2010 were of cars produced in
2005-2007. Almost one in four cars purchased were produced in the year 2006.
 Kyrsti Deane
BCIS 1330 – Data Analytics
Assessment 2: Carvana Data Set
 Vehicle Age:
Similarly, over half of purchases between the years 2009 and 2010 were of
cars 3-5 years old, and almost one in four cars purchased were four years old.

Entire Data Se t Sam ple Data Se t

Ve hic le Ve hic le Ave ra g e Avg .Ve h. Avg .Ve h Ve hic le Ve hic le Ave ra g e Avg .Ve h. Avg .Ve h
Re f. Id Re f. Id
Ag e Ag e % Ve [Link] e Odom e te r BCos t Ag e Ag e % Ve [Link] Odom e te r BCos t
0 2 0.00% 0.0 71748.000 $ 8,890 1 286 3.92% 1.0 52423.147 $ 7,832
1 3094 4.24% 1.0 52808.159 $ 7,759 2 841 11.52% 2.0 65965.650 $ 7,509
2 8482 11.62% 2.0 66049.375 $ 7,550 3 1629 22.32% 3.0 69559.045 $ 7,057
3 15902 21.79% 3.0 69742.212 $ 7,043 4 1700 23.29% 4.0 72005.456 $ 6,663
4 17013 23.31% 4.0 71837.491 $ 6,678 5 1294 17.73% 5.0 74875.746 $ 6,579
5 12956 17.75% 5.0 74442.757 $ 6,561 6 823 11.28% 6.0 75724.554 $ 6,325
6 8022 10.99% 6.0 76395.726 $ 6,346 7 436 5.97% 7.0 78135.328 $ 5,675
7 4646 6.37% 7.0 77646.563 $ 5,759 8 223 3.06% 8.0 76964.296 $ 5,218
8 2220 3.04% 8.0 78368.744 $ 5,259 9 66 0.90% 9.0 81105.455 $ 4,760
9 646 0.89% 9.0 79347.014 $ 5,002 Total 7298 100.00% 4.178 71524.338 $ 6,721
Tota l 72983 100.00% 4.177 71499.996 $ 6,731

 Make: Chevrolet, Dodge and Ford were the most popular car “makes” for
Carvana during 2009-2010, easily surpassing 50% of all car makes combined.
Entire Data Se t Sam ple Data Se t
Ve hic le Ave ra g e Avg .Ve h. Avg .Ve h Ve hic le Ave ra g e Avg .Ve h. Avg .Ve h
Ve hic le M a k e Re f. Id Ve hic le M a k e Re f. Id
Make % Ve [Link] e Odom e te r BCos t Ma k e % Ve [Link] e Odom e te r BCos t
AC URA 33 0.05% 6.515 81732.364 $ 9,039 AC URA 5 0.07% 6.400 83080.400 $ 8,858
BUIC K 720 0.99% 5.654 76237.603 $ 6,169 BUIC K 63 0.86% 5.952 76764.714 $ 6,049
C ADILLAC 33 0.05% 5.242 73770.121 $ 10,958 C ADILLAC 3 0.04% 4.667 82383.333 $ 9,498
C HEVROLET 17248 23.63% 3.974 73390.078 $ 6,835 C HEVROLET 1723 23.61% 3.997 73332.198 $ 6,831
C HRYSLER 8844 12.12% 3.653 66814.414 $ 6,507 C HRYSLER 847 11.61% 3.610 67138.143 $ 6,601
DODGE 12912 17.69% 3.752 68261.099 $ 7,047 DODGE 1279 17.53% 3.717 68042.679 $ 7,049
FORD 11305 15.49% 4.753 76748.868 $ 6,403 FORD 1077 14.76% 4.742 77000.513 $ 6,328
GMC 649 0.89% 5.612 79273.265 $ 8,342 GMC 66 0.90% 5.409 79102.015 $ 8,337
HONDA 497 0.68% 5.332 77876.809 $ 8,350 HONDA 53 0.73% 4.943 76768.623 $ 8,577
HUMMER 1 0.00% 3.000 70809.000 $ 11,920 HUMMER 1 0.01% 3.000 70809.000 $ 11,920
HYUNDAI 1811 2.48% 4.440 67288.830 $ 5,969 HYUNDAI 205 2.81% 4.483 67574.556 $ 5,930
INFINITI 42 0.06% 6.262 72021.810 $ 9,844 INFINITI 4 0.05% 6.250 72080.250 $ 11,268
ISUZU 134 0.18% 4.388 69151.127 $ 7,619 ISUZU 11 0.15% 3.818 62805.455 $ 7,892
JEEP 1644 2.25% 4.634 75877.516 $ 7,916 JEEP 157 2.15% 4.643 74946.643 $ 7,985
KIA 2484 3.40% 3.601 62092.515 $ 5,983 KIA 262 3.59% 3.683 62675.363 $ 6,037
LEXUS 31 0.04% 6.032 68875.387 $ 13,023 LINC OLN 15 0.21% 6.200 82130.867 $ 7,747
LINC OLN 97 0.13% 6.608 76937.773 $ 7,693 MAZDA 102 1.40% 5.010 73889.941 $ 7,085
MAZDA 979 1.34% 4.865 74326.644 $ 7,050 MERC URY 95 1.30% 5.147 76470.000 $ 6,213
MERC URY 913 1.25% 5.043 77040.391 $ 6,232 MINI 4 0.05% 4.250 71339.500 $ 8,914
MINI 24 0.03% 5.833 76141.917 $ 8,560 MITSUBISHI 94 1.29% 4.894 70584.223 $ 6,392
MITSUBISHI 1030 1.41% 4.649 70253.750 $ 6,629 NISSAN 223 3.06% 4.700 76730.395 $ 7,916
NISSAN 2085 2.86% 4.803 77077.870 $ 7,796 OLDSMOBILE 34 0.47% 6.000 75001.059 $ 4,493
OLDSMOBILE 243 0.33% 6.350 75777.029 $ 4,464 PLYMOUTH 1 0.01% 9.000 72608.000 $ 3,140
PLYMOUTH 2 0.00% 8.500 58700.000 $ 3,350 PONTIAC 438 6.00% 4.171 72943.505 $ 6,562
PONTIAC 4258 5.83% 4.086 72160.543 $ 6,595 SATURN 241 3.30% 4.900 71379.091 $ 5,482
SATURN 2163 2.96% 4.864 70610.104 $ 5,606 SC ION 16 0.22% 3.500 63356.688 $ 7,876
SCION 129 0.18% 3.853 70675.558 $ 7,461 SUZUKI 152 2.08% 3.204 56089.309 $ 5,340
SUBARU 28 0.04% 3.929 78215.571 $ 8,958 TOYOTA 114 1.56% 4.509 75655.877 $ 8,590
SUZUKI 1328 1.82% 3.294 55819.832 $ 5,366 VOLKSWAGEN 11 0.15% 5.727 69121.364 $ 7,859
TOYOTA 1144 1.57% 4.589 74774.233 $ 8,342 VOLVO 2 0.03% 2.500 84682.500 $ 9,510
TOYOTA SC ION 1 0.00% 4.000 86440.000 $ 5,560 Tota l 7298 100.00% 4.178 71524.338 $ 6,721
VOLKSWAGEN 134 0.18% 4.590 68476.843 $ 7,830
VOLVO 37 0.05% 2.919 75016.054 $ 9,756
Tota l 72983 100.00% 4.177 71499.996 $ 6,731
 Kyrsti Deane
BCIS 1330 – Data Analytics
Assessment 2: Carvana Data Set
 Color:
Entire Data Se t Sam ple Data Se t
Ve hic le Ve hic le Ave ra g e Avg .Ve h. Avg .Ve h Ve hic le Ve hic le Ave ra g e Avg .Ve h. Avg .Veh
Re f. Id Re f. Id
Color Color % Ve [Link] e Odom e te r BCost Color Color % Ve [Link] e Odom e te r BCost
BEIGE 1584 2.17% 4.218 72152.814 $ 6,760 BEIGE 138 1.89% 4.435 73867.891 $ 6,806
BLACK 7627 10.45% 3.808 70644.894 $ 7,145 BLACK 724 9.92% 3.713 69862.653 $ 7,119
BLUE 10347 14.18% 4.037 70427.719 $ 6,719 BLUE 1021 13.99% 4.039 70181.630 $ 6,702
BROWN 436 0.60% 4.284 74885.773 $ 6,886 BROWN 36 0.49% 4.028 74537.778 $ 7,169
GOLD 5231 7.17% 4.622 72396.844 $ 6,375 GOLD 547 7.50% 4.740 73013.020 $ 6,249
GREEN 3194 4.38% 4.762 74147.725 $ 6,487 GREEN 320 4.38% 4.775 73733.272 $ 6,560
GREY 7887 10.81% 4.094 73224.284 $ 7,092 GREY 747 10.24% 4.052 72597.606 $ 7,051
MAROON 2046 2.80% 4.544 73691.627 $ 6,636 MAROON 198 2.71% 4.505 73559.586 $ 6,658
NOT AVAIL 94 0.13% 3.777 66547.468 $ 6,514 NOT AVAIL 8 0.11% 4.625 63214.000 $ 6,191
NULL 8 0.01% 5.125 74913.500 $ 4,891 ORANGE 50 0.69% 3.520 67999.980 $ 6,557
ORANGE 415 0.57% 3.205 62710.506 $ 6,695 OTHER 35 0.48% 3.514 72859.229 $ 7,114
OTHER 242 0.33% 3.773 73245.442 $ 6,845 PURPLE 35 0.48% 4.229 71877.229 $ 6,563
PURPLE 373 0.51% 4.547 71390.346 $ 6,304 RED 651 8.92% 4.127 70251.551 $ 6,844
RED 6257 8.57% 4.160 69541.202 $ 6,717 SILVER 1539 21.09% 4.170 71113.830 $ 6,593
SILVER 14875 20.38% 4.149 71111.371 $ 6,610 WHITE 1231 16.87% 4.233 72407.791 $ 6,644
WHITE 12123 16.61% 4.216 71978.527 $ 6,650 YELLOW 18 0.25% 4.667 70004.556 $ 6,403
YELLOW 244 0.33% 5.279 70740.844 $ 6,299 Tota l 7298 100.00% 4.178 71524.338 $ 6,721
Tota l 72983 100.00% 4.177 71499.996 $ 6,731

One is five cars processed by Carvana from 2009-2010 was silver.

White, blue, black, and gray were also in the top five car colors.

 Nationality:
Entire Data Se t Sam ple Data Se t
Na tiona lity Ave rag e [Link] h. Avg .Ve h Na tiona lity Avera g e Avg .Ve h. [Link] h
Na tionality Re f. Id Na tiona lity Re f. Id
Ve h. % Ve [Link] e Odom e te r BCos t Ve h. % Ve [Link] e Odom e te r BCost
AMERIC AN 61028 83.62% 4.150 72022.587 $ 6,714 AMERIC AN 6039 82.75% 4.154 72118.611 $ 6,701
NULL 5 0.01% 3.000 66243.800 $ 8,512 NULL 1 0.01% 2.000 61596.000 $ 9,955
OTHER 195 0.27% 4.426 70661.010 $ 8,286 OTHER 17 0.23% 5.000 71474.000 $ 8,301
OTHER ASIAN 8033 11.01% 4.082 65250.423 $ 6,213 OTHER ASIAN 852 11.67% 4.110 65105.149 $ 6,151
TOP LINE ASIAN 3722 5.10% 4.808 76470.450 $ 8,039 TOP LINE ASIAN 389 5.33% 4.676 76385.817 $ 8,209
Tota l 72983 100.00% 4.177 71499.996 $ 6,731 Total 7298 100.00% 4.178 71524.338 $ 6,721

Over 80% of processed cars processed these two years were of American nationality.

 Size: Entire Data Se t Sam ple Data Se t

Ve hic le Ave ra g e Avg .Ve h. Avg .Ve h Ve hic le Ave ra g e Avg .Ve h. Avg .Ve h
Ve hic le Siz e Re f. Id Ve hic le Siz e Re f. Id
Siz e % Ve [Link] e Odom e te r BCos t Siz e % Ve [Link] e Odom e te r BCos t
C OMPAC T 7205 9.87% 4.482 69323.387 $ 5,092 C OMPAC T 719 9.85% 4.366 69110.659 $ 5,091
C ROSSOVER 1759 2.41% 3.704 72806.981 $ 8,032 C ROSSOVER 182 2.49% 3.841 72051.220 $ 8,149
LARGE 8850 12.13% 3.702 74869.429 $ 7,081 LARGE 883 12.10% 3.709 74862.280 $ 7,093
LARGE SUV 1433 1.96% 5.741 81014.350 $ 9,676 LARGE SUV 124 1.70% 5.556 80638.137 $ 9,714
LARGE TRUC K 3170 4.34% 4.986 77667.631 $ 8,857 LARGE TRUC K 345 4.73% 4.968 77386.296 $ 8,875
MEDIUM 30785 42.18% 3.812 67519.428 $ 6,207 MEDIUM 3086 42.29% 3.825 68030.366 $ 6,187
MEDIUM SUV 8090 11.08% 4.954 75588.363 $ 7,936 MEDIUM SUV 806 11.04% 4.907 75070.649 $ 7,961
NULL 5 0.01% 3.000 66243.800 $ 8,512 NULL 1 0.01% 2.000 61596.000 $ 9,955
SMALL SUV 2276 3.12% 4.732 77019.370 $ 7,266 SMALL SUV 219 3.00% 4.795 76709.114 $ 7,233
SMALL TRUC K 864 1.18% 5.433 74858.973 $ 6,229 SMALL TRUC K 82 1.12% 5.549 76338.244 $ 6,021
SPEC IALTY 1915 2.62% 3.241 71746.842 $ 9,310 SPEC IALTY 178 2.44% 3.326 71043.753 $ 9,398
SPORTS 777 1.06% 5.305 70313.996 $ 7,414 SPORTS 80 1.10% 5.575 71307.525 $ 7,090
VAN 5854 8.02% 4.436 75746.024 $ 5,974 VAN 593 8.13% 4.506 74975.152 $ 5,967
Tota l 72983 100.00% 4.177 71499.996 $ 6,731 Tota l 7298 100.00% 4.178 71524.338 $ 6,721

Medium sized cars and SUVs were the most popular car size during these years.
 Kyrsti Deane
BCIS 1330 – Data Analytics
Assessment 2: Carvana Data Set
 Vehicle Type:
** Note: Vehicles with three or fewer entries have been omitted.
Sam ple Data Se t Sam ple Data Se t (c ontinue d)
Ve hic le Ave ra g e Avg .Ve h. Avg .Ve h Ve hic le Ave ra g e Avg .Ve h. Avg .Ve h
Ve hic le Ty pe Re f. Id Ve hic le Ty pe Re f. Id
Type % Ve [Link] e Odom e te r BCos t Ty pe % Ve [Link] e Odom e te r BCos t
ALERO 30 0.41% 6.033 75028.200 $ 4,313 MOUNTAINEER 11 0.15% 5.636 69644.636 $ 8,470
AURA 15 0.21% 2.533 73088.733 $ 8,071 MUSTANG 53 0.73% 5.547 70699.981 $ 7,088
AVALANCHE 13 0.18% 6.308 86252.308 $ 10,973 NEON 60 0.83% 5.150 70260.783 $ 4,435
AVENGER 131 1.80% 1.427 55378.626 $ 8,146 NITRO 9 0.12% 2.333 68992.889 $ 9,515
AVEO 63 0.87% 3.492 59560.857 $ 5,123 PACIFICA 119 1.64% 4.084 72434.311 $ 8,254
BEETLE 5 0.07% 7.400 74116.200 $ 6,541 PATRIOT 5 0.07% 2.000 54881.800 $ 8,729
BONNEVILLE 9 0.12% 5.778 68431.444 $ 6,229 PT 338 4.65% 3.802 62873.059 $ 5,540
CALIBER 189 2.60% 2.048 57891.122 $ 7,017 RAINIER 2 0.03% 6.000 73676.500 $ 8,185
CARAVAN 225 3.10% 4.458 73654.787 $ 5,981 RANGER 26 0.36% 5.808 78059.192 $ 5,007
CAVALIER 65 0.90% 5.354 73863.815 $ 4,066 REGAL 5 0.07% 6.800 84536.600 $ 4,994
CENTURY 18 0.25% 6.833 78115.278 $ 4,613 RELAY 8 0.11% 4.375 65863.375 $ 6,784
CHARGER 61 0.84% 2.803 70867.262 $ 9,649 RENDEZVOUS 12 0.17% 5.000 73438.500 $ 7,311
COBALT 151 2.08% 3.338 65913.298 $ 5,771 S 25 0.34% 7.480 79349.680 $ 4,405
COLORADO 13 0.18% 4.308 76286.154 $ 6,225 SABLE 39 0.54% 6.154 77467.051 $ 4,415
COMMANDER 13 0.18% 3.462 74457.692 $ 10,392 Scion 16 0.22% 3.500 63356.688 $ 7,876
COMPASS 8 0.11% 2.375 70847.875 $ 7,756 SEBRING 239 3.29% 2.891 65369.933 $ 6,801
COOPER 4 0.06% 4.250 71339.500 $ 8,914 SILHOUETTE 3 0.04% 5.333 71515.000 $ 5,350
DAKOTA 21 0.29% 5.143 72780.190 $ 6,987 SONOMA 3 0.04% 7.333 70907.333 $ 4,578
DURANGO 171 2.35% 4.871 75581.345 $ 8,500 STRATUS 249 3.43% 4.161 66932.305 $ 5,184
ENVOY 39 0.54% 5.256 79495.385 $ 8,099 SUBURBAN 11 0.15% 6.364 80184.909 $ 9,110
EQUINOX 76 1.05% 3.816 76628.605 $ 8,032 SUNFIRE 13 0.18% 5.769 79854.769 $ 3,856
ESCAPE 71 0.98% 4.324 79881.197 $ 7,056 TAHOE 27 0.37% 5.852 82346.222 $ 9,938
EXPEDITION 58 0.80% 5.603 81563.000 $ 9,485 TAURUS 266 3.66% 4.812 78473.951 $ 4,830
EXPLORER 75 1.03% 5.493 72087.707 $ 7,342 TORRENT 6 0.08% 3.000 87180.833 $ 8,330
F 94 1.29% 5.234 78592.457 $ 8,303 TOWN 97 1.34% 4.247 78706.794 $ 6,291
FIVE 89 1.23% 3.303 77664.225 $ 7,327 TRACKER 5 0.07% 6.600 60511.400 $ 5,127
FOCUS 148 2.04% 4.932 75910.480 $ 4,620 TRAILBLAZER 184 2.53% 5.245 77075.554 $ 7,963
FREESTAR 59 0.81% 4.542 75178.661 $ 5,526 UPLANDER 86 1.18% 3.233 74406.430 $ 6,864
FREESTYLE 37 0.51% 3.838 76431.459 $ 8,017 VENTURE 31 0.43% 6.065 72406.032 $ 4,831
FUSION 68 0.94% 2.750 75769.500 $ 7,865 VIBE 18 0.25% 4.722 77152.389 $ 6,390
G 110 1.51% 3.255 67823.491 $ 7,402 VOYAGER 5 0.07% 6.200 82712.600 $ 4,425
GRAND 309 4.26% 4.392 74514.780 $ 6,735 VUE 37 0.51% 4.432 68093.081 $ 6,673
HHR 65 0.90% 2.923 63748.615 $ 7,220 WINDSTAR 31 0.43% 7.097 76591.097 $ 4,120
IMPALA 466 6.42% 3.249 75450.067 $ 7,239 YUKON 9 0.12% 5.778 82128.000 $ 10,464
ION 127 1.75% 4.378 70364.079 $ 5,268 RAM 113 1.56% 4.735 75158.611 $ 8,991
JETTA 6 0.08% 4.333 64959.000 $ 8,958 SILVERADO 74 1.02% 4.973 79217.243 $ 8,501
L 60 0.83% 5.250 71682.000 $ 6,636 SIERRA 15 0.21% 5.200 77902.600 $ 8,433
LACROSSE 12 0.17% 3.833 78678.250 $ 7,570 Toyota 114 1.57% 4.509 75655.877 $ 8,590
LE 11 0.15% 7.273 73685.727 $ 5,465 Hond a 53 0.73% 4.943 76768.623 $ 8,577
LIBERTY 80 1.10% 5.238 75934.550 $ 7,215 0 24 0.33% 3.417 72228.958 $ 9,811
MAGNUM 45 0.62% 3.356 70830.311 $ 8,688 Mitsub ishi 94 1.29% 4.894 70584.223 $ 6,392
MALIBU 349 4.81% 4.032 72537.946 $ 6,065 Kia 262 3.61% 3.683 62675.363 $ 6,037
MARINER 15 0.21% 4.000 79335.000 $ 8,013 Hyund a i 205 2.82% 4.483 67574.556 $ 5,930
Mazd a 102 1.40% 5.010 73889.941 $ 7,085 Suzuki 152 2.09% 3.204 56089.309 $ 5,340
MILAN 11 0.15% 2.455 72968.818 $ 8,125 Nissa n 223 3.07% 4.700 76730.395 $ 7,916
MONTANA 26 0.36% 5.115 74839.000 $ 5,652 Infiniti 4 0.06% 6.250 72080.250 $ 11,268
MONTE 34 0.47% 4.382 70438.324 $ 6,422 Isuzu 11 0.15% 3.818 62805.455 $ 7,892
MONTEGO 9 0.12% 3.778 76522.333 $ 7,093 HD 4 0.06% 4.500 86318.250 $ 9,680
MONTEREY 5 0.07% 6.000 79631.600 $ 5,410 Acura 5 0.07% 6.400 83080.400 $ 8,858
Total 7262 100.00% 4.172 71512.556 $ 6,716

Chevrolet Impalas & Malibu’s accounted for the highest

percentage of processed cars between 2009-2010.
 Kyrsti Deane
BCIS 1330 – Data Analytics
Assessment 2: Carvana Data Set

 VIN State
Entire Data Se t Sam ple Data Se t
Vin Vin Ave ra g e Avg .Ve h. Avg .Ve h Vin Vin Ave ra g e Avg .Ve h. Avg .Ve h
Re f. Id Re f. Id
Sta te Sta te % Ve [Link] e Odom e te r BCos t Sta te Sta te % Ve [Link] e Odom e te r BCos t
AL 690 0.95% 3.893 74674.330 $ 6,836 AL 71 0.97% 4.099 73582.493 $ 6,808
AR 70 0.10% 5.571 86048.643 $ 5,833 AR 5 0.07% 6.000 87043.400 $ 6,874
AZ 6174 8.46% 4.053 69487.179 $ 6,748 AZ 597 8.18% 4.028 69763.906 $ 6,620
CA 7095 9.72% 4.189 69895.226 $ 6,660 CA 706 9.67% 4.140 68671.266 $ 6,562
CO 4998 6.85% 4.403 73730.166 $ 6,550 CO 499 6.84% 4.361 73843.687 $ 6,527
FL 10447 14.31% 4.616 70563.537 $ 6,634 FL 1098 15.05% 4.648 71069.156 $ 6,676
GA 2450 3.36% 4.203 73891.669 $ 6,704 GA 235 3.22% 4.162 74813.919 $ 6,738
IA 499 0.68% 3.834 71441.190 $ 6,725 IA 51 0.70% 4.020 73509.510 $ 6,920
ID 196 0.27% 4.235 72938.250 $ 6,961 ID 21 0.29% 4.190 71232.381 $ 7,207
IL 458 0.63% 3.819 72397.974 $ 7,054 IL 41 0.56% 3.878 78503.805 $ 7,032
IN 486 0.67% 4.329 71558.667 $ 6,752 IN 48 0.66% 4.000 69914.167 $ 6,987
KY 230 0.32% 3.474 74695.100 $ 7,484 KY 23 0.32% 3.870 79123.217 $ 7,507
LA 349 0.48% 4.381 72165.344 $ 6,761 LA 43 0.59% 4.419 70661.512 $ 6,940
MA 15 0.02% 5.333 73398.667 $ 6,687 MA 1 0.01% 6.000 93267.000 $ 8,470
MD 1158 1.59% 4.301 69057.073 $ 6,502 MD 117 1.60% 4.239 69197.299 $ 6,593
MI 14 0.02% 3.643 69154.857 $ 6,229 MI 2 0.03% 3.000 75407.500 $ 6,975
MN 62 0.08% 3.210 76707.339 $ 7,261 MN 5 0.07% 2.400 70453.400 $ 7,960
MO 758 1.04% 3.978 73689.503 $ 6,873 MO 75 1.03% 4.053 70519.267 $ 6,749
MS 493 0.68% 3.598 72064.533 $ 6,701 MS 48 0.66% 3.625 71791.521 $ 6,608
NC 7042 9.65% 4.238 72927.988 $ 6,676 NC 715 9.80% 4.210 72788.620 $ 6,674
NE 26 0.04% 3.000 72380.731 $ 6,744 NE 1 0.01% 3.000 68716.000 $ 5,900
NH 97 0.13% 1.526 50413.351 $ 8,609 NH 9 0.12% 1.778 50320.889 $ 8,904
NJ 317 0.43% 4.025 71025.413 $ 6,560 NJ 28 0.38% 3.607 68074.821 $ 6,818
NM 239 0.33% 4.280 70862.987 $ 6,241 NM 29 0.40% 4.586 68586.517 $ 5,868
NV 562 0.77% 4.786 72467.004 $ 6,286 NV 55 0.75% 5.109 72171.345 $ 6,250
NY 6 0.01% 2.000 77589.333 $ 8,097 OH 73 1.00% 4.041 76423.740 $ 7,450
OH 795 1.09% 3.835 75221.752 $ 7,456 OK 352 4.82% 2.477 58219.727 $ 7,259
OK 3594 4.92% 2.390 57508.944 $ 7,203 OR 20 0.27% 3.600 61353.250 $ 6,951
OR 211 0.29% 3.848 67103.194 $ 6,902 PA 69 0.95% 4.754 71562.130 $ 6,531
PA 847 1.16% 4.649 72082.364 $ 6,576 SC 455 6.23% 4.310 75227.505 $ 6,643
SC 4280 5.86% 4.398 75825.016 $ 6,621 TN 178 2.44% 4.247 74093.539 $ 6,904
TN 1763 2.42% 4.187 72629.060 $ 6,610 TX 1339 18.35% 4.162 73385.973 $ 6,799
TX 13597 18.63% 4.198 73481.731 $ 6,810 UT 83 1.14% 4.289 75007.819 $ 6,924
UT 875 1.20% 4.074 74801.037 $ 6,834 VA 166 2.27% 4.518 73701.518 $ 6,434
VA 1662 2.28% 4.362 71922.905 $ 6,727 WA 20 0.27% 3.900 67850.250 $ 6,450
WA 136 0.19% 4.022 69998.368 $ 6,762 WV 20 0.27% 4.050 73030.450 $ 7,126
WV 292 0.40% 4.586 74612.774 $ 7,017 Tota l 7298 100.00% 4.178 71524.338 $ 6,721
Tota l 72983 100.00% 4.177 71499.996 $ 6,731

From 2009-2010 Texas and Florida were the most popular VIN states,
accounting for nearly one-third of all entries.
 Kyrsti Deane
BCIS 1330 – Data Analytics
Assessment 2: Carvana Data Set
Ve hic le M ak e Ave ra ge Avg .Ve h. [Link] h
Ve hic le M ak e Re f. Id
& M ode l % Ve [Link] e Odom e te r BCos t
BUICK 58 0.81% 5.914 76977.621 $ 5,977
C ENTURY 18 0.25% 6.833 78115.278 $ 4,613
LAC ROSSE 12 0.17% 3.833 78678.250 $ 7,570
LE 11 0.15% 7.273 73685.727 $ 5,465
REGAL 5 0.07% 6.800 84536.600 $ 4,994
RENDEZVOUS 12 0.17% 5.000 73438.500 $ 7,311
CHEVROLET 1718 24.10% 3.994 73316.890 $ 6,824
AVALANC HE 13 0.18% 6.308 86252.308 $ 10,973
AVEO 63 0.88% 3.492 59560.857 $ 5,123
C AVALIER
C OBALT
65
151
0.91%
2.12%
5.354
3.338
73863.815
65913.298
$ 4,066
$ 5,771 Aggregation of 2 Variables:
C OLORADO 13 0.18% 4.308 76286.154 $ 6,225
EQUINOX 76 1.07% 3.816 76628.605 $ 8,032
HHR 65 0.91% 2.923 63748.615 $ 7,220
IMPALA 466 6.54% 3.249 75450.067 $ 7,239
MALIBU 349 4.90% 4.032 72537.946 $ 6,065
MONTE
S
34
5
0.48%
0.07%
4.382
8.200
70438.324
81151.800
$ 6,422
$ 4,894
Chevrolet was the most popular car
SILVERADO
SUBURBAN
74
11
1.04%
0.15%
4.973
6.364
79217.243
80184.909
$ 8,501
$ 9,110
make during the years 2009-2010,
TAHOE
TRAC KER
27
5
0.38%
0.07%
5.852
6.600
82346.222
60511.400
$ 9,938
$ 5,127 accounting for about 24.10% of all
TRAILBLAZER 184 2.58% 5.245 77075.554 $ 7,963
UPLANDER
VENTURE
86
31
1.21%
0.43%
3.233
6.065
74406.430
72406.032
$ 6,864
$ 4,831
vehicles. The most frequently sold
CHRYSLER
L
821
24
11.52%
0.34%
3.609
2.833
66994.055
66087.375
$ 6,505
$ 9,793
models were the Chevy Impala and the
M
PAC IFIC A
3
119
0.04%
1.67%
7.000
4.084
73349.667
72434.311
$ 5,942
$ 8,254 Chevy Malibu, making up over 10% of
PT 338 4.74% 3.802 62873.059 $ 5,540
SEBRING
TOWN
239
93
3.35%
1.30%
2.891
4.097
65369.933
78367.946
$ 6,801
$ 6,299
all transactions.
VOYAGER 5 0.07% 6.200 82712.600 $ 4,425
DODGE 1273 17.86% 3.717 68071.054 $ 7,050
AVENGER 131 1.84% 1.427 55378.626 $ 8,146
C ALIBER 189 2.65% 2.048 57891.122 $ 7,017
C ARAVAN
C HARGER
225
61
3.16%
0.86%
4.458
2.803
73654.787
70867.262
$ 5,981
$ 9,649 Dodge also comprised a significant
DAKOTA 21 0.29% 5.143 72780.190 $ 6,987
DURANGO
MAGNUM
171
45
2.40%
0.63%
4.871
3.356
75581.345
70830.311
$ 8,500
$ 8,688
portion of the data set (17.36%).
NEON 59 0.83% 5.085 70221.000 $ 4,457
NITRO 9 0.13% 2.333 68992.889 $ 9,515
RAM 113 1.59% 4.735 75158.611 $ 8,991
STRATUS 249 3.49% 4.161 66932.305 $ 5,184
FORD 981 13.76% 4.699 76856.807 $ 6,130
ESC APE 71 1.00% 4.324 79881.197 $ 7,056 Ford was a close third, comprising
EXPEDITION 58 0.81% 5.603 81563.000 $ 9,485
EXPLORER
FIVE
75
89
1.05%
1.25%
5.493
3.303
72087.707
77664.225
$ 7,342
$ 7,327
about 13.76% of all transactions.
FOC US 148 2.08% 4.932 75910.480 $ 4,620
FREESTAR 59 0.83% 4.542 75178.661 $ 5,526
FREESTYLE 37 0.52% 3.838 76431.459 $ 8,017
FUSION 68 0.95% 2.750 75769.500 $ 7,865
MUSTANG 53 0.74% 5.547 70699.981 $ 7,088
RANGER 26 0.36% 5.808 78059.192 $ 5,007
TAURUS 266 3.73% 4.812 78473.951 $ 4,830
WINDSTAR 31 0.43% 7.097 76591.097 $ 4,120
GM C 63 0.88% 5.317 79492.238 $ 8,516
HONDA 53 0.74% 4.943 76768.623 $ 8,577
HYUNDAI 205 2.88% 4.483 67574.556 $ 5,930
INFINITI 4 0.06% 6.250 72080.250 $ 11,268
ISUZU 11 0.15% 3.818 62805.455 $ 7,892
JEEP 156 2.19% 4.641 74951.391 $ 7,975
KIA 262 3.68% 3.683 62675.363 $ 6,037
LINCOLN 6 0.08% 7.167 83932.667 $ 6,004

Aggregation of 2 Variables
M AZDA 102 1.43% 5.010 73889.941 $ 7,085
M ERCURY 95 1.33% 5.147 76470.000 $ 6,213
M ITSUBISHI 94 1.32% 4.894 70584.223 $ 6,392

are included below:

NISSAN 223 3.13% 4.700 76730.395 $ 7,916
OLDSM OBILE 30 0.42% 6.033 75028.200 $ 4,313
PLYM OUTH 1 0.01% 9.000 72608.000 $ 3,140
NEON 1 0.01% 9.000 72608.000 $ 3,140
PONTIAC 436 6.12% 4.154 72915.078 $ 6,567
SATURN 241 3.38% 4.900 71379.091 $ 5,482
SCION 16 0.22% 3.500 63356.688 $ 7,876
SUZUKI 152 2.13% 3.204 56089.309 $ 5,340
TOYOTA 114 1.60% 4.509 75655.877 $ 8,590
VOLKSWAGEN 11 0.15% 5.727 69121.364 $ 7,859
VOLVO 2 0.03% 2.500 84682.500 $ 9,510
S 2 0.03% 2.500 84682.500 $ 9,510
Tota l 7128 100.00% 4.158 71402.869 $ 6,680
 Kyrsti Deane
BCIS 1330 – Data Analytics
Assessment 2: Carvana Data Set
Make and Vehicle Year:
M ak e 2001 2002 2003 2004 2005 2006 2007 2008 2009 Grand Tota l
AC URA $ 6,305 $ 8,607 $ 12,165 $ 8,858
BUIC K $ 4,941 $ 4,851 $ 5,025 $ 6,807 $ 6,990 $ 7,894 $ 7,965 $ 6,049
C ADILLAC $ 9,083 $ 10,330 $ 9,498
CHEVROLET $ 5,241 $ 6,177 $ 6,726 $ 6,559 $ 6,411 $ 6,907 $ 7,193 $ 7,674 $ 8,487 $ 6,831
C HRYSLER $ 4,367 $ 4,566 $ 4,931 $ 6,116 $ 6,390 $ 6,597 $ 7,108 $ 7,320 $ 7,947 $ 6,601
DODGE $ 4,355 $ 5,200 $ 5,794 $ 6,589 $ 6,804 $ 7,033 $ 7,877 $ 7,745 $ 9,059 $ 7,049
FORD $ 4,496 $ 4,911 $ 5,470 $ 6,763 $ 6,350 $ 6,404 $ 7,226 $ 8,384 $ 8,892 $ 6,328
GMC $ 5,000 $ 7,021 $ 8,322 $ 8,753 $ 8,155 $ 9,063 $ 9,793 $ 8,337
HONDA $ 5,408 $ 6,340 $ 8,215 $ 8,490 $ 8,906 $ 9,156 $ 9,271 $ 9,185 $ 10,720 $ 8,577
HUMMER $ 11,920 $ 11,920
HYUNDAI $ 3,763 $ 4,661 $ 4,685 $ 5,621 $ 5,710 $ 6,604 $ 6,773 $ 6,941 $ 5,930
INFINITI $ 6,715 $ 9,128 $ 20,100 $ 11,268
ISUZU $ 7,740 $ 7,686 $ 7,900 $ 8,985 $ 7,892
JEEP $ 5,037 $ 6,792 $ 6,954 $ 7,327 $ 8,378 $ 9,020 $ 8,389 $ 8,626 $ 7,985
KIA $ 4,713 $ 2,765 $ 5,853 $ 4,880 $ 5,503 $ 6,111 $ 6,702 $ 6,874 $ 6,989 $ 6,037
LINC OLN $ 5,610 $ 5,150 $ 10,272 $ 6,998 $ 10,065 $ 10,103 $ 7,747
MAZDA $ 5,750 $ 4,415 $ 6,727 $ 6,969 $ 7,086 $ 7,523 $ 8,415 $ 8,233 $ 7,085
MERCURY $ 3,872 $ 4,357 $ 5,765 $ 5,449 $ 6,766 $ 7,916 $ 7,956 $ 8,112 $ 6,213
MINI $ 6,240 $ 9,595 $ 10,145 $ 9,675 $ 8,914
MITSUBISHI $ 5,295 $ 4,658 $ 5,253 $ 6,301 $ 6,217 $ 6,857 $ 7,538 $ 8,651 $ 8,860 $ 6,392
NISSAN $ 5,383 $ 6,627 $ 7,227 $ 8,121 $ 7,813 $ 8,093 $ 9,542 $ 8,742 $ 7,916
OLDSMOBILE $ 4,773 $ 4,435 $ 4,529 $ 4,493
PLYMOUTH $ 3,140 $ 3,140
PONTIAC $ 3,961 $ 4,675 $ 4,721 $ 5,962 $ 6,154 $ 7,057 $ 7,523 $ 7,988 $ 6,562
SATURN $ 3,789 $ 4,015 $ 4,884 $ 4,988 $ 5,732 $ 5,787 $ 6,830 $ 7,922 $ 5,482
SC ION $ 8,355 $ 7,971 $ 7,456 $ 7,800 $ 8,425 $ 7,876
SUZUKI $ 5,533 $ 4,377 $ 4,699 $ 5,269 $ 5,379 $ 6,283 $ 5,340
TOYOTA $ 7,124 $ 7,596 $ 7,338 $ 8,103 $ 7,900 $ 8,272 $ 9,951 $ 11,313 $ 9,485 $ 8,590
VOLKSWAGEN $ 6,840 $ 6,583 $ 6,115 $ 8,898 $ 8,900 $ 9,250 $ 7,859
VOLVO $ 8,970 $ 10,050 $ 9,510
Gra nd Tota l $ 4,679 $ 5,283 $ 5,937 $ 6,523 $ 6,556 $ 6,853 $ 7,342 $ 7,698 $ 8,323 $ 6,721

Make & VIN State:

Make AL AR AZ CA CO FL GA IA ID IL IN KY LA MA MD MI MN MO MS NC NE NH NJ NM NV OH OK OR PA SC TN TX UT VA WA WV Tota l
AC URA 2 1 1 1 5
BUIC K 1 2 7 13 2 2 1 2 2 6 5 1 3 3 3 10 63
C ADILLAC 1 1 1 3
C HEVROLET 18 156 180 109 228 55 8 8 18 15 7 8 32 1 3 17 15 144 13 13 12 26 46 9 18 115 53 326 18 41 3 8 1723
C HRYSLER 10 52 89 51 132 32 4 2 4 3 1 2 7 6 2 75 1 2 4 9 95 2 16 49 13 157 5 19 3 847
DODGE 9 100 93 77 180 35 7 2 6 9 5 10 26 1 13 14 131 1 3 6 7 11 163 2 8 64 34 219 12 24 3 4 1279
FORD 13 2 81 136 90 144 30 10 4 3 4 3 6 8 12 9 95 2 4 14 8 22 2 8 61 24 233 18 26 3 2 1077
GMC 1 4 6 4 9 2 1 1 1 11 6 1 18 1 66
HONDA 1 2 4 9 6 1 2 1 7 4 1 3 9 1 2 53
HUMMER 1 1
HYUNDAI 1 24 17 13 65 2 1 1 2 1 3 4 21 2 1 2 1 10 4 19 2 7 2 205
INFINITI 1 1 1 1 4
ISUZU 1 1 1 2 1 1 1 3 11
JEEP 2 10 13 14 26 6 2 1 3 5 1 2 17 1 1 2 1 14 3 26 3 3 1 157
KIA 4 45 33 15 39 10 2 1 2 2 29 1 3 2 1 1 17 4 42 6 2 1 262
LINC OLN 1 2 3 1 1 2 1 4 15
MAZDA 8 7 7 30 1 1 2 15 1 1 1 5 2 21 102
MERC URY 3 1 10 6 7 14 1 1 1 2 2 10 2 1 3 4 4 20 3 95
MINI 1 2 1 4
MITSUBISHI 8 15 8 17 2 1 1 5 1 8 1 2 5 2 15 2 1 94
NISSAN 3 1 19 22 20 25 8 2 1 1 1 1 2 6 2 2 26 1 5 2 1 9 8 41 5 5 1 3 223
OLDSMOBILE 4 4 1 4 1 2 1 1 1 2 1 2 1 1 5 3 34
PLYMOUTH 1 1
PONTIAC 4 30 42 32
50 22 8 5 3 1 2 6 1 9 3 47 2 6 10 3 6 43 10 75 5 12 1 438
SATURN 20 17 19
55 9 4 1 2 3 4 1 1 15 2 2 2 2 23 5 39 6 7 1 1 241
SC ION 16 1 4 2 1 1 16
SUZUKI 2 11 14 6
18 5 1 1 1 1 1 36 3 1 13 5 29 1 3 152
TOYOTA 1 7 6 11
28 4 1 1 1 1 2 10 1 1 2 2 1 1 8 20 4 1 114
VOLKSWAGEN 2 21 1 1 3 1 11
VOLVO 1 1 2
Tota l 71 5 597 706 499 1098 235 51 21 41 48 23 43 1 117 2 5 75 48 715 1 9 28 29 55 73 352 20 69 455 178 1339 83 166 20 20 7298
 Kyrsti Deane
BCIS 1330 – Data Analytics
Assessment 2: Carvana Data Set
Make & Vehicle Type: Make
ACURA
CAR
5
SUV TRUCK VAN Tota l
5
BUICK 49 14 63

There ARE makes that are classified as the CADILLAC

CHEVROLET
2
1194
1
303 109 117
3
1723

wrong vehicle type.

CHRYSLER 630 119 98 847
DODGE 737 183 134 225 1279
FORD 621 246 120 90 1077
EDGE 2 2
ESCAPE 71 71
There ARE also vehicles that are EXPEDITION
EXPLORER
58 58
75 75
categorized as more than one vehicle type. F
FIVE 89
94 94
89
FOCUS 148 148
FREESTAR 59 59
FREESTYLE 37 37
FUSION 68 68
MUSTANG 53 53
RANGER 26 26
TAURUS 263 3 266
WINDSTAR 31 31

Entire Data Se t Sam ple Data Se t

 Auction Provider: Auc tion

Provide r
0 1 Total
Auc tion
Provide r
0 1 Total

ADESA 84.24% 15.76% 100.00% ADESA 83.05% 16.95% 100.00%

MANHEIM 88.34% 11.66% 100.00% MANHEIM 88.41% 11.59% 100.00%
OTHER 88.55% 11.45% 100.00% OTHER 88.05% 11.95% 100.00%
Tota l 87.25% 12.75% 100.00% Tota l 87.28% 12.72% 100.00%

More “bad buys” (as a percentage of the provider’s totals)

were associated with ADESA than any other auction provider.
Entire Data Se t Sam ple Data Se t

 Vehicle Year: Vehic le

Yea r
0 1 Tota l
Vehic le
Yea r
0 1 Tota l

2001 70.47% 29.53% 100.00% 2001 76.97% 23.03% 100.00%

2002 74.98% 25.02% 100.00% 2002 74.20% 25.80% 100.00%
2003 79.82% 20.18% 100.00% 2003 80.31% 19.69% 100.00%
2004 83.66% 16.34% 100.00% 2004 83.87% 16.13% 100.00%
Predictably, higher percentages of older 2005
2006
86.38%
90.13%
13.62%
9.87%
100.00%
100.00%
2005
2006
86.71%
89.84%
13.29%
10.16%
100.00%
100.00%
vehicles processed were “bad buys”. 2007
2008
92.15%
94.27%
7.85%
5.73%
100.00%
100.00%
2007
2008
91.67%
93.96%
8.33%
6.04%
100.00%
100.00%
(meaning a higher percentage of all vehicles 2009 96.33% 3.67% 100.00% 2009 96.34% 3.66% 100.00%
2010 100.00% 0.00% 100.00% Total 87.28% 12.72% 100.00%
in 2001 than in 2002 and so forth) Total 87.25% 12.75% 100.00%

Entire Data Se t Sam ple Data Se t

 Vehicle Age: Ve hicle
Ag e
0 1 Tota l
Ve hic le
Ag e
0 1 Tota l
0 100.00% 0.00% 100.00% 1 96.15% 3.85% 100.00%
1 96.04% 3.96% 100.00% 2 93.22% 6.78% 100.00%
2 93.23% 6.77% 100.00% 3 90.79% 9.21% 100.00%
3 91.55% 8.45% 100.00% 4 88.53% 11.47% 100.00%
4 88.33% 11.67% 100.00% 5 85.16% 14.84% 100.00%
5 85.03% 14.97% 100.00% 6 81.41% 18.59% 100.00%
6 80.81% 19.19% 100.00% 7 77.75% 22.25% 100.00%
7 77.70% 22.30% 100.00% 8 77.58% 22.42% 100.00%
8 72.44% 27.56% 100.00% 9 65.15% 34.85% 100.00%
9 67.40% 32.60% 100.00% Tota l 87.28% 12.72% 100.00%
Tota l 87.25% 12.75% 100.00%

Similarly, as vehicle age increases the chance or likelihood of a “bad buy”

for that vehicle’s age increases.
 Kyrsti Deane
BCIS 1330 – Data Analytics
Assessment 2: Carvana Data Set

 Vehicle Make:
o Chevrolet: 10.07% of 1723 cars = 179 “bad buys”
o Dodge: 10.01% of 1279 cars = 128 “bad buys”
o Ford: 15.97% of 1077 cars = 172 “bad buys”
o Pontiac: 13.24% of 438 cars = 58 “bad buys”

Entire Data Se t Sam ple Data Se t

Ve hic le Ve hic le
0 1 Tota l 0 1 Tota l
Make Make
AC URA 68.57% 31.43% 100.00% AC URA 60.00% 40.00% 100.00%
BUIC K 83.96% 16.04% 100.00% BUIC K 87.30% 12.70% 100.00%
C ADILLAC 83.74% 16.26% 100.00% C ADILLAC 100.00% 0.00% 100.00%
C HEVROLET 89.93% 10.07% 100.00% C HEVROLET 89.61% 10.39% 100.00%
C HRYSLER 86.93% 13.07% 100.00% C HRYSLER 86.78% 13.22% 100.00%
DODGE 89.18% 10.82% 100.00% DODGE 89.99% 10.01% 100.00%
FORD 83.92% 16.08% 100.00% FORD 84.03% 15.97% 100.00%
GMC 87.34% 12.66% 100.00% GMC 86.36% 13.64% 100.00%
HONDA 87.41% 12.59% 100.00% HONDA 88.68% 11.32% 100.00%
HUMMER 100.00% 0.00% 100.00% HUMMER 100.00% 0.00% 100.00%
HYUNDAI 86.27% 13.73% 100.00% HYUNDAI 88.78% 11.22% 100.00%
INFINITI 66.00% 34.00% 100.00% INFINITI 50.00% 50.00% 100.00%
ISUZU 92.08% 7.92% 100.00% ISUZU 81.82% 18.18% 100.00%
JEEP 83.61% 16.39% 100.00% JEEP 82.80% 17.20% 100.00%
KIA 87.74% 12.26% 100.00% KIA 88.55% 11.45% 100.00%
LEXUS 67.49% 32.51% 100.00% LINC OLN 66.67% 33.33% 100.00%
LINC OLN 69.46% 30.54% 100.00% MAZDA 82.35% 17.65% 100.00%
MAZDA 84.54% 15.46% 100.00% MERC URY 76.84% 23.16% 100.00%
MERC URY 80.96% 19.04% 100.00% MINI 75.00% 25.00% 100.00%
MINI 59.76% 40.24% 100.00% MITSUBISHI 82.98% 17.02% 100.00%
MITSUBISHI 87.69% 12.31% 100.00% NISSAN 88.34% 11.66% 100.00%
NISSAN 84.32% 15.68% 100.00% OLDSMOBILE 88.24% 11.76% 100.00%
OLDSMOBILE 78.52% 21.48% 100.00% PLYMOUTH 0.00% 100.00% 100.00%
PLYMOUTH 81.96% 18.04% 100.00% PONTIAC 86.76% 13.24% 100.00%
PONTIAC 88.31% 11.69% 100.00% SATURN 84.65% 15.35% 100.00%
SATURN 84.90% 15.10% 100.00% SC ION 93.75% 6.25% 100.00%
SC ION 90.69% 9.31% 100.00% SUZUKI 86.18% 13.82% 100.00%
SUBARU 81.35% 18.65% 100.00% TOYOTA 88.60% 11.40% 100.00%
SUZUKI 85.33% 14.67% 100.00% VOLKSWAGEN 54.55% 45.45% 100.00%
TOYOTA 89.68% 10.32% 100.00% VOLVO 100.00% 0.00% 100.00%
TOYOTA SC ION 100.00% 0.00% 100.00% Tota l 87.28% 12.72% 100.00%
VOLKSWAGEN 84.27% 15.73% 100.00%
VOLVO 100.00% 0.00% 100.00%
Tota l 87.25% 12.75% 100.00%

 Vehicle Color:
Ve hic le Ve hic le
0 1 Tota l 0 1 Tota l
Color Color
BEIGE 86.71% 13.29% 100.00% BEIGE 85.51% 14.49% 100.00%
BLAC K 88.58% 11.42% 100.00% BLAC K 88.95% 11.05% 100.00%
BLUE 87.90% 12.10% 100.00% BLUE 87.95% 12.05% 100.00%
BROWN 85.03% 14.97% 100.00% BROWN 91.67% 8.33% 100.00%
GOLD 85.34% 14.66% 100.00% GOLD 83.91% 16.09% 100.00%
GREEN 86.54% 13.46% 100.00% GREEN 87.19% 12.81% 100.00%
 ORANGE 90.33% 9.67% 100.00% OTHER 85.71% 14.29% 100.00%
OTHER 87.77% 12.23% 100.00% PURPLE 94.29% 5.71% 100.00%
PURPLE 83.44% 16.56% 100.00% RED 87.56% 12.44% 100.00%
RED 86.80% 13.20% 100.00% SILVER 85.96% 14.04%
Kyrsti Deane
100.00%
SILVER 87.06% 12.94% 100.00% WHITE 88.30% BCIS 1330 –100.00%
11.70% Data Analytics
WHITE 87.21% 12.79% 100.00% YELLOW 72.22% 27.78% 100.00%
Tota l
Assessment
87.28%
2: Carvana
12.72% 100.00%
Data Set
YELLOW 85.63% 14.37% 100.00%
Tota l 87.25% 12.75% 100.00%

Of the cars with color data available in our sample data set,
over 25% yellow cars were “bad buys”, while over 16% of gold cars were “bad buys”.

Entire Data Se t Sam ple Data Se t

Na tionality 0 1 Total Na tionality 0 1 Total
 Nationality: AMERIC AN
NULL
87.42%
100.00%
12.58%
0.00%
100.00%
100.00%
AMERIC AN
NULL
87.38%
100.00%
12.62%
0.00%
100.00%
100.00%
OTHER 82.68% 17.32% 100.00% OTHER 64.71% 35.29% 100.00%
OTHER ASIAN 86.44% 13.56% 100.00% OTHER ASIAN 86.50% 13.50% 100.00%
TOP LINE ASIAN 86.39% 13.61% 100.00% TOP LINE ASIAN 88.43% 11.57% 100.00%
Total 87.25% 12.75% 100.00% Total 87.28% 12.72% 100.00%

“Other” nationalities accounted for most “bad buys” in both the original and sample data sets.
Knowing exactly what “other” is defined as or having additional categories such as
“European” would be beneficial when making observations and inferences about this data.

Entire Data Se t Sam ple Data Se t

 Vehicle Size: Vehic le Siz e 0 1 Total Ve hicle Siz e 0 1 Tota l
C OMPAC T 83.72% 16.28% 100.00% COMPAC T 83.73% 16.27% 100.00%
C ROSSOVER 89.10% 10.90% 100.00% CROSSOVER 84.07% 15.93% 100.00%
Sports vehicles had the highest LARGE 90.81% 9.19% 100.00% LARGE 89.69% 10.31% 100.00%
LARGE SUV 83.00% 17.00% 100.00% LARGE SUV 84.68% 15.32% 100.00%
percentage of “bad buys” per LARGE TRUCK 87.90% 12.10% 100.00% LARGE TRUC K 86.96% 13.04% 100.00%
capita, followed by compact MEDIUM
MEDIUM SUV
88.05%
84.35%
11.95%
15.65%
100.00%
100.00%
MEDIUM
MEDIUM SUV
88.79%
84.00%
11.21%
16.00%
100.00%
100.00%
cars and large SUVs. NULL
SMALL SUV
100.00%
86.05%
0.00%
13.95%
100.00%
100.00%
NULL
SMALL SUV
100.00%
86.76%
0.00%
13.24%
100.00%
100.00%
SMALL TRUCK 84.82% 15.18% 100.00% SMALL TRUC K 87.80% 12.20% 100.00%
SPEC IALTY 90.20% 9.80% 100.00% SPEC IALTY 87.64% 12.36% 100.00%
SPORTS 81.62% 18.38% 100.00% SPORTS 80.00% 20.00% 100.00%
VAN 86.89% 13.11% 100.00% VAN 87.35% 12.65% 100.00%
Total 87.25% 12.75% 100.00% Tota l 87.28% 12.72% 100.00%

 Vehicle Type: Sam ple Data Se t

Ve h. Ty pe 0 1 Tota l
C AR 88.03% 11.97% 100.00%
SUV 84.52% 15.48% 100.00%
TRUC K 87.12% 12.88% 100.00%
VAN 87.35% 12.65% 100.00%
Tota l 87.28% 12.72% 100.00%
 Kyrsti Deane
BCIS 1330 – Data Analytics
Assessment 2: Carvana Data Set
Of all vehicle types, the highest
percent of “bad buys” (relative to
their designated category) was SUVs.

 VIN State:
The states with the highest percentage of “bad buys” (per capita) included:
New Hampshire, Indiana, Arizona, and Nevada.

Entire Data Se t Sam ple Data Se t

VIN ST 0 1 Tota l VIN ST 0 1 Tota l
AL 88.74% 11.26% 100.00% AL 91.55% 8.45% 100.00%
AR 77.10% 22.90% 100.00% AR 80.00% 20.00% 100.00%
AZ 86.90% 13.10% 100.00% AZ 89.78% 10.22% 100.00%
CA 85.06% 14.94% 100.00% CA 84.70% 15.30% 100.00%
CO 87.73% 12.27% 100.00% CO 87.58% 12.42% 100.00%
FL 88.59% 11.41% 100.00% FL 88.16% 11.84% 100.00%
GA 87.93% 12.07% 100.00% GA 89.36% 10.64% 100.00%
IA 86.65% 13.35% 100.00% IA 82.35% 17.65% 100.00%
ID 91.11% 8.89% 100.00% ID 95.24% 4.76% 100.00%
IL 87.22% 12.78% 100.00% IL 92.68% 7.32% 100.00%
IN 84.80% 15.20% 100.00% IN 79.17% 20.83% 100.00%
KY 93.50% 6.50% 100.00% KY 91.30% 8.70% 100.00%
LA 84.23% 15.77% 100.00% LA 81.40% 18.60% 100.00%
MA 86.68% 13.32% 100.00% MA 100.00% 0.00% 100.00%
MD 85.89% 14.11% 100.00% MD 87.18% 12.82% 100.00%
MI 92.85% 7.15% 100.00% MI 100.00% 0.00% 100.00%
MN 96.74% 3.26% 100.00% MN 100.00% 0.00% 100.00%
MO 89.11% 10.89% 100.00% MO 89.33% 10.67% 100.00%
MS 90.62% 9.38% 100.00% MS 95.83% 4.17% 100.00%
NC 87.58% 12.42% 100.00% NC 88.11% 11.89% 100.00%
NE 96.15% 3.85% 100.00% NE 100.00% 0.00% 100.00%
NH 90.72% 9.28% 100.00% NH 77.78% 22.22% 100.00%
NJ 87.39% 12.61% 100.00% NJ 89.29% 10.71% 100.00%
NM 87.82% 12.18% 100.00% NM 93.10% 6.90% 100.00%
NV 83.85% 16.15% 100.00% NV 80.00% 20.00% 100.00%
NY 100.00% 0.00% 100.00% OH 86.30% 13.70% 100.00%
OH 89.62% 10.38% 100.00% OK 91.76% 8.24% 100.00%
OK 90.63% 9.37% 100.00% OR 100.00% 0.00% 100.00%
OR 92.45% 7.55% 100.00% PA 88.41% 11.59% 100.00%
PA 81.84% 18.16% 100.00% SC 85.93% 14.07% 100.00%
SC 87.00% 13.00% 100.00% TN 92.13% 7.87% 100.00%
TN 87.30% 12.70% 100.00% TX 84.76% 15.24% 100.00%
TX 85.97% 14.03% 100.00% UT 84.34% 15.66% 100.00%
UT 89.82% 10.18% 100.00% VA 81.93% 18.07% 100.00%
VA 86.38% 13.62% 100.00% WA 100.00% 0.00% 100.00%
WA 94.07% 5.93% 100.00% WV 90.00% 10.00% 100.00%
WV 89.60% 10.40% 100.00% Tota l 87.28% 12.72% 100.00%
Tota l 87.25% 12.75% 100.00%