Project 2 - 1 of 3
ZIXIAN LIANG
2024-03-01
Introduction
The objective of this task is to choose and clean up three datasets stored in CSV format. Utilizing the tidyr and dplyr packages facilitates the process of organizing and refining the data, enabling a more effective review and analysis. I’ll be selecting datasets of varied types and applying diverse methods for review.
Dataset 1 - 2023 US Vehicle Model Sales
Data Acquisition
Input file:"US Vehicle Model Sales.csv” from https://github.com/ZIXIANNOW/DATA607project2/blob/main/US%20Vehicle%20Model%20Sales.csv
Also, remove useless first column.
txturl <- "https://raw.githubusercontent.com/ZIXIANNOW/DATA607project2/main/US%20Vehicle%20Model%20Sales.csv"
rawdata1 <- read.csv(txturl, skip = 1, header = TRUE)
rawdata1## X1 Model Jan Feb Mar Apr May Jun
## 1 2 Acura ILX 1 1 0 0 0 0
## 2 3 Acura Integra 2,191 2,503 3,012 3,394 2,806 2,608
## 3 4 Acura MDX 4,455 4,692 6,076 5,758 5,935 5,048
## 4 5 Acura NSX 3 1 1 0 0 0
## 5 6 Acura RDX 1,848 2,090 2,871 2,573 2,791 3,502
## 6 7 Acura TLX 990 1,121 1,609 1,576 2,173 2,013
## 7 8 Alfa Romeo Giulia 318 305 343 292 281 292
## 8 9 Alfa Romeo Stelvio 468 450 506 448 431 448
## 9 10 Alfa Romeo Tonale 0 0 0 40 38 40
## 10 11 Audi A3 1,338 1,285 1,445 1,267 1,219 1,267
## 11 12 Audi A4 1,723 1,654 1,681 1,063 1,022 1,063
## 12 13 Audi A5 1,841 1,768 1,989 2,248 2,162 2,278
## 13 14 Audi A6 653 627 705 518 498 518
## 14 15 Audi A7 179 172 193 105 101 105
## 15 16 Audi A8 128 123 138 187 180 187
## 16 17 Audi e-Tron GT 239 229 258 358 344 358
## 17 18 Audi e-Tron Sportback 159 152 374 107 103 107
## 18 19 Audi eTron 346 333 171 223 214 223
## 19 20 Audi Q3 1,268 1,217 1,370 1,712 1,646 1,712
## 20 21 Audi Q4 e-tron 551 529 595 656 631 656
## 21 22 Audi Q4 e-tron Sportback 165 159 179 187 180 187
## 22 23 Audi Q5 5,620 5,395 6,070 6,164 5,927 6,164
## 23 24 Audi Q6 0 0 0 0 0 0
## 24 25 Audi Q7 2,112 2,028 2,281 2,318 2,229 2,318
## 25 26 Audi Q8 941 903 1,016 1,175 1,130 1,175
## 26 27 Audi Q8 e-Tron 0 0 0 263 253 263
## 27 28 Audi Q8 Sportback e-tron 0 0 0 115 110 115
## 28 29 Audi R8 32 31 34 30 29 30
## 29 30 Audi TT 60 58 65 70 68 70
## 30 31 BMW 2-Series 455 437 491 947 911 947
## 31 32 BMW 3-Series 2,162 2,075 2,334 2,588 2,489 2,588
## 32 33 BMW 4-Series 3,946 3,789 4,262 4,648 4,469 4,648
## 33 34 BMW 5-Series 2,479 2,380 2,677 2,466 2,371 2,466
## 34 35 BMW 7-Series 949 911 1,025 780 750 780
## 35 36 BMW 8-Series 517 496 558 497 478 497
## 36 37 BMW iX 773 742 835 1,396 1,343 1,396
## 37 38 BMW X1 1,043 1,001 1,127 1,361 1,309 1,361
## 38 39 BMW X2 26 25 28 21 20 21
## 39 40 BMW X3 4,970 4,771 5,367 4,267 4,103 4,267
## 40 41 BMW X4 808 776 873 646 621 646
## 41 42 BMW X5 5,696 5,468 6,151 6,272 6,031 6,272
## 42 43 BMW X6 752 722 812 882 848 882
## 43 44 BMW X7 2,227 2,138 2,405 2,422 2,329 2,422
## 44 45 BMW XM 0 0 0 257 247 257
## 45 46 BMW Z4 131 126 141 244 235 244
## 46 47 Buick Enclave 2,896 2,780 3,127 3,082 2,963 3,082
## 47 48 Buick Encore 980 941 1,058 704 677 704
## 48 49 Buick Encore GX 4,039 3,878 4,362 6,096 5,862 6,096
## 49 50 Buick Envision 4,631 4,445 5,001 4,554 4,379 4,554
## 50 51 Buick Envista 0 0 0 0 0 0
## 51 52 Cadillac CT4 892 856 963 920 884 920
## 52 53 Cadillac CT5 1,511 1,450 1,632 1,822 1,752 1,822
## 53 54 Cadillac Escalade 3,036 2,914 3,278 3,902 3,752 3,902
## 54 55 Cadillac Lyriq 318 306 344 455 438 455
## 55 56 Cadillac XT4 2,228 2,139 2,406 1,936 1,862 1,936
## 56 57 Cadillac XT5 2,396 2,301 2,588 2,301 2,213 2,301
## 57 58 Cadillac XT6 1,566 1,504 1,692 1,791 1,722 1,791
## 58 59 Chevrolet Blazer 5,021 4,820 5,422 6,105 5,870 6,105
## 59 60 Chevrolet Bolt 6,480 6,221 6,999 4,713 4,532 4,713
## 60 61 Chevrolet Camaro 2,559 2,457 2,764 3,227 3,103 3,227
## 61 62 Chevrolet Colorado 4,361 4,186 4,708 6,723 6,464 6,723
## 62 63 Chevrolet Corvette 2,600 2,496 2,808 3,081 2,963 3,081
## 63 64 Chevrolet Equinox 17,402 16,706 18,794 17,879 17,191 17,879
## 64 65 Chevrolet Express 2,827 2,714 3,053 3,116 2,996 3,116
## 65 66 Chevrolet Malibu 12,315 11,823 13,300 13,753 13,224 13,753
## 66 67 Chevrolet Silverado 41,774 40,103 45,116 47,711 45,876 47,711
## 67 68 Chevrolet Spark 49 47 53 0 0 0
## 68 69 Chevrolet Suburban 4,583 4,400 4,950 5,626 5,409 5,626
## 69 70 Chevrolet Tahoe 8,966 8,607 9,683 9,879 9,499 9,879
## 70 71 Chevrolet TrailBlazer 9,194 8,827 9,930 11,432 10,993 11,432
## 71 72 Chevrolet Traverse 10,373 9,958 11,203 12,543 12,061 12,543
## 72 73 Chevrolet Trax 2,127 2,042 2,297 7,064 6,793 7,064
## 73 74 Chrysler 200 0 0 0 0 0 0
## 74 75 Chrysler 300 983 944 1,062 1,421 1,366 1,421
## 75 76 Chrysler Pacifica 9,510 9,129 10,271 15,173 14,589 15,173
## 76 77 Chrysler Town and Country 0 0 0 0 0 0
## 77 78 Dodge Challenger 3,740 3,591 4,040 4,357 4,190 4,357
## 78 79 Dodge Charger 7,279 6,988 7,861 8,308 7,988 8,308
## 79 80 Dodge Dart 0 0 0 0 0 0
## 80 81 Dodge Durango 5,746 5,516 6,205 6,632 6,377 6,632
## 81 82 Dodge Grand Caravan 0 0 0 0 0 0
## 82 83 Dodge Hornet 0 0 0 877 843 877
## 83 84 Dodge Journey 3 3 3 0 0 0
## 84 85 Dodge Viper 0 0 0 0 0 0
## 85 86 Fiat 124 Spider 0 0 0 0 0 0
## 86 87 Fiat 500 0 0 0 0 0 0
## 87 88 Fiat 500L 1 1 1 0 0 0
## 88 89 Fiat 500X 44 43 48 48 46 48
## 89 90 Ford Bronco 10,170 12,113 10,147 9,483 8,211 8,456
## 90 91 Ford Bronco Sport 9,438 8,908 11,525 11,526 10,594 11,152
## 91 92 Ford E-Series 2,848 3,514 4,423 3,183 2,732 2,820
## 92 93 Ford EcoSport 575 624 450 320 250 289
## 93 94 Ford Edge 4,969 6,513 8,800 11,034 7,685 7,483
## 94 95 Ford Escape 7,878 6,447 6,824 17,133 11,733 14,824
## 95 96 Ford Expedition 5,693 6,899 6,767 6,255 6,782 6,970
## 96 97 Ford Explorer 15,617 19,174 23,270 18,327 14,531 13,474
## 97 98 Ford F-Series 55,001 54,995 60,381 69,595 70,566 72,355
## 98 99 Ford GT 6 12 12 1 0 0
## 99 100 Ford Maverick 6,272 7,648 7,558 6,583 6,965 7,473
## 100 101 Ford Mustang 4,004 4,959 10,302 5,141 3,559 2,060
## 101 102 Ford Mustang Mach E 2,626 1,783 998 1,606 2,917 4,110
## 102 103 Ford Ranger 2,871 3,962 4,667 4,201 4,002 4,415
## 103 104 Ford Transit 10,129 11,208 10,678 9,406 11,282 11,343
## 104 105 Ford Transit Connect 1,165 1,459 1,199 2,146 1,270 1,508
## 105 106 Genesis G70 804 719 1,057 1,139 1,156 1,353
## 106 107 Genesis G80 226 172 611 383 490 887
## 107 108 Genesis G90 105 111 140 120 113 114
## 108 109 Genesis GV60 129 171 212 267 276 265
## 109 110 Genesis GV70 1,401 1,762 2,145 2,219 2,234 1,878
## 110 111 Genesis GV80 1,207 1,241 1,491 1,474 1,336 1,506
## 111 112 GMC Acadia 5,245 5,035 5,665 8,173 7,859 8,173
## 112 113 GMC Canyon 1,650 1,584 1,782 2,265 2,178 2,265
## 113 114 GMC Hummer EV 1 1 0 32 15 16
## 114 115 GMC Savana 1,578 1,515 1,704 2,454 2,360 2,454
## 115 116 GMC Sierra 22,105 21,220 23,873 25,598 24,614 25,598
## 116 117 GMC Terrain 5,897 5,661 6,369 6,651 6,395 6,651
## 117 118 GMC Yukon 6,488 6,228 7,007 7,519 7,230 7,519
## 118 119 Honda Accord 14,737 11,509 16,560 19,297 20,007 17,735
## 119 120 Honda Civic 13,313 14,812 17,423 16,317 16,110 15,979
## 120 121 Honda CR-V 20,031 16,126 31,084 31,776 33,521 31,159
## 121 122 Honda HR-V 8,013 8,371 10,120 8,970 9,300 9,136
## 122 123 Honda Insight 0 0 0 0 1 0
## 123 124 Honda Odyssey 5,609 6,262 8,031 7,314 7,011 5,239
## 124 125 Honda Passport 3,212 3,839 4,368 4,255 4,420 3,710
## 125 126 Honda Pilot 6,950 7,271 10,483 9,949 10,439 10,691
## 126 127 Honda Ridgeline 3,161 4,649 5,108 4,903 4,931 4,678
## 127 128 Hyundai Accent 16 12 2 0 0 0
## 128 129 Hyundai Elantra 8,655 10,371 13,447 13,236 15,605 13,424
## 129 130 Hyundai Ioniq 5 1,548 2,074 2,114 2,323 2,446 3,136
## 130 131 Hyundai Ioniq 6 0 0 222 890 971 1,162
## 131 132 Hyundai Kona 5,826 6,080 7,314 6,831 5,613 6,261
## 132 133 Hyundai Nexo 16 28 21 16 16 8
## 133 134 Hyundai Palisade 6,684 6,742 6,176 6,959 7,013 5,873
## 134 135 Hyundai Santa Cruz 2,614 2,868 3,825 3,590 3,526 3,627
## 135 136 Hyundai Santa Fe 7,297 7,993 13,236 10,953 10,039 11,624
## 136 137 Hyundai Sonata 4,873 4,307 5,310 0 4,321 3,834
## 137 138 Hyundai Tuscon 12,028 14,031 20,111 18,676 18,038 17,707
## 138 139 Hyundai Veloster 3 1 1 1 0 0
## 139 140 Hyundai Venue 2,441 2,537 3,625 2,648 2,413 2,695
## 140 141 Infiniti Q50 449 431 485 618 594 618
## 141 142 Infiniti Q60 123 118 133 118 113 118
## 142 143 Infiniti QX50 766 736 828 806 775 806
## 143 144 Infiniti QX55 449 431 485 434 418 434
## 144 145 Infiniti QX60 2,348 2,254 2,536 2,610 2,510 2,610
## 145 146 Infiniti QX80 1,047 1,005 1,131 995 957 995
## 146 147 Jaguar E-Pace 83 80 90 17 16 17
## 147 148 Jaguar F-Pace 530 509 572 387 372 387
## 148 149 Jaguar F-Type 119 115 129 71 68 71
## 149 150 Jaguar I-Pace 32 31 35 56 54 56
## 150 151 Jaguar XF 85 82 92 72 69 72
## 151 152 Jeep Cherokee 4,346 4,173 4,694 2,028 1,950 2,028
## 152 153 Jeep Compass 7,635 7,329 8,245 9,483 9,118 9,483
## 153 154 Jeep Gladiator 4,465 4,287 4,823 4,643 4,465 4,643
## 154 155 Jeep Grand Cherokee 17,928 17,211 19,363 23,790 22,875 23,790
## 155 156 Jeep Grand Wagoneer 0 645 726 1,089 1,047 1,089
## 156 157 Jeep Renegade 1,358 1,304 1,467 1,695 1,630 1,695
## 157 158 Jeep Wagoneer 1,829 1,756 1,975 2,727 2,622 2,727
## 158 159 Jeep Wrangler 12,490 11,991 13,490 15,759 15,153 15,759
## 159 160 Karma GS-6 30 28 32 14 7 7
## 160 161 Karma Revero 13 13 14 2 1 1
## 161 162 Kia Carnival 1,662 2,460 3,009 3,029 3,231 4,431
## 162 163 Kia EV6 1,110 1,294 988 1,241 2,237 1,458
## 163 164 Kia EV9 0 0 0 0 0 0
## 164 165 Kia Forte 8,190 10,445 11,891 11,182 10,023 10,330
## 165 166 Kia K5 3,368 5,146 5,774 5,035 5,502 6,072
## 166 167 Kia Niro 3,713 3,378 2,736 2,999 3,334 3,165
## 167 168 Kia Rio 2,184 2,385 2,436 2,792 2,216 2,180
## 168 169 Kia Seltos 3,994 3,744 6,156 5,428 7,449 5,652
## 169 170 Kia Sorento 6,288 7,012 6,886 6,965 7,764 7,912
## 170 171 Kia Soul 4,844 5,233 6,907 6,590 5,971 5,202
## 171 172 Kia Sportage 8,602 10,117 12,965 13,426 12,862 13,917
## 172 173 Kia Stinger 466 622 958 963 903 642
## 173 174 Kia Telluride 7,582 9,023 10,585 8,555 10,005 9,534
## 174 175 Land Rover Defender 1,232 1,183 1,330 1,165 1,120 1,165
## 175 176 Land Rover Discovery / LR4 127 122 137 95 91 95
## 176 177 Land Rover Discovery Sport 466 448 504 1,395 205 213
## 177 178 Land Rover Range Rover 961 922 1,037 1,395 1,341 1,395
## 178 179 Land Rover Range Rover Evoque 514 493 555 232 223 232
## 179 180 Land Rover Range Rover Sport 880 845 951 565 544 565
## 180 181 Land Rover Range Rover Velar 694 666 750 557 536 557
## 181 182 Lexus ES 2,199 2,712 3,768 3,611 3,554 3,475
## 182 183 Lexus GX 2,095 1,803 2,472 2,300 2,216 2,438
## 183 184 Lexus IS 1,661 1,668 2,032 2,061 1,838 1,854
## 184 185 Lexus LC 114 152 167 132 128 132
## 185 186 Lexus LS 179 166 234 220 241 174
## 186 187 Lexus LX 156 444 972 776 605 493
## 187 188 Lexus NX 5,093 4,662 5,801 5,320 6,237 6,925
## 188 189 Lexus RC 120 128 132 154 143 165
## 189 190 Lexus RX 7,957 8,646 9,344 10,869 10,737 9,819
## 190 191 Lexus RZ 0 0 185 302 349 281
## 191 192 Lexus TX 0 0 0 0 0 0
## 192 193 Lexus UX 868 1,074 1,250 1,426 1,172 1,012
## 193 194 Lincoln Aviator 1,174 1,821 2,241 1,901 835 241
## 194 195 Lincoln Corsair / MKC 1,617 1,361 1,045 852 2,019 2,737
## 195 196 Lincoln MKX/Nautilus 1,608 1,361 2,162 2,489 2,076 2,286
## 196 197 Lincoln Navigator 1,409 1,242 1,519 1,441 1,573 1,674
## 197 198 Lucid Air 260 249 281 203 195 203
## 198 199 Mazda 3 1,577 2,846 2,872 2,619 2,468 2,745
## 199 200 Mazda 6 0 0 1,690 0 0 0
## 200 201 Mazda CX-30 5,065 8,026 6,779 5,954 6,091 6,612
## 201 202 Mazda CX-5 9,833 12,282 16,612 14,333 14,100 12,861
## 202 203 Mazda CX-50 2,589 3,165 4,010 4,305 3,865 3,532
## 203 204 Mazda CX-9 3,170 3,515 3,151 3,311 3,349 863
## 204 205 Mazda CX-90 0 20 267 845 2,281 2,291
## 205 206 Mazda CX-90P 0 0 0 0 0 0
## 206 207 Mazda MX-30 9 2 4 17 18 16
## 207 208 Mazda MX-5 Miata 724 783 1,083 967 1,090 866
## 208 209 Mercedes-Benz A-Class 41 40 45 8 7 8
## 209 210 Mercedes-Benz AMG GT 210 202 227 240 231 240
## 210 211 Mercedes-Benz C-Class 2,455 2,357 2,652 2,912 2,800 2,912
## 211 212 Mercedes-Benz CLA-Class 832 799 899 851 819 851
## 212 213 Mercedes-Benz E / CLS-Class 0 957 1,077 1,293 1,244 1,293
## 213 214 Mercedes-Benz EQB 506 485 546 630 606 630
## 214 215 Mercedes-Benz EQE Sedan 0 0 384 568 546 568
## 215 216 Mercedes-Benz EQE SUV 0 0 0 961 606 961
## 216 217 Mercedes-Benz EQS SUV 794 762 740 1,039 999 1,039
## 217 218 Mercedes-Benz EQS-Sedan 685 658 857 829 797 829
## 218 219 Mercedes-Benz G-Class 882 847 953 1,043 1,003 1,043
## 219 220 Mercedes-Benz GL/GLS-Class 1,849 1,775 1,997 1,885 1,813 1,885
## 220 221 Mercedes-Benz GLA-Class 1,398 1,342 1,510 1,712 1,646 1,712
## 221 222 Mercedes-Benz GLB 1,415 1,359 1,528 1,219 1,172 1,219
## 222 223 Mercedes-Benz GLC/GLK-Class 1,200 1,152 1,296 4,812 4,627 4,812
## 223 224 Mercedes-Benz GLE-Class 5,234 5,024 5,652 4,650 4,471 4,650
## 224 225 Mercedes-Benz Metris 1,372 1,317 1,481 2,273 2,186 2,273
## 225 226 Mercedes-Benz S-Class 1,009 969 1,090 1,068 1,027 1,068
## 226 227 Mercedes-Benz SL-Class 302 290 326 366 352 366
## 227 228 Mercedes-Benz Sprinter 3,289 3,158 3,553 4,052 3,896 4,052
## 228 229 Mini Cooper 1,479 1,420 1,597 1,727 1,661 1,727
## 229 230 Mini Countryman 917 880 990 834 802 834
## 230 231 Mitsubishi Eclipse Cross 517 496 558 932 896 932
## 231 232 Mitsubishi Mirage 1,099 1,055 1,187 667 641 667
## 232 233 Mitsubishi Outlander 3,228 3,099 3,487 4,852 4,665 4,852
## 233 234 Mitsubishi Outlander PHEV 525 504 567 547 526 547
## 234 235 Mitsubishi Outlander Sport 1,517 1,457 1,639 1,310 1,259 1,310
## 235 236 Nissan 350Z 0 0 0 0 0 0
## 236 237 Nissan 370Z 153 147 166 169 162 169
## 237 238 Nissan Altima 10,800 10,368 11,664 10,268 9,873 10,268
## 238 239 Nissan Ariya 941 903 1,016 788 758 788
## 239 240 Nissan Armada 2,392 2,296 2,583 1,997 1,920 1,997
## 240 241 Nissan Frontier 5,568 5,345 6,013 5,812 5,589 5,812
## 241 242 Nissan GT-R 47 45 51 25 24 25
## 242 243 Nissan Kicks 3,892 3,736 4,203 6,068 5,835 6,068
## 243 244 Nissan Leaf 774 743 836 635 610 635
## 244 245 Nissan Maxima 726 697 784 1,341 1,289 1,341
## 245 246 Nissan Murano 4,093 3,930 4,421 2,953 2,839 2,953
## 246 247 Nissan Pathfinder 7,819 7,506 8,445 6,417 6,170 6,417
## 247 248 Nissan Rogue 25,164 24,158 27,177 24,057 23,132 24,057
## 248 249 Nissan Sentra 7,407 7,111 7,999 11,797 11,344 11,797
## 249 250 Nissan Titan 1,328 1,275 1,435 2,199 2,114 2,199
## 250 251 Nissan Versa 1,283 1,232 1,386 2,402 2,309 2,402
## 251 252 Polestar Polestar 1 20 19 21 3 3 4
## 252 253 Polestar Polestar 2 967 928 1,044 1,119 1,208 1,163
## 253 254 Porsche 718 324 311 350 389 374 389
## 254 255 Porsche 911 803 771 867 1,060 1,019 1,060
## 255 256 Porsche Cayenne 1,560 1,497 1,685 1,559 1,499 1,559
## 256 257 Porsche Macan 2,118 2,033 2,287 2,474 2,379 2,474
## 257 258 Porsche Panamera 320 307 345 346 332 346
## 258 259 Porsche Taycan 613 589 662 552 531 552
## 259 260 Ram Pickup 34,655 33,268 37,427 39,743 38,214 39,743
## 260 261 Ram ProMaster 5,820 5,588 6,286 6,821 6,558 6,821
## 261 262 Ram ProMaster City 1,868 1,793 2,017 1,389 1,336 1,389
## 262 263 Rivian EDV 500 0 0 0 54 52 54
## 263 264 Rivian EDV700 173 166 187 665 639 665
## 264 265 Rivian R1S 74 71 80 2,063 1,984 2,063
## 265 266 Rivian R1T 1,135 1,089 1,226 1,473 1,416 1,473
## 266 267 Subaru Ascent 4,582 4,406 5,794 5,965 6,505 5,889
## 267 268 Subaru BRZ 332 368 285 507 638 382
## 268 269 Subaru CrossTrek 12,706 14,816 14,040 10,310 10,456 13,802
## 269 270 Subaru Forester 10,114 10,030 10,264 9,651 10,582 10,669
## 270 271 Subaru Impreza 2,451 2,591 3,802 3,554 3,939 2,954
## 271 272 Subaru Legacy 1,269 1,526 2,265 2,494 2,058 2,347
## 272 273 Subaru Outback 10,414 9,108 13,245 15,263 17,146 16,225
## 273 274 Subaru Solterra 499 347 513 603 436 574
## 274 275 Subaru WRX 2,006 2,598 3,005 2,667 2,771 2,326
## 275 276 Tesla Model 3 20,724 19,895 22,382 19,753 18,994 19,753
## 276 277 Tesla Model S 5,263 5,053 5,684 1,047 1,006 1,047
## 277 278 Tesla Model X 1,974 1,895 2,132 1,992 1,916 1,992
## 278 279 Tesla Model Y 27,961 26,842 30,197 35,623 34,253 35,623
## 279 280 Toyota 4Runner 7,945 5,684 7,487 10,354 9,979 0
## 280 281 Toyota Avalon 13 20 5 2 1 2
## 281 282 Toyota bZ4X 458 509 731 734 611 616
## 282 283 Toyota C-HR 346 345 59 13 6 5
## 283 284 Toyota Camry 16,774 24,253 25,010 27,939 28,060 28,706
## 284 285 Toyota Corolla 13,049 16,398 13,528 16,729 17,308 20,485
## 285 286 Toyota Corolla Cross 3,279 5,240 5,995 5,622 2,571 5,629
## 286 287 Toyota Crown 0 58 1,335 1,920 1,610 1,232
## 287 288 Toyota GR86 441 592 1,005 1,078 969 1,178
## 288 289 Toyota Grand Highlander 0 0 0 0 0 159
## 289 290 Toyota Highlander 14,264 18,821 22,259 19,353 20,025 18,542
## 290 291 Toyota Land Cruiser 1 1 1 1 0 0
## 291 292 Toyota Mirai 222 238 208 203 406 445
## 292 293 Toyota Prius 2,486 864 0 3,001 3,888 2,466
## 293 294 Toyota RAV4 23,419 30,027 31,258 30,386 33,677 38,250
## 294 295 Toyota Sequoia 1,231 1,345 1,808 1,808 1,760 0
## 295 296 Toyota Sienna 2,506 2,745 5,236 4,768 6,267 6,418
## 296 297 Toyota Supra 307 317 247 276 228 246
## 297 298 Toyota Tacoma 17,851 17,058 18,674 21,454 20,487 21,321
## 298 299 Toyota Tundra 6,473 10,320 10,858 11,748 10,561 9,775
## 299 300 Toyota Venza 2,888 2,419 2,159 1,749 1,570 2,292
## 300 301 Volkswagen Arteon 174 167 188 212 204 212
## 301 302 Volkswagen Atlas 3,743 3,594 4,043 4,742 4,559 4,742
## 302 303 Volkswagen Atlas Sport 2,280 2,189 2,462 2,794 2,686 2,794
## 303 304 Volkswagen Golf 490 470 529 975 937 975
## 304 305 Volkswagen ID.4 3,210 3,081 3,467 2,259 2,172 2,259
## 305 306 Volkswagen Jetta 1,505 1,444 1,625 3,934 3,782 3,934
## 306 307 Volkswagen Taos 4,422 4,245 4,776 4,634 4,456 4,634
## 307 308 Volkswagen Tiguan 6,496 6,236 7,015 6,428 6,181 6,428
## 308 309 Volvo 60-Series 523 603 883 527 466 1,337
## 309 310 Volvo 90-Series 212 154 211 192 228 201
## 310 311 Volvo C40 292 341 532 904 832 1,632
## 311 312 Volvo XC40 1,641 2,178 2,264 1,759 2,115 2,193
## 312 313 Volvo XC60 2,515 2,738 3,506 3,431 3,717 3,925
## 313 314 Volvo XC90 2,510 2,546 2,834 2,798 3,365 3,645
## Jul Aug Sep Oct Nov Dec
## 1 0 0 0 0 0 0
## 2 2,742 2,794 2,784 2,336 2,259 2,661
## 3 4,397 4,172 4,386 3,638 4,074 4,968
## 4 0 0 0 0 0 0
## 5 3,292 3,962 4,273 4,200 3,692 4,134
## 6 1,631 1,231 1,229 980 1,085 1,093
## 7 277 299 288 252 252 262
## 8 410 443 427 430 430 447
## 9 239 258 249 406 406 422
## 10 900 972 936 986 986 1,025
## 11 808 873 840 869 869 904
## 12 1,935 2,090 2,012 1,804 1,804 1,876
## 13 762 823 793 796 796 828
## 14 121 131 126 189 189 197
## 15 247 267 258 179 179 186
## 16 204 221 213 256 256 266
## 17 1,749 3 3 0 0 0
## 18 5 5 5 0 0 0
## 19 0 1,889 1,819 2,568 2,568 2,671
## 20 784 847 815 685 685 712
## 21 267 289 278 236 236 245
## 22 6,207 6,703 6,455 6,394 6,394 6,650
## 23 0 0 0 0 2,462 0
## 24 2,616 2,825 2,721 2,462 0 2,560
## 25 1,189 1,284 1,236 1,151 1,151 1,197
## 26 881 951 916 299 962 1,001
## 27 0 294 283 0 299 311
## 28 61 65 63 84 84 87
## 29 71 77 74 37 37 38
## 30 1,005 1,085 1,045 1,413 1,413 1,470
## 31 2,837 3,064 2,951 3,529 3,529 3,670
## 32 4,381 4,731 4,556 3,733 3,733 3,882
## 33 555 600 578 1,917 1,917 1,994
## 34 762 823 792 1,065 1,065 1,108
## 35 429 463 446 451 451 469
## 36 1,776 1,918 1,847 1,735 1,735 1,804
## 37 1,827 1,973 1,900 2,678 2,678 2,785
## 38 11 12 12 5 5 5
## 39 4,702 5,078 4,890 6,828 6,828 7,101
## 40 634 685 659 1,049 1,049 1,091
## 41 5,124 5,534 5,329 6,808 6,808 7,081
## 42 693 749 721 992 992 1,032
## 43 1,924 2,078 2,001 2,912 2,912 3,028
## 44 142 153 148 231 231 240
## 45 106 115 110 141 141 147
## 46 3,382 3,653 3,518 3,595 3,595 3,739
## 47 225 243 234 40 40 42
## 48 6,249 6,944 6,687 4,525 4,525 4,706
## 49 2,333 2,520 2,426 3,105 3,105 3,229
## 50 1,726 1,864 1,795 2,604 2,604 2,708
## 51 610 659 634 594 594 618
## 52 1,413 1,526 1,469 1,380 1,380 1,435
## 53 3,429 3,704 3,567 3,357 3,357 3,492
## 54 967 1,045 1,006 1,257 1,257 1,307
## 55 1,699 1,835 1,767 1,612 1,612 1,676
## 56 1,991 2,150 2,071 2,137 2,137 2,222
## 57 1,313 1,418 1,366 1,630 1,630 1,695
## 58 4,973 5,371 5,172 5,478 5,478 5,697
## 59 5,075 5,481 5,278 4,129 4,129 4,294
## 60 2,356 2,545 2,450 2,086 2,086 2,169
## 61 8,179 8,834 8,507 4,078 4,078 4,241
## 62 2,695 2,911 2,803 2,933 2,933 3,050
## 63 15,478 16,716 16,097 19,263 19,263 20,033
## 64 4,078 4,404 4,241 3,327 3,327 3,460
## 65 10,667 11,520 11,093 6,215 6,215 6,463
## 66 45,983 49,662 47,822 47,168 47,168 49,054
## 67 0 0 0 0 0 0
## 68 3,873 4,183 4,028 3,337 3,337 3,470
## 69 8,839 9,546 9,193 8,630 8,630 8,975
## 70 9,830 10,617 10,224 6,097 6,097 6,341
## 71 10,358 11,187 10,773 0 7,420 7,717
## 72 12,138 13,109 12,623 14,515 14,515 15,096
## 73 0 0 0 1 1 1
## 74 1,270 1,371 1,321 661 661 688
## 75 12,293 13,276 12,784 2,749 2,859 2,859
## 76 0 0 0 1 1 0
## 77 3,550 3,834 3,692 3,161 3,161 3,288
## 78 5,421 5,855 5,638 4,037 4,037 4,199
## 79 0 0 0 1 1 1
## 80 5,280 5,702 5,491 5,136 5,136 5,342
## 81 0 0 0 8 8 9
## 82 562 607 584 1,633 1,633 1,698
## 83 1 0 0 8 8 8
## 84 0 0 0 1 1 0
## 85 0 0 0 9 9 10
## 86 1 0 0 5 5 5
## 87 0 0 0 1 1 1
## 88 46 50 48 43 43 45
## 89 12,755 10,450 9,683 4,805 2,911 6,481
## 90 12,939 11,301 8,992 8,306 9,949 12,846
## 91 4,558 3,613 2,811 4,218 4,150 4,087
## 92 0 0 0 0 0 0
## 93 9,633 6,259 8,325 11,015 9,939 14,443
## 94 12,413 12,432 13,929 12,573 11,542 13,240
## 95 4,753 6,923 5,385 4,704 4,906 7,359
## 96 8,664 8,572 16,473 16,634 12,513 19,520
## 97 68,536 63,287 58,654 53,509 53,069 70,841
## 98 0 0 0 0 0 0
## 99 7,627 8,299 8,005 9,530 10,379 7,719
## 100 1,233 2,036 6,575 4,270 4,293 4,727
## 101 3,937 5,033 5,872 2,732 4,294 4,863
## 102 4,315 2,069 1,001 453 206 172
## 103 13,516 11,641 8,849 8,142 8,585 14,230
## 104 1,095 1,695 2,587 995 1,476 1,455
## 105 1,310 1,394 1,751 982 684 897
## 106 627 293 437 472 338 404
## 107 108 119 92 68 68 130
## 108 261 258 379 353 434 395
## 109 2,525 2,451 1,994 2,059 2,322 2,837
## 110 1,499 1,938 1,991 1,790 2,084 2,140
## 111 4,935 5,330 5,133 3,544 3,544 3,686
## 112 2,445 2,640 2,542 1,022 1,022 1,063
## 113 374 404 389 667 667 694
## 114 2,306 2,491 2,399 831 831 865
## 115 23,468 25,345 24,406 26,155 26,155 27,201
## 116 5,450 5,886 5,668 5,667 5,667 5,894
## 117 6,781 7,324 7,053 6,290 6,290 6,541
## 118 17,873 17,661 16,823 15,346 13,935 16,464
## 119 17,154 17,077 18,696 17,228 16,837 19,435
## 120 33,097 30,991 34,566 31,397 31,412 36,297
## 121 8,919 11,404 12,801 11,696 10,642 12,834
## 122 0 0 0 0 0 0
## 123 5,240 2,713 5,713 5,500 5,919 6,960
## 124 3,280 0 3,550 3,411 3,173 3,571
## 125 9,962 10,089 6,563 8,223 9,113 10,565
## 126 4,175 3,910 4,053 4,133 3,894 4,406
## 127 1 0 0 0 0 0
## 128 11,898 11,262 9,405 9,456 8,813 8,577
## 129 4,135 3,572 3,958 2,979 2,372 3,261
## 130 1,745 1,663 1,665 1,239 1,386 2,056
## 131 6,123 5,777 6,693 7,927 6,991 7,680
## 132 34 18 16 23 20 25
## 133 5,752 6,107 7,551 7,071 9,185 14,396
## 134 2,903 3,079 3,051 2,555 2,396 2,641
## 135 10,612 11,732 12,676 9,700 13,497 12,215
## 136 3,209 3,397 3,401 2,460 2,321 3,222
## 137 17,534 16,242 18,813 15,638 21,382 19,424
## 138 0 0 0 0 0 0
## 139 2,581 2,197 1,732 1,757 1,716 1,667
## 140 586 632 609 388 388 403
## 141 689 74 71 41 41 42
## 142 780 843 812 917 917 954
## 143 455 491 473 443 443 461
## 144 2,421 2,615 2,518 2,289 2,289 2,381
## 145 992 1,071 1,032 1,142 1,142 1,187
## 146 27 29 28 26 26 89
## 147 333 359 346 481 481 501
## 148 91 99 95 86 86 89
## 149 21 23 22 59 59 61
## 150 64 70 67 86 86 89
## 151 1,217 1,315 1,266 524 524 545
## 152 6,496 7,016 6,756 8,096 8,096 8,420
## 153 4,552 4,916 4,734 4,493 4,493 4,673
## 154 18,563 20,048 19,305 20,304 20,304 21,116
## 155 919 992 956 817 817 849
## 156 2,055 2,220 2,137 3,438 3,438 3,575
## 157 2,323 2,509 2,416 2,719 2,719 2,828
## 158 13,432 14,507 13,970 8,789 9,878 10,273
## 159 8 9 8 0 0 0
## 160 4 4 4 0 0 0
## 161 5,285 5,428 4,638 3,507 3,404 3,603
## 162 1,937 2,449 2,084 1,542 1,290 1,249
## 163 0 0 0 0 5 1,113
## 164 11,004 11,333 10,737 9,393 9,849 9,576
## 165 6,215 6,480 6,002 5,200 5,112 4,866
## 166 3,112 3,896 2,752 2,408 2,366 2,441
## 167 2,358 2,546 2,096 2,544 1,785 1,279
## 168 5,251 4,649 4,736 4,355 4,214 4,425
## 169 8,569 8,147 8,103 6,388 6,872 7,739
## 170 5,123 4,911 5,290 4,192 3,601 3,399
## 171 11,853 12,280 11,562 11,053 11,010 11,133
## 172 464 237 117 49 20 11
## 173 9,759 9,791 9,147 8,533 8,810 9,441
## 174 2,007 2,168 2,087 2,551 2,551 2,653
## 175 271 293 282 297 297 309
## 176 163 176 169 190 190 197
## 177 1,356 1,465 1,411 1,548 1,548 1,610
## 178 217 234 226 279 279 290
## 179 922 996 959 1,386 1,386 1,442
## 180 488 527 508 529 529 550
## 181 3,222 3,006 3,394 3,093 3,210 3,873
## 182 2,418 2,818 2,932 2,852 3,310 4,256
## 183 2,042 2,124 1,888 1,685 1,578 2,090
## 184 162 166 178 149 127 154
## 185 181 180 153 169 159 181
## 186 531 566 731 594 506 585
## 187 5,951 5,565 6,131 6,930 7,332 8,579
## 188 136 167 169 142 127 169
## 189 8,815 7,899 9,405 8,591 9,703 12,248
## 190 495 456 443 743 1,107 1,025
## 191 0 0 0 1,384 3,083 3,734
## 192 898 848 826 851 738 883
## 193 164 57 1,242 1,911 1,335 2,629
## 194 2,559 2,789 2,504 2,353 2,060 2,488
## 195 2,438 2,123 1,980 1,318 1,620 2,499
## 196 1,500 1,620 1,407 1,292 1,226 1,646
## 197 256 277 267 313 313 325
## 198 2,994 2,611 2,632 2,205 2,504 2,458
## 199 0 0 0 0 0 0
## 200 7,221 6,630 6,924 5,908 6,193 5,672
## 201 12,443 13,649 9,742 7,963 9,556 20,434
## 202 4,234 2,602 3,417 3,168 3,954 5,754
## 203 60 9 12 7 2 2
## 204 2,929 2,234 4,701 3,722 5,055 4,776
## 205 0 1,700 0 0 0 0
## 206 28 6 0 0 0 0
## 207 720 733 603 531 451 422
## 208 3 3 3 0 0 0
## 209 147 159 153 0 0 0
## 210 2,583 2,789 2,686 0 0 0
## 211 893 964 928 0 0 0
## 212 1,547 1,671 1,609 0 0 0
## 213 1,048 1,132 1,090 0 0 0
## 214 311 335 323 0 0 0
## 215 1,118 1,207 1,163 0 0 0
## 216 512 552 532 0 0 0
## 217 353 381 367 0 0 0
## 218 620 0 645 0 0 0
## 219 1,699 670 1,767 0 0 0
## 220 811 875 843 0 0 0
## 221 1,638 1,769 1,704 0 0 0
## 222 3,687 3,982 3,835 0 0 0
## 223 4,317 1,835 4,489 0 0 0
## 224 3,205 3,462 3,333 0 0 0
## 225 1,247 1,347 1,297 0 0 0
## 226 257 278 267 0 0 0
## 227 2,857 3,085 2,971 0 0 0
## 228 1,581 1,708 1,645 2,115 2,115 2,199
## 229 951 1,027 989 1,414 1,414 1,471
## 230 1,061 1,146 1,104 750 750 780
## 231 1,291 1,394 1,343 1,275 1,275 1,326
## 232 2,994 3,233 3,113 2,954 2,954 3,072
## 233 605 653 629 519 519 540
## 234 1,163 1,257 1,210 952 952 990
## 235 0 0 0 0 152 0
## 236 110 119 114 152 0 158
## 237 9,381 10,132 9,757 11,684 11,684 12,151
## 238 1,444 1,559 1,501 1,238 1,238 1,288
## 239 1,453 1,569 1,511 1,140 1,140 1,186
## 240 3,768 4,069 3,919 4,026 4,026 4,187
## 241 30 33 32 26 26 27
## 242 6,517 7,039 6,778 5,488 5,488 5,708
## 243 503 543 523 443 443 461
## 244 799 863 831 323 323 336
## 245 1,640 1,772 1,706 1,589 1,589 1,653
## 246 4,381 4,732 4,556 5,022 5,022 5,223
## 247 20,303 21,927 21,115 19,858 19,858 20,652
## 248 10,132 10,943 10,537 6,621 6,621 6,886
## 249 1,557 1,681 1,619 1,244 1,244 1,294
## 250 2,191 2,366 2,278 2,289 2,289 2,380
## 251 0 0 0 4 4 4
## 252 673 727 700 599 599 623
## 253 309 333 321 329 328 341
## 254 998 1,078 1,038 998 998 1,038
## 255 1,720 1,857 1,789 1,830 1,830 1,903
## 256 2,412 2,605 2,508 2,010 2,010 2,090
## 257 372 402 387 342 342 356
## 258 596 643 619 776 776 807
## 259 35,061 37,866 36,464 37,002 37,002 38,482
## 260 7,194 7,770 7,482 7,014 7,014 7,295
## 261 814 880 847 182 182 190
## 262 64 69 67 66 66 68
## 263 0 0 0 428 428 445
## 264 3,526 3,808 3,667 2,007 2,007 2,087
## 265 2,628 2,838 2,733 1,118 1,118 1,163
## 266 4,281 4,860 4,599 4,374 4,292 4,996
## 267 311 268 270 291 263 273
## 268 11,241 13,920 13,341 13,768 14,994 15,799
## 269 14,504 15,294 15,237 15,479 15,089 15,653
## 270 2,800 2,205 2,868 2,662 2,370 2,523
## 271 2,170 2,765 2,727 2,172 1,838 1,878
## 272 12,430 14,503 14,545 12,396 12,233 14,304
## 273 758 915 1,118 1,210 943 956
## 274 1,894 1,677 1,630 1,420 1,305 1,382
## 275 16,667 18,000 17,333 0 0 0
## 276 1,090 1,177 1,133 0 0 0
## 277 1,795 1,938 1,867 0 0 0
## 278 30,128 32,538 31,333 0 0 0
## 279 11,206 12,569 12,083 10,344 10,025 12,275
## 280 0 8 1 3 0 0
## 281 714 931 1,182 1,326 848 669
## 282 0 1 1 0 0 1
## 283 25,110 16,638 25,485 24,596 22,673 25,405
## 284 21,382 24,134 22,679 22,272 21,005 23,400
## 285 7,472 6,322 7,030 7,446 0 7,484
## 286 2,060 2,418 2,421 1,907 1,831 2,271
## 287 1,371 1,143 960 794 757 790
## 288 5,377 0 10,177 7,571 7,735 8,354
## 289 8,590 8,663 9,407 9,536 9,499 12,330
## 290 0 1 0 0 0 1
## 291 463 287 132 57 53 23
## 292 3,940 4,667 4,342 1,452 3,532 5,178
## 293 37,821 39,895 38,098 42,226 42,842 47,044
## 294 1,639 2,445 2,129 1,976 1,948 2,468
## 295 6,158 7,344 6,311 0 6,594 0
## 296 157 134 185 85 225 245
## 297 20,126 22,131 20,579 17,456 18,156 19,475
## 298 10,457 11,235 11,261 10,330 9,654 12,513
## 299 2,790 3,030 3,190 2,896 2,369 2,555
## 300 219 237 228 167 167 174
## 301 5,156 5,569 5,362 6,365 6,365 6,619
## 302 2,827 3,053 2,940 3,549 3,549 3,691
## 303 1,216 1,313 1,265 829 829 862
## 304 3,432 3,706 3,569 3,498 3,498 3,638
## 305 4,594 4,961 4,777 5,543 5,543 5,765
## 306 5,262 5,683 5,472 5,035 5,035 5,236
## 307 5,421 5,855 5,638 6,753 6,753 7,023
## 308 722 944 1,501 1,775 1,742 1,296
## 309 176 120 141 147 134 112
## 310 564 359 330 304 284 215
## 311 2,443 2,495 2,540 2,764 2,684 3,067
## 312 3,161 2,946 3,211 3,307 3,170 4,075
## 313 3,719 3,780 3,223 2,999 3,657 4,844rawdata1 <- rawdata1[-1]
rawdata1## Model Jan Feb Mar Apr May Jun
## 1 Acura ILX 1 1 0 0 0 0
## 2 Acura Integra 2,191 2,503 3,012 3,394 2,806 2,608
## 3 Acura MDX 4,455 4,692 6,076 5,758 5,935 5,048
## 4 Acura NSX 3 1 1 0 0 0
## 5 Acura RDX 1,848 2,090 2,871 2,573 2,791 3,502
## 6 Acura TLX 990 1,121 1,609 1,576 2,173 2,013
## 7 Alfa Romeo Giulia 318 305 343 292 281 292
## 8 Alfa Romeo Stelvio 468 450 506 448 431 448
## 9 Alfa Romeo Tonale 0 0 0 40 38 40
## 10 Audi A3 1,338 1,285 1,445 1,267 1,219 1,267
## 11 Audi A4 1,723 1,654 1,681 1,063 1,022 1,063
## 12 Audi A5 1,841 1,768 1,989 2,248 2,162 2,278
## 13 Audi A6 653 627 705 518 498 518
## 14 Audi A7 179 172 193 105 101 105
## 15 Audi A8 128 123 138 187 180 187
## 16 Audi e-Tron GT 239 229 258 358 344 358
## 17 Audi e-Tron Sportback 159 152 374 107 103 107
## 18 Audi eTron 346 333 171 223 214 223
## 19 Audi Q3 1,268 1,217 1,370 1,712 1,646 1,712
## 20 Audi Q4 e-tron 551 529 595 656 631 656
## 21 Audi Q4 e-tron Sportback 165 159 179 187 180 187
## 22 Audi Q5 5,620 5,395 6,070 6,164 5,927 6,164
## 23 Audi Q6 0 0 0 0 0 0
## 24 Audi Q7 2,112 2,028 2,281 2,318 2,229 2,318
## 25 Audi Q8 941 903 1,016 1,175 1,130 1,175
## 26 Audi Q8 e-Tron 0 0 0 263 253 263
## 27 Audi Q8 Sportback e-tron 0 0 0 115 110 115
## 28 Audi R8 32 31 34 30 29 30
## 29 Audi TT 60 58 65 70 68 70
## 30 BMW 2-Series 455 437 491 947 911 947
## 31 BMW 3-Series 2,162 2,075 2,334 2,588 2,489 2,588
## 32 BMW 4-Series 3,946 3,789 4,262 4,648 4,469 4,648
## 33 BMW 5-Series 2,479 2,380 2,677 2,466 2,371 2,466
## 34 BMW 7-Series 949 911 1,025 780 750 780
## 35 BMW 8-Series 517 496 558 497 478 497
## 36 BMW iX 773 742 835 1,396 1,343 1,396
## 37 BMW X1 1,043 1,001 1,127 1,361 1,309 1,361
## 38 BMW X2 26 25 28 21 20 21
## 39 BMW X3 4,970 4,771 5,367 4,267 4,103 4,267
## 40 BMW X4 808 776 873 646 621 646
## 41 BMW X5 5,696 5,468 6,151 6,272 6,031 6,272
## 42 BMW X6 752 722 812 882 848 882
## 43 BMW X7 2,227 2,138 2,405 2,422 2,329 2,422
## 44 BMW XM 0 0 0 257 247 257
## 45 BMW Z4 131 126 141 244 235 244
## 46 Buick Enclave 2,896 2,780 3,127 3,082 2,963 3,082
## 47 Buick Encore 980 941 1,058 704 677 704
## 48 Buick Encore GX 4,039 3,878 4,362 6,096 5,862 6,096
## 49 Buick Envision 4,631 4,445 5,001 4,554 4,379 4,554
## 50 Buick Envista 0 0 0 0 0 0
## 51 Cadillac CT4 892 856 963 920 884 920
## 52 Cadillac CT5 1,511 1,450 1,632 1,822 1,752 1,822
## 53 Cadillac Escalade 3,036 2,914 3,278 3,902 3,752 3,902
## 54 Cadillac Lyriq 318 306 344 455 438 455
## 55 Cadillac XT4 2,228 2,139 2,406 1,936 1,862 1,936
## 56 Cadillac XT5 2,396 2,301 2,588 2,301 2,213 2,301
## 57 Cadillac XT6 1,566 1,504 1,692 1,791 1,722 1,791
## 58 Chevrolet Blazer 5,021 4,820 5,422 6,105 5,870 6,105
## 59 Chevrolet Bolt 6,480 6,221 6,999 4,713 4,532 4,713
## 60 Chevrolet Camaro 2,559 2,457 2,764 3,227 3,103 3,227
## 61 Chevrolet Colorado 4,361 4,186 4,708 6,723 6,464 6,723
## 62 Chevrolet Corvette 2,600 2,496 2,808 3,081 2,963 3,081
## 63 Chevrolet Equinox 17,402 16,706 18,794 17,879 17,191 17,879
## 64 Chevrolet Express 2,827 2,714 3,053 3,116 2,996 3,116
## 65 Chevrolet Malibu 12,315 11,823 13,300 13,753 13,224 13,753
## 66 Chevrolet Silverado 41,774 40,103 45,116 47,711 45,876 47,711
## 67 Chevrolet Spark 49 47 53 0 0 0
## 68 Chevrolet Suburban 4,583 4,400 4,950 5,626 5,409 5,626
## 69 Chevrolet Tahoe 8,966 8,607 9,683 9,879 9,499 9,879
## 70 Chevrolet TrailBlazer 9,194 8,827 9,930 11,432 10,993 11,432
## 71 Chevrolet Traverse 10,373 9,958 11,203 12,543 12,061 12,543
## 72 Chevrolet Trax 2,127 2,042 2,297 7,064 6,793 7,064
## 73 Chrysler 200 0 0 0 0 0 0
## 74 Chrysler 300 983 944 1,062 1,421 1,366 1,421
## 75 Chrysler Pacifica 9,510 9,129 10,271 15,173 14,589 15,173
## 76 Chrysler Town and Country 0 0 0 0 0 0
## 77 Dodge Challenger 3,740 3,591 4,040 4,357 4,190 4,357
## 78 Dodge Charger 7,279 6,988 7,861 8,308 7,988 8,308
## 79 Dodge Dart 0 0 0 0 0 0
## 80 Dodge Durango 5,746 5,516 6,205 6,632 6,377 6,632
## 81 Dodge Grand Caravan 0 0 0 0 0 0
## 82 Dodge Hornet 0 0 0 877 843 877
## 83 Dodge Journey 3 3 3 0 0 0
## 84 Dodge Viper 0 0 0 0 0 0
## 85 Fiat 124 Spider 0 0 0 0 0 0
## 86 Fiat 500 0 0 0 0 0 0
## 87 Fiat 500L 1 1 1 0 0 0
## 88 Fiat 500X 44 43 48 48 46 48
## 89 Ford Bronco 10,170 12,113 10,147 9,483 8,211 8,456
## 90 Ford Bronco Sport 9,438 8,908 11,525 11,526 10,594 11,152
## 91 Ford E-Series 2,848 3,514 4,423 3,183 2,732 2,820
## 92 Ford EcoSport 575 624 450 320 250 289
## 93 Ford Edge 4,969 6,513 8,800 11,034 7,685 7,483
## 94 Ford Escape 7,878 6,447 6,824 17,133 11,733 14,824
## 95 Ford Expedition 5,693 6,899 6,767 6,255 6,782 6,970
## 96 Ford Explorer 15,617 19,174 23,270 18,327 14,531 13,474
## 97 Ford F-Series 55,001 54,995 60,381 69,595 70,566 72,355
## 98 Ford GT 6 12 12 1 0 0
## 99 Ford Maverick 6,272 7,648 7,558 6,583 6,965 7,473
## 100 Ford Mustang 4,004 4,959 10,302 5,141 3,559 2,060
## 101 Ford Mustang Mach E 2,626 1,783 998 1,606 2,917 4,110
## 102 Ford Ranger 2,871 3,962 4,667 4,201 4,002 4,415
## 103 Ford Transit 10,129 11,208 10,678 9,406 11,282 11,343
## 104 Ford Transit Connect 1,165 1,459 1,199 2,146 1,270 1,508
## 105 Genesis G70 804 719 1,057 1,139 1,156 1,353
## 106 Genesis G80 226 172 611 383 490 887
## 107 Genesis G90 105 111 140 120 113 114
## 108 Genesis GV60 129 171 212 267 276 265
## 109 Genesis GV70 1,401 1,762 2,145 2,219 2,234 1,878
## 110 Genesis GV80 1,207 1,241 1,491 1,474 1,336 1,506
## 111 GMC Acadia 5,245 5,035 5,665 8,173 7,859 8,173
## 112 GMC Canyon 1,650 1,584 1,782 2,265 2,178 2,265
## 113 GMC Hummer EV 1 1 0 32 15 16
## 114 GMC Savana 1,578 1,515 1,704 2,454 2,360 2,454
## 115 GMC Sierra 22,105 21,220 23,873 25,598 24,614 25,598
## 116 GMC Terrain 5,897 5,661 6,369 6,651 6,395 6,651
## 117 GMC Yukon 6,488 6,228 7,007 7,519 7,230 7,519
## 118 Honda Accord 14,737 11,509 16,560 19,297 20,007 17,735
## 119 Honda Civic 13,313 14,812 17,423 16,317 16,110 15,979
## 120 Honda CR-V 20,031 16,126 31,084 31,776 33,521 31,159
## 121 Honda HR-V 8,013 8,371 10,120 8,970 9,300 9,136
## 122 Honda Insight 0 0 0 0 1 0
## 123 Honda Odyssey 5,609 6,262 8,031 7,314 7,011 5,239
## 124 Honda Passport 3,212 3,839 4,368 4,255 4,420 3,710
## 125 Honda Pilot 6,950 7,271 10,483 9,949 10,439 10,691
## 126 Honda Ridgeline 3,161 4,649 5,108 4,903 4,931 4,678
## 127 Hyundai Accent 16 12 2 0 0 0
## 128 Hyundai Elantra 8,655 10,371 13,447 13,236 15,605 13,424
## 129 Hyundai Ioniq 5 1,548 2,074 2,114 2,323 2,446 3,136
## 130 Hyundai Ioniq 6 0 0 222 890 971 1,162
## 131 Hyundai Kona 5,826 6,080 7,314 6,831 5,613 6,261
## 132 Hyundai Nexo 16 28 21 16 16 8
## 133 Hyundai Palisade 6,684 6,742 6,176 6,959 7,013 5,873
## 134 Hyundai Santa Cruz 2,614 2,868 3,825 3,590 3,526 3,627
## 135 Hyundai Santa Fe 7,297 7,993 13,236 10,953 10,039 11,624
## 136 Hyundai Sonata 4,873 4,307 5,310 0 4,321 3,834
## 137 Hyundai Tuscon 12,028 14,031 20,111 18,676 18,038 17,707
## 138 Hyundai Veloster 3 1 1 1 0 0
## 139 Hyundai Venue 2,441 2,537 3,625 2,648 2,413 2,695
## 140 Infiniti Q50 449 431 485 618 594 618
## 141 Infiniti Q60 123 118 133 118 113 118
## 142 Infiniti QX50 766 736 828 806 775 806
## 143 Infiniti QX55 449 431 485 434 418 434
## 144 Infiniti QX60 2,348 2,254 2,536 2,610 2,510 2,610
## 145 Infiniti QX80 1,047 1,005 1,131 995 957 995
## 146 Jaguar E-Pace 83 80 90 17 16 17
## 147 Jaguar F-Pace 530 509 572 387 372 387
## 148 Jaguar F-Type 119 115 129 71 68 71
## 149 Jaguar I-Pace 32 31 35 56 54 56
## 150 Jaguar XF 85 82 92 72 69 72
## 151 Jeep Cherokee 4,346 4,173 4,694 2,028 1,950 2,028
## 152 Jeep Compass 7,635 7,329 8,245 9,483 9,118 9,483
## 153 Jeep Gladiator 4,465 4,287 4,823 4,643 4,465 4,643
## 154 Jeep Grand Cherokee 17,928 17,211 19,363 23,790 22,875 23,790
## 155 Jeep Grand Wagoneer 0 645 726 1,089 1,047 1,089
## 156 Jeep Renegade 1,358 1,304 1,467 1,695 1,630 1,695
## 157 Jeep Wagoneer 1,829 1,756 1,975 2,727 2,622 2,727
## 158 Jeep Wrangler 12,490 11,991 13,490 15,759 15,153 15,759
## 159 Karma GS-6 30 28 32 14 7 7
## 160 Karma Revero 13 13 14 2 1 1
## 161 Kia Carnival 1,662 2,460 3,009 3,029 3,231 4,431
## 162 Kia EV6 1,110 1,294 988 1,241 2,237 1,458
## 163 Kia EV9 0 0 0 0 0 0
## 164 Kia Forte 8,190 10,445 11,891 11,182 10,023 10,330
## 165 Kia K5 3,368 5,146 5,774 5,035 5,502 6,072
## 166 Kia Niro 3,713 3,378 2,736 2,999 3,334 3,165
## 167 Kia Rio 2,184 2,385 2,436 2,792 2,216 2,180
## 168 Kia Seltos 3,994 3,744 6,156 5,428 7,449 5,652
## 169 Kia Sorento 6,288 7,012 6,886 6,965 7,764 7,912
## 170 Kia Soul 4,844 5,233 6,907 6,590 5,971 5,202
## 171 Kia Sportage 8,602 10,117 12,965 13,426 12,862 13,917
## 172 Kia Stinger 466 622 958 963 903 642
## 173 Kia Telluride 7,582 9,023 10,585 8,555 10,005 9,534
## 174 Land Rover Defender 1,232 1,183 1,330 1,165 1,120 1,165
## 175 Land Rover Discovery / LR4 127 122 137 95 91 95
## 176 Land Rover Discovery Sport 466 448 504 1,395 205 213
## 177 Land Rover Range Rover 961 922 1,037 1,395 1,341 1,395
## 178 Land Rover Range Rover Evoque 514 493 555 232 223 232
## 179 Land Rover Range Rover Sport 880 845 951 565 544 565
## 180 Land Rover Range Rover Velar 694 666 750 557 536 557
## 181 Lexus ES 2,199 2,712 3,768 3,611 3,554 3,475
## 182 Lexus GX 2,095 1,803 2,472 2,300 2,216 2,438
## 183 Lexus IS 1,661 1,668 2,032 2,061 1,838 1,854
## 184 Lexus LC 114 152 167 132 128 132
## 185 Lexus LS 179 166 234 220 241 174
## 186 Lexus LX 156 444 972 776 605 493
## 187 Lexus NX 5,093 4,662 5,801 5,320 6,237 6,925
## 188 Lexus RC 120 128 132 154 143 165
## 189 Lexus RX 7,957 8,646 9,344 10,869 10,737 9,819
## 190 Lexus RZ 0 0 185 302 349 281
## 191 Lexus TX 0 0 0 0 0 0
## 192 Lexus UX 868 1,074 1,250 1,426 1,172 1,012
## 193 Lincoln Aviator 1,174 1,821 2,241 1,901 835 241
## 194 Lincoln Corsair / MKC 1,617 1,361 1,045 852 2,019 2,737
## 195 Lincoln MKX/Nautilus 1,608 1,361 2,162 2,489 2,076 2,286
## 196 Lincoln Navigator 1,409 1,242 1,519 1,441 1,573 1,674
## 197 Lucid Air 260 249 281 203 195 203
## 198 Mazda 3 1,577 2,846 2,872 2,619 2,468 2,745
## 199 Mazda 6 0 0 1,690 0 0 0
## 200 Mazda CX-30 5,065 8,026 6,779 5,954 6,091 6,612
## 201 Mazda CX-5 9,833 12,282 16,612 14,333 14,100 12,861
## 202 Mazda CX-50 2,589 3,165 4,010 4,305 3,865 3,532
## 203 Mazda CX-9 3,170 3,515 3,151 3,311 3,349 863
## 204 Mazda CX-90 0 20 267 845 2,281 2,291
## 205 Mazda CX-90P 0 0 0 0 0 0
## 206 Mazda MX-30 9 2 4 17 18 16
## 207 Mazda MX-5 Miata 724 783 1,083 967 1,090 866
## 208 Mercedes-Benz A-Class 41 40 45 8 7 8
## 209 Mercedes-Benz AMG GT 210 202 227 240 231 240
## 210 Mercedes-Benz C-Class 2,455 2,357 2,652 2,912 2,800 2,912
## 211 Mercedes-Benz CLA-Class 832 799 899 851 819 851
## 212 Mercedes-Benz E / CLS-Class 0 957 1,077 1,293 1,244 1,293
## 213 Mercedes-Benz EQB 506 485 546 630 606 630
## 214 Mercedes-Benz EQE Sedan 0 0 384 568 546 568
## 215 Mercedes-Benz EQE SUV 0 0 0 961 606 961
## 216 Mercedes-Benz EQS SUV 794 762 740 1,039 999 1,039
## 217 Mercedes-Benz EQS-Sedan 685 658 857 829 797 829
## 218 Mercedes-Benz G-Class 882 847 953 1,043 1,003 1,043
## 219 Mercedes-Benz GL/GLS-Class 1,849 1,775 1,997 1,885 1,813 1,885
## 220 Mercedes-Benz GLA-Class 1,398 1,342 1,510 1,712 1,646 1,712
## 221 Mercedes-Benz GLB 1,415 1,359 1,528 1,219 1,172 1,219
## 222 Mercedes-Benz GLC/GLK-Class 1,200 1,152 1,296 4,812 4,627 4,812
## 223 Mercedes-Benz GLE-Class 5,234 5,024 5,652 4,650 4,471 4,650
## 224 Mercedes-Benz Metris 1,372 1,317 1,481 2,273 2,186 2,273
## 225 Mercedes-Benz S-Class 1,009 969 1,090 1,068 1,027 1,068
## 226 Mercedes-Benz SL-Class 302 290 326 366 352 366
## 227 Mercedes-Benz Sprinter 3,289 3,158 3,553 4,052 3,896 4,052
## 228 Mini Cooper 1,479 1,420 1,597 1,727 1,661 1,727
## 229 Mini Countryman 917 880 990 834 802 834
## 230 Mitsubishi Eclipse Cross 517 496 558 932 896 932
## 231 Mitsubishi Mirage 1,099 1,055 1,187 667 641 667
## 232 Mitsubishi Outlander 3,228 3,099 3,487 4,852 4,665 4,852
## 233 Mitsubishi Outlander PHEV 525 504 567 547 526 547
## 234 Mitsubishi Outlander Sport 1,517 1,457 1,639 1,310 1,259 1,310
## 235 Nissan 350Z 0 0 0 0 0 0
## 236 Nissan 370Z 153 147 166 169 162 169
## 237 Nissan Altima 10,800 10,368 11,664 10,268 9,873 10,268
## 238 Nissan Ariya 941 903 1,016 788 758 788
## 239 Nissan Armada 2,392 2,296 2,583 1,997 1,920 1,997
## 240 Nissan Frontier 5,568 5,345 6,013 5,812 5,589 5,812
## 241 Nissan GT-R 47 45 51 25 24 25
## 242 Nissan Kicks 3,892 3,736 4,203 6,068 5,835 6,068
## 243 Nissan Leaf 774 743 836 635 610 635
## 244 Nissan Maxima 726 697 784 1,341 1,289 1,341
## 245 Nissan Murano 4,093 3,930 4,421 2,953 2,839 2,953
## 246 Nissan Pathfinder 7,819 7,506 8,445 6,417 6,170 6,417
## 247 Nissan Rogue 25,164 24,158 27,177 24,057 23,132 24,057
## 248 Nissan Sentra 7,407 7,111 7,999 11,797 11,344 11,797
## 249 Nissan Titan 1,328 1,275 1,435 2,199 2,114 2,199
## 250 Nissan Versa 1,283 1,232 1,386 2,402 2,309 2,402
## 251 Polestar Polestar 1 20 19 21 3 3 4
## 252 Polestar Polestar 2 967 928 1,044 1,119 1,208 1,163
## 253 Porsche 718 324 311 350 389 374 389
## 254 Porsche 911 803 771 867 1,060 1,019 1,060
## 255 Porsche Cayenne 1,560 1,497 1,685 1,559 1,499 1,559
## 256 Porsche Macan 2,118 2,033 2,287 2,474 2,379 2,474
## 257 Porsche Panamera 320 307 345 346 332 346
## 258 Porsche Taycan 613 589 662 552 531 552
## 259 Ram Pickup 34,655 33,268 37,427 39,743 38,214 39,743
## 260 Ram ProMaster 5,820 5,588 6,286 6,821 6,558 6,821
## 261 Ram ProMaster City 1,868 1,793 2,017 1,389 1,336 1,389
## 262 Rivian EDV 500 0 0 0 54 52 54
## 263 Rivian EDV700 173 166 187 665 639 665
## 264 Rivian R1S 74 71 80 2,063 1,984 2,063
## 265 Rivian R1T 1,135 1,089 1,226 1,473 1,416 1,473
## 266 Subaru Ascent 4,582 4,406 5,794 5,965 6,505 5,889
## 267 Subaru BRZ 332 368 285 507 638 382
## 268 Subaru CrossTrek 12,706 14,816 14,040 10,310 10,456 13,802
## 269 Subaru Forester 10,114 10,030 10,264 9,651 10,582 10,669
## 270 Subaru Impreza 2,451 2,591 3,802 3,554 3,939 2,954
## 271 Subaru Legacy 1,269 1,526 2,265 2,494 2,058 2,347
## 272 Subaru Outback 10,414 9,108 13,245 15,263 17,146 16,225
## 273 Subaru Solterra 499 347 513 603 436 574
## 274 Subaru WRX 2,006 2,598 3,005 2,667 2,771 2,326
## 275 Tesla Model 3 20,724 19,895 22,382 19,753 18,994 19,753
## 276 Tesla Model S 5,263 5,053 5,684 1,047 1,006 1,047
## 277 Tesla Model X 1,974 1,895 2,132 1,992 1,916 1,992
## 278 Tesla Model Y 27,961 26,842 30,197 35,623 34,253 35,623
## 279 Toyota 4Runner 7,945 5,684 7,487 10,354 9,979 0
## 280 Toyota Avalon 13 20 5 2 1 2
## 281 Toyota bZ4X 458 509 731 734 611 616
## 282 Toyota C-HR 346 345 59 13 6 5
## 283 Toyota Camry 16,774 24,253 25,010 27,939 28,060 28,706
## 284 Toyota Corolla 13,049 16,398 13,528 16,729 17,308 20,485
## 285 Toyota Corolla Cross 3,279 5,240 5,995 5,622 2,571 5,629
## 286 Toyota Crown 0 58 1,335 1,920 1,610 1,232
## 287 Toyota GR86 441 592 1,005 1,078 969 1,178
## 288 Toyota Grand Highlander 0 0 0 0 0 159
## 289 Toyota Highlander 14,264 18,821 22,259 19,353 20,025 18,542
## 290 Toyota Land Cruiser 1 1 1 1 0 0
## 291 Toyota Mirai 222 238 208 203 406 445
## 292 Toyota Prius 2,486 864 0 3,001 3,888 2,466
## 293 Toyota RAV4 23,419 30,027 31,258 30,386 33,677 38,250
## 294 Toyota Sequoia 1,231 1,345 1,808 1,808 1,760 0
## 295 Toyota Sienna 2,506 2,745 5,236 4,768 6,267 6,418
## 296 Toyota Supra 307 317 247 276 228 246
## 297 Toyota Tacoma 17,851 17,058 18,674 21,454 20,487 21,321
## 298 Toyota Tundra 6,473 10,320 10,858 11,748 10,561 9,775
## 299 Toyota Venza 2,888 2,419 2,159 1,749 1,570 2,292
## 300 Volkswagen Arteon 174 167 188 212 204 212
## 301 Volkswagen Atlas 3,743 3,594 4,043 4,742 4,559 4,742
## 302 Volkswagen Atlas Sport 2,280 2,189 2,462 2,794 2,686 2,794
## 303 Volkswagen Golf 490 470 529 975 937 975
## 304 Volkswagen ID.4 3,210 3,081 3,467 2,259 2,172 2,259
## 305 Volkswagen Jetta 1,505 1,444 1,625 3,934 3,782 3,934
## 306 Volkswagen Taos 4,422 4,245 4,776 4,634 4,456 4,634
## 307 Volkswagen Tiguan 6,496 6,236 7,015 6,428 6,181 6,428
## 308 Volvo 60-Series 523 603 883 527 466 1,337
## 309 Volvo 90-Series 212 154 211 192 228 201
## 310 Volvo C40 292 341 532 904 832 1,632
## 311 Volvo XC40 1,641 2,178 2,264 1,759 2,115 2,193
## 312 Volvo XC60 2,515 2,738 3,506 3,431 3,717 3,925
## 313 Volvo XC90 2,510 2,546 2,834 2,798 3,365 3,645
## Jul Aug Sep Oct Nov Dec
## 1 0 0 0 0 0 0
## 2 2,742 2,794 2,784 2,336 2,259 2,661
## 3 4,397 4,172 4,386 3,638 4,074 4,968
## 4 0 0 0 0 0 0
## 5 3,292 3,962 4,273 4,200 3,692 4,134
## 6 1,631 1,231 1,229 980 1,085 1,093
## 7 277 299 288 252 252 262
## 8 410 443 427 430 430 447
## 9 239 258 249 406 406 422
## 10 900 972 936 986 986 1,025
## 11 808 873 840 869 869 904
## 12 1,935 2,090 2,012 1,804 1,804 1,876
## 13 762 823 793 796 796 828
## 14 121 131 126 189 189 197
## 15 247 267 258 179 179 186
## 16 204 221 213 256 256 266
## 17 1,749 3 3 0 0 0
## 18 5 5 5 0 0 0
## 19 0 1,889 1,819 2,568 2,568 2,671
## 20 784 847 815 685 685 712
## 21 267 289 278 236 236 245
## 22 6,207 6,703 6,455 6,394 6,394 6,650
## 23 0 0 0 0 2,462 0
## 24 2,616 2,825 2,721 2,462 0 2,560
## 25 1,189 1,284 1,236 1,151 1,151 1,197
## 26 881 951 916 299 962 1,001
## 27 0 294 283 0 299 311
## 28 61 65 63 84 84 87
## 29 71 77 74 37 37 38
## 30 1,005 1,085 1,045 1,413 1,413 1,470
## 31 2,837 3,064 2,951 3,529 3,529 3,670
## 32 4,381 4,731 4,556 3,733 3,733 3,882
## 33 555 600 578 1,917 1,917 1,994
## 34 762 823 792 1,065 1,065 1,108
## 35 429 463 446 451 451 469
## 36 1,776 1,918 1,847 1,735 1,735 1,804
## 37 1,827 1,973 1,900 2,678 2,678 2,785
## 38 11 12 12 5 5 5
## 39 4,702 5,078 4,890 6,828 6,828 7,101
## 40 634 685 659 1,049 1,049 1,091
## 41 5,124 5,534 5,329 6,808 6,808 7,081
## 42 693 749 721 992 992 1,032
## 43 1,924 2,078 2,001 2,912 2,912 3,028
## 44 142 153 148 231 231 240
## 45 106 115 110 141 141 147
## 46 3,382 3,653 3,518 3,595 3,595 3,739
## 47 225 243 234 40 40 42
## 48 6,249 6,944 6,687 4,525 4,525 4,706
## 49 2,333 2,520 2,426 3,105 3,105 3,229
## 50 1,726 1,864 1,795 2,604 2,604 2,708
## 51 610 659 634 594 594 618
## 52 1,413 1,526 1,469 1,380 1,380 1,435
## 53 3,429 3,704 3,567 3,357 3,357 3,492
## 54 967 1,045 1,006 1,257 1,257 1,307
## 55 1,699 1,835 1,767 1,612 1,612 1,676
## 56 1,991 2,150 2,071 2,137 2,137 2,222
## 57 1,313 1,418 1,366 1,630 1,630 1,695
## 58 4,973 5,371 5,172 5,478 5,478 5,697
## 59 5,075 5,481 5,278 4,129 4,129 4,294
## 60 2,356 2,545 2,450 2,086 2,086 2,169
## 61 8,179 8,834 8,507 4,078 4,078 4,241
## 62 2,695 2,911 2,803 2,933 2,933 3,050
## 63 15,478 16,716 16,097 19,263 19,263 20,033
## 64 4,078 4,404 4,241 3,327 3,327 3,460
## 65 10,667 11,520 11,093 6,215 6,215 6,463
## 66 45,983 49,662 47,822 47,168 47,168 49,054
## 67 0 0 0 0 0 0
## 68 3,873 4,183 4,028 3,337 3,337 3,470
## 69 8,839 9,546 9,193 8,630 8,630 8,975
## 70 9,830 10,617 10,224 6,097 6,097 6,341
## 71 10,358 11,187 10,773 0 7,420 7,717
## 72 12,138 13,109 12,623 14,515 14,515 15,096
## 73 0 0 0 1 1 1
## 74 1,270 1,371 1,321 661 661 688
## 75 12,293 13,276 12,784 2,749 2,859 2,859
## 76 0 0 0 1 1 0
## 77 3,550 3,834 3,692 3,161 3,161 3,288
## 78 5,421 5,855 5,638 4,037 4,037 4,199
## 79 0 0 0 1 1 1
## 80 5,280 5,702 5,491 5,136 5,136 5,342
## 81 0 0 0 8 8 9
## 82 562 607 584 1,633 1,633 1,698
## 83 1 0 0 8 8 8
## 84 0 0 0 1 1 0
## 85 0 0 0 9 9 10
## 86 1 0 0 5 5 5
## 87 0 0 0 1 1 1
## 88 46 50 48 43 43 45
## 89 12,755 10,450 9,683 4,805 2,911 6,481
## 90 12,939 11,301 8,992 8,306 9,949 12,846
## 91 4,558 3,613 2,811 4,218 4,150 4,087
## 92 0 0 0 0 0 0
## 93 9,633 6,259 8,325 11,015 9,939 14,443
## 94 12,413 12,432 13,929 12,573 11,542 13,240
## 95 4,753 6,923 5,385 4,704 4,906 7,359
## 96 8,664 8,572 16,473 16,634 12,513 19,520
## 97 68,536 63,287 58,654 53,509 53,069 70,841
## 98 0 0 0 0 0 0
## 99 7,627 8,299 8,005 9,530 10,379 7,719
## 100 1,233 2,036 6,575 4,270 4,293 4,727
## 101 3,937 5,033 5,872 2,732 4,294 4,863
## 102 4,315 2,069 1,001 453 206 172
## 103 13,516 11,641 8,849 8,142 8,585 14,230
## 104 1,095 1,695 2,587 995 1,476 1,455
## 105 1,310 1,394 1,751 982 684 897
## 106 627 293 437 472 338 404
## 107 108 119 92 68 68 130
## 108 261 258 379 353 434 395
## 109 2,525 2,451 1,994 2,059 2,322 2,837
## 110 1,499 1,938 1,991 1,790 2,084 2,140
## 111 4,935 5,330 5,133 3,544 3,544 3,686
## 112 2,445 2,640 2,542 1,022 1,022 1,063
## 113 374 404 389 667 667 694
## 114 2,306 2,491 2,399 831 831 865
## 115 23,468 25,345 24,406 26,155 26,155 27,201
## 116 5,450 5,886 5,668 5,667 5,667 5,894
## 117 6,781 7,324 7,053 6,290 6,290 6,541
## 118 17,873 17,661 16,823 15,346 13,935 16,464
## 119 17,154 17,077 18,696 17,228 16,837 19,435
## 120 33,097 30,991 34,566 31,397 31,412 36,297
## 121 8,919 11,404 12,801 11,696 10,642 12,834
## 122 0 0 0 0 0 0
## 123 5,240 2,713 5,713 5,500 5,919 6,960
## 124 3,280 0 3,550 3,411 3,173 3,571
## 125 9,962 10,089 6,563 8,223 9,113 10,565
## 126 4,175 3,910 4,053 4,133 3,894 4,406
## 127 1 0 0 0 0 0
## 128 11,898 11,262 9,405 9,456 8,813 8,577
## 129 4,135 3,572 3,958 2,979 2,372 3,261
## 130 1,745 1,663 1,665 1,239 1,386 2,056
## 131 6,123 5,777 6,693 7,927 6,991 7,680
## 132 34 18 16 23 20 25
## 133 5,752 6,107 7,551 7,071 9,185 14,396
## 134 2,903 3,079 3,051 2,555 2,396 2,641
## 135 10,612 11,732 12,676 9,700 13,497 12,215
## 136 3,209 3,397 3,401 2,460 2,321 3,222
## 137 17,534 16,242 18,813 15,638 21,382 19,424
## 138 0 0 0 0 0 0
## 139 2,581 2,197 1,732 1,757 1,716 1,667
## 140 586 632 609 388 388 403
## 141 689 74 71 41 41 42
## 142 780 843 812 917 917 954
## 143 455 491 473 443 443 461
## 144 2,421 2,615 2,518 2,289 2,289 2,381
## 145 992 1,071 1,032 1,142 1,142 1,187
## 146 27 29 28 26 26 89
## 147 333 359 346 481 481 501
## 148 91 99 95 86 86 89
## 149 21 23 22 59 59 61
## 150 64 70 67 86 86 89
## 151 1,217 1,315 1,266 524 524 545
## 152 6,496 7,016 6,756 8,096 8,096 8,420
## 153 4,552 4,916 4,734 4,493 4,493 4,673
## 154 18,563 20,048 19,305 20,304 20,304 21,116
## 155 919 992 956 817 817 849
## 156 2,055 2,220 2,137 3,438 3,438 3,575
## 157 2,323 2,509 2,416 2,719 2,719 2,828
## 158 13,432 14,507 13,970 8,789 9,878 10,273
## 159 8 9 8 0 0 0
## 160 4 4 4 0 0 0
## 161 5,285 5,428 4,638 3,507 3,404 3,603
## 162 1,937 2,449 2,084 1,542 1,290 1,249
## 163 0 0 0 0 5 1,113
## 164 11,004 11,333 10,737 9,393 9,849 9,576
## 165 6,215 6,480 6,002 5,200 5,112 4,866
## 166 3,112 3,896 2,752 2,408 2,366 2,441
## 167 2,358 2,546 2,096 2,544 1,785 1,279
## 168 5,251 4,649 4,736 4,355 4,214 4,425
## 169 8,569 8,147 8,103 6,388 6,872 7,739
## 170 5,123 4,911 5,290 4,192 3,601 3,399
## 171 11,853 12,280 11,562 11,053 11,010 11,133
## 172 464 237 117 49 20 11
## 173 9,759 9,791 9,147 8,533 8,810 9,441
## 174 2,007 2,168 2,087 2,551 2,551 2,653
## 175 271 293 282 297 297 309
## 176 163 176 169 190 190 197
## 177 1,356 1,465 1,411 1,548 1,548 1,610
## 178 217 234 226 279 279 290
## 179 922 996 959 1,386 1,386 1,442
## 180 488 527 508 529 529 550
## 181 3,222 3,006 3,394 3,093 3,210 3,873
## 182 2,418 2,818 2,932 2,852 3,310 4,256
## 183 2,042 2,124 1,888 1,685 1,578 2,090
## 184 162 166 178 149 127 154
## 185 181 180 153 169 159 181
## 186 531 566 731 594 506 585
## 187 5,951 5,565 6,131 6,930 7,332 8,579
## 188 136 167 169 142 127 169
## 189 8,815 7,899 9,405 8,591 9,703 12,248
## 190 495 456 443 743 1,107 1,025
## 191 0 0 0 1,384 3,083 3,734
## 192 898 848 826 851 738 883
## 193 164 57 1,242 1,911 1,335 2,629
## 194 2,559 2,789 2,504 2,353 2,060 2,488
## 195 2,438 2,123 1,980 1,318 1,620 2,499
## 196 1,500 1,620 1,407 1,292 1,226 1,646
## 197 256 277 267 313 313 325
## 198 2,994 2,611 2,632 2,205 2,504 2,458
## 199 0 0 0 0 0 0
## 200 7,221 6,630 6,924 5,908 6,193 5,672
## 201 12,443 13,649 9,742 7,963 9,556 20,434
## 202 4,234 2,602 3,417 3,168 3,954 5,754
## 203 60 9 12 7 2 2
## 204 2,929 2,234 4,701 3,722 5,055 4,776
## 205 0 1,700 0 0 0 0
## 206 28 6 0 0 0 0
## 207 720 733 603 531 451 422
## 208 3 3 3 0 0 0
## 209 147 159 153 0 0 0
## 210 2,583 2,789 2,686 0 0 0
## 211 893 964 928 0 0 0
## 212 1,547 1,671 1,609 0 0 0
## 213 1,048 1,132 1,090 0 0 0
## 214 311 335 323 0 0 0
## 215 1,118 1,207 1,163 0 0 0
## 216 512 552 532 0 0 0
## 217 353 381 367 0 0 0
## 218 620 0 645 0 0 0
## 219 1,699 670 1,767 0 0 0
## 220 811 875 843 0 0 0
## 221 1,638 1,769 1,704 0 0 0
## 222 3,687 3,982 3,835 0 0 0
## 223 4,317 1,835 4,489 0 0 0
## 224 3,205 3,462 3,333 0 0 0
## 225 1,247 1,347 1,297 0 0 0
## 226 257 278 267 0 0 0
## 227 2,857 3,085 2,971 0 0 0
## 228 1,581 1,708 1,645 2,115 2,115 2,199
## 229 951 1,027 989 1,414 1,414 1,471
## 230 1,061 1,146 1,104 750 750 780
## 231 1,291 1,394 1,343 1,275 1,275 1,326
## 232 2,994 3,233 3,113 2,954 2,954 3,072
## 233 605 653 629 519 519 540
## 234 1,163 1,257 1,210 952 952 990
## 235 0 0 0 0 152 0
## 236 110 119 114 152 0 158
## 237 9,381 10,132 9,757 11,684 11,684 12,151
## 238 1,444 1,559 1,501 1,238 1,238 1,288
## 239 1,453 1,569 1,511 1,140 1,140 1,186
## 240 3,768 4,069 3,919 4,026 4,026 4,187
## 241 30 33 32 26 26 27
## 242 6,517 7,039 6,778 5,488 5,488 5,708
## 243 503 543 523 443 443 461
## 244 799 863 831 323 323 336
## 245 1,640 1,772 1,706 1,589 1,589 1,653
## 246 4,381 4,732 4,556 5,022 5,022 5,223
## 247 20,303 21,927 21,115 19,858 19,858 20,652
## 248 10,132 10,943 10,537 6,621 6,621 6,886
## 249 1,557 1,681 1,619 1,244 1,244 1,294
## 250 2,191 2,366 2,278 2,289 2,289 2,380
## 251 0 0 0 4 4 4
## 252 673 727 700 599 599 623
## 253 309 333 321 329 328 341
## 254 998 1,078 1,038 998 998 1,038
## 255 1,720 1,857 1,789 1,830 1,830 1,903
## 256 2,412 2,605 2,508 2,010 2,010 2,090
## 257 372 402 387 342 342 356
## 258 596 643 619 776 776 807
## 259 35,061 37,866 36,464 37,002 37,002 38,482
## 260 7,194 7,770 7,482 7,014 7,014 7,295
## 261 814 880 847 182 182 190
## 262 64 69 67 66 66 68
## 263 0 0 0 428 428 445
## 264 3,526 3,808 3,667 2,007 2,007 2,087
## 265 2,628 2,838 2,733 1,118 1,118 1,163
## 266 4,281 4,860 4,599 4,374 4,292 4,996
## 267 311 268 270 291 263 273
## 268 11,241 13,920 13,341 13,768 14,994 15,799
## 269 14,504 15,294 15,237 15,479 15,089 15,653
## 270 2,800 2,205 2,868 2,662 2,370 2,523
## 271 2,170 2,765 2,727 2,172 1,838 1,878
## 272 12,430 14,503 14,545 12,396 12,233 14,304
## 273 758 915 1,118 1,210 943 956
## 274 1,894 1,677 1,630 1,420 1,305 1,382
## 275 16,667 18,000 17,333 0 0 0
## 276 1,090 1,177 1,133 0 0 0
## 277 1,795 1,938 1,867 0 0 0
## 278 30,128 32,538 31,333 0 0 0
## 279 11,206 12,569 12,083 10,344 10,025 12,275
## 280 0 8 1 3 0 0
## 281 714 931 1,182 1,326 848 669
## 282 0 1 1 0 0 1
## 283 25,110 16,638 25,485 24,596 22,673 25,405
## 284 21,382 24,134 22,679 22,272 21,005 23,400
## 285 7,472 6,322 7,030 7,446 0 7,484
## 286 2,060 2,418 2,421 1,907 1,831 2,271
## 287 1,371 1,143 960 794 757 790
## 288 5,377 0 10,177 7,571 7,735 8,354
## 289 8,590 8,663 9,407 9,536 9,499 12,330
## 290 0 1 0 0 0 1
## 291 463 287 132 57 53 23
## 292 3,940 4,667 4,342 1,452 3,532 5,178
## 293 37,821 39,895 38,098 42,226 42,842 47,044
## 294 1,639 2,445 2,129 1,976 1,948 2,468
## 295 6,158 7,344 6,311 0 6,594 0
## 296 157 134 185 85 225 245
## 297 20,126 22,131 20,579 17,456 18,156 19,475
## 298 10,457 11,235 11,261 10,330 9,654 12,513
## 299 2,790 3,030 3,190 2,896 2,369 2,555
## 300 219 237 228 167 167 174
## 301 5,156 5,569 5,362 6,365 6,365 6,619
## 302 2,827 3,053 2,940 3,549 3,549 3,691
## 303 1,216 1,313 1,265 829 829 862
## 304 3,432 3,706 3,569 3,498 3,498 3,638
## 305 4,594 4,961 4,777 5,543 5,543 5,765
## 306 5,262 5,683 5,472 5,035 5,035 5,236
## 307 5,421 5,855 5,638 6,753 6,753 7,023
## 308 722 944 1,501 1,775 1,742 1,296
## 309 176 120 141 147 134 112
## 310 564 359 330 304 284 215
## 311 2,443 2,495 2,540 2,764 2,684 3,067
## 312 3,161 2,946 3,211 3,307 3,170 4,075
## 313 3,719 3,780 3,223 2,999 3,657 4,844Then extract Brand name from Model for better calculating.
rawdata1$Model <- as.character(rawdata1$Model)
rawdata1$Brand <- sapply(strsplit(rawdata1$Model, " "), function(x) x[1])
rawdata1 <- rawdata1[, c("Brand", names(rawdata1)[-which(names(rawdata1) == "Brand")])]
rawdata1## Brand Model Jan Feb Mar Apr
## 1 Acura Acura ILX 1 1 0 0
## 2 Acura Acura Integra 2,191 2,503 3,012 3,394
## 3 Acura Acura MDX 4,455 4,692 6,076 5,758
## 4 Acura Acura NSX 3 1 1 0
## 5 Acura Acura RDX 1,848 2,090 2,871 2,573
## 6 Acura Acura TLX 990 1,121 1,609 1,576
## 7 Alfa Alfa Romeo Giulia 318 305 343 292
## 8 Alfa Alfa Romeo Stelvio 468 450 506 448
## 9 Alfa Alfa Romeo Tonale 0 0 0 40
## 10 Audi Audi A3 1,338 1,285 1,445 1,267
## 11 Audi Audi A4 1,723 1,654 1,681 1,063
## 12 Audi Audi A5 1,841 1,768 1,989 2,248
## 13 Audi Audi A6 653 627 705 518
## 14 Audi Audi A7 179 172 193 105
## 15 Audi Audi A8 128 123 138 187
## 16 Audi Audi e-Tron GT 239 229 258 358
## 17 Audi Audi e-Tron Sportback 159 152 374 107
## 18 Audi Audi eTron 346 333 171 223
## 19 Audi Audi Q3 1,268 1,217 1,370 1,712
## 20 Audi Audi Q4 e-tron 551 529 595 656
## 21 Audi Audi Q4 e-tron Sportback 165 159 179 187
## 22 Audi Audi Q5 5,620 5,395 6,070 6,164
## 23 Audi Audi Q6 0 0 0 0
## 24 Audi Audi Q7 2,112 2,028 2,281 2,318
## 25 Audi Audi Q8 941 903 1,016 1,175
## 26 Audi Audi Q8 e-Tron 0 0 0 263
## 27 Audi Audi Q8 Sportback e-tron 0 0 0 115
## 28 Audi Audi R8 32 31 34 30
## 29 Audi Audi TT 60 58 65 70
## 30 BMW BMW 2-Series 455 437 491 947
## 31 BMW BMW 3-Series 2,162 2,075 2,334 2,588
## 32 BMW BMW 4-Series 3,946 3,789 4,262 4,648
## 33 BMW BMW 5-Series 2,479 2,380 2,677 2,466
## 34 BMW BMW 7-Series 949 911 1,025 780
## 35 BMW BMW 8-Series 517 496 558 497
## 36 BMW BMW iX 773 742 835 1,396
## 37 BMW BMW X1 1,043 1,001 1,127 1,361
## 38 BMW BMW X2 26 25 28 21
## 39 BMW BMW X3 4,970 4,771 5,367 4,267
## 40 BMW BMW X4 808 776 873 646
## 41 BMW BMW X5 5,696 5,468 6,151 6,272
## 42 BMW BMW X6 752 722 812 882
## 43 BMW BMW X7 2,227 2,138 2,405 2,422
## 44 BMW BMW XM 0 0 0 257
## 45 BMW BMW Z4 131 126 141 244
## 46 Buick Buick Enclave 2,896 2,780 3,127 3,082
## 47 Buick Buick Encore 980 941 1,058 704
## 48 Buick Buick Encore GX 4,039 3,878 4,362 6,096
## 49 Buick Buick Envision 4,631 4,445 5,001 4,554
## 50 Buick Buick Envista 0 0 0 0
## 51 Cadillac Cadillac CT4 892 856 963 920
## 52 Cadillac Cadillac CT5 1,511 1,450 1,632 1,822
## 53 Cadillac Cadillac Escalade 3,036 2,914 3,278 3,902
## 54 Cadillac Cadillac Lyriq 318 306 344 455
## 55 Cadillac Cadillac XT4 2,228 2,139 2,406 1,936
## 56 Cadillac Cadillac XT5 2,396 2,301 2,588 2,301
## 57 Cadillac Cadillac XT6 1,566 1,504 1,692 1,791
## 58 Chevrolet Chevrolet Blazer 5,021 4,820 5,422 6,105
## 59 Chevrolet Chevrolet Bolt 6,480 6,221 6,999 4,713
## 60 Chevrolet Chevrolet Camaro 2,559 2,457 2,764 3,227
## 61 Chevrolet Chevrolet Colorado 4,361 4,186 4,708 6,723
## 62 Chevrolet Chevrolet Corvette 2,600 2,496 2,808 3,081
## 63 Chevrolet Chevrolet Equinox 17,402 16,706 18,794 17,879
## 64 Chevrolet Chevrolet Express 2,827 2,714 3,053 3,116
## 65 Chevrolet Chevrolet Malibu 12,315 11,823 13,300 13,753
## 66 Chevrolet Chevrolet Silverado 41,774 40,103 45,116 47,711
## 67 Chevrolet Chevrolet Spark 49 47 53 0
## 68 Chevrolet Chevrolet Suburban 4,583 4,400 4,950 5,626
## 69 Chevrolet Chevrolet Tahoe 8,966 8,607 9,683 9,879
## 70 Chevrolet Chevrolet TrailBlazer 9,194 8,827 9,930 11,432
## 71 Chevrolet Chevrolet Traverse 10,373 9,958 11,203 12,543
## 72 Chevrolet Chevrolet Trax 2,127 2,042 2,297 7,064
## 73 Chrysler Chrysler 200 0 0 0 0
## 74 Chrysler Chrysler 300 983 944 1,062 1,421
## 75 Chrysler Chrysler Pacifica 9,510 9,129 10,271 15,173
## 76 Chrysler Chrysler Town and Country 0 0 0 0
## 77 Dodge Dodge Challenger 3,740 3,591 4,040 4,357
## 78 Dodge Dodge Charger 7,279 6,988 7,861 8,308
## 79 Dodge Dodge Dart 0 0 0 0
## 80 Dodge Dodge Durango 5,746 5,516 6,205 6,632
## 81 Dodge Dodge Grand Caravan 0 0 0 0
## 82 Dodge Dodge Hornet 0 0 0 877
## 83 Dodge Dodge Journey 3 3 3 0
## 84 Dodge Dodge Viper 0 0 0 0
## 85 Fiat Fiat 124 Spider 0 0 0 0
## 86 Fiat Fiat 500 0 0 0 0
## 87 Fiat Fiat 500L 1 1 1 0
## 88 Fiat Fiat 500X 44 43 48 48
## 89 Ford Ford Bronco 10,170 12,113 10,147 9,483
## 90 Ford Ford Bronco Sport 9,438 8,908 11,525 11,526
## 91 Ford Ford E-Series 2,848 3,514 4,423 3,183
## 92 Ford Ford EcoSport 575 624 450 320
## 93 Ford Ford Edge 4,969 6,513 8,800 11,034
## 94 Ford Ford Escape 7,878 6,447 6,824 17,133
## 95 Ford Ford Expedition 5,693 6,899 6,767 6,255
## 96 Ford Ford Explorer 15,617 19,174 23,270 18,327
## 97 Ford Ford F-Series 55,001 54,995 60,381 69,595
## 98 Ford Ford GT 6 12 12 1
## 99 Ford Ford Maverick 6,272 7,648 7,558 6,583
## 100 Ford Ford Mustang 4,004 4,959 10,302 5,141
## 101 Ford Ford Mustang Mach E 2,626 1,783 998 1,606
## 102 Ford Ford Ranger 2,871 3,962 4,667 4,201
## 103 Ford Ford Transit 10,129 11,208 10,678 9,406
## 104 Ford Ford Transit Connect 1,165 1,459 1,199 2,146
## 105 Genesis Genesis G70 804 719 1,057 1,139
## 106 Genesis Genesis G80 226 172 611 383
## 107 Genesis Genesis G90 105 111 140 120
## 108 Genesis Genesis GV60 129 171 212 267
## 109 Genesis Genesis GV70 1,401 1,762 2,145 2,219
## 110 Genesis Genesis GV80 1,207 1,241 1,491 1,474
## 111 GMC GMC Acadia 5,245 5,035 5,665 8,173
## 112 GMC GMC Canyon 1,650 1,584 1,782 2,265
## 113 GMC GMC Hummer EV 1 1 0 32
## 114 GMC GMC Savana 1,578 1,515 1,704 2,454
## 115 GMC GMC Sierra 22,105 21,220 23,873 25,598
## 116 GMC GMC Terrain 5,897 5,661 6,369 6,651
## 117 GMC GMC Yukon 6,488 6,228 7,007 7,519
## 118 Honda Honda Accord 14,737 11,509 16,560 19,297
## 119 Honda Honda Civic 13,313 14,812 17,423 16,317
## 120 Honda Honda CR-V 20,031 16,126 31,084 31,776
## 121 Honda Honda HR-V 8,013 8,371 10,120 8,970
## 122 Honda Honda Insight 0 0 0 0
## 123 Honda Honda Odyssey 5,609 6,262 8,031 7,314
## 124 Honda Honda Passport 3,212 3,839 4,368 4,255
## 125 Honda Honda Pilot 6,950 7,271 10,483 9,949
## 126 Honda Honda Ridgeline 3,161 4,649 5,108 4,903
## 127 Hyundai Hyundai Accent 16 12 2 0
## 128 Hyundai Hyundai Elantra 8,655 10,371 13,447 13,236
## 129 Hyundai Hyundai Ioniq 5 1,548 2,074 2,114 2,323
## 130 Hyundai Hyundai Ioniq 6 0 0 222 890
## 131 Hyundai Hyundai Kona 5,826 6,080 7,314 6,831
## 132 Hyundai Hyundai Nexo 16 28 21 16
## 133 Hyundai Hyundai Palisade 6,684 6,742 6,176 6,959
## 134 Hyundai Hyundai Santa Cruz 2,614 2,868 3,825 3,590
## 135 Hyundai Hyundai Santa Fe 7,297 7,993 13,236 10,953
## 136 Hyundai Hyundai Sonata 4,873 4,307 5,310 0
## 137 Hyundai Hyundai Tuscon 12,028 14,031 20,111 18,676
## 138 Hyundai Hyundai Veloster 3 1 1 1
## 139 Hyundai Hyundai Venue 2,441 2,537 3,625 2,648
## 140 Infiniti Infiniti Q50 449 431 485 618
## 141 Infiniti Infiniti Q60 123 118 133 118
## 142 Infiniti Infiniti QX50 766 736 828 806
## 143 Infiniti Infiniti QX55 449 431 485 434
## 144 Infiniti Infiniti QX60 2,348 2,254 2,536 2,610
## 145 Infiniti Infiniti QX80 1,047 1,005 1,131 995
## 146 Jaguar Jaguar E-Pace 83 80 90 17
## 147 Jaguar Jaguar F-Pace 530 509 572 387
## 148 Jaguar Jaguar F-Type 119 115 129 71
## 149 Jaguar Jaguar I-Pace 32 31 35 56
## 150 Jaguar Jaguar XF 85 82 92 72
## 151 Jeep Jeep Cherokee 4,346 4,173 4,694 2,028
## 152 Jeep Jeep Compass 7,635 7,329 8,245 9,483
## 153 Jeep Jeep Gladiator 4,465 4,287 4,823 4,643
## 154 Jeep Jeep Grand Cherokee 17,928 17,211 19,363 23,790
## 155 Jeep Jeep Grand Wagoneer 0 645 726 1,089
## 156 Jeep Jeep Renegade 1,358 1,304 1,467 1,695
## 157 Jeep Jeep Wagoneer 1,829 1,756 1,975 2,727
## 158 Jeep Jeep Wrangler 12,490 11,991 13,490 15,759
## 159 Karma Karma GS-6 30 28 32 14
## 160 Karma Karma Revero 13 13 14 2
## 161 Kia Kia Carnival 1,662 2,460 3,009 3,029
## 162 Kia Kia EV6 1,110 1,294 988 1,241
## 163 Kia Kia EV9 0 0 0 0
## 164 Kia Kia Forte 8,190 10,445 11,891 11,182
## 165 Kia Kia K5 3,368 5,146 5,774 5,035
## 166 Kia Kia Niro 3,713 3,378 2,736 2,999
## 167 Kia Kia Rio 2,184 2,385 2,436 2,792
## 168 Kia Kia Seltos 3,994 3,744 6,156 5,428
## 169 Kia Kia Sorento 6,288 7,012 6,886 6,965
## 170 Kia Kia Soul 4,844 5,233 6,907 6,590
## 171 Kia Kia Sportage 8,602 10,117 12,965 13,426
## 172 Kia Kia Stinger 466 622 958 963
## 173 Kia Kia Telluride 7,582 9,023 10,585 8,555
## 174 Land Land Rover Defender 1,232 1,183 1,330 1,165
## 175 Land Land Rover Discovery / LR4 127 122 137 95
## 176 Land Land Rover Discovery Sport 466 448 504 1,395
## 177 Land Land Rover Range Rover 961 922 1,037 1,395
## 178 Land Land Rover Range Rover Evoque 514 493 555 232
## 179 Land Land Rover Range Rover Sport 880 845 951 565
## 180 Land Land Rover Range Rover Velar 694 666 750 557
## 181 Lexus Lexus ES 2,199 2,712 3,768 3,611
## 182 Lexus Lexus GX 2,095 1,803 2,472 2,300
## 183 Lexus Lexus IS 1,661 1,668 2,032 2,061
## 184 Lexus Lexus LC 114 152 167 132
## 185 Lexus Lexus LS 179 166 234 220
## 186 Lexus Lexus LX 156 444 972 776
## 187 Lexus Lexus NX 5,093 4,662 5,801 5,320
## 188 Lexus Lexus RC 120 128 132 154
## 189 Lexus Lexus RX 7,957 8,646 9,344 10,869
## 190 Lexus Lexus RZ 0 0 185 302
## 191 Lexus Lexus TX 0 0 0 0
## 192 Lexus Lexus UX 868 1,074 1,250 1,426
## 193 Lincoln Lincoln Aviator 1,174 1,821 2,241 1,901
## 194 Lincoln Lincoln Corsair / MKC 1,617 1,361 1,045 852
## 195 Lincoln Lincoln MKX/Nautilus 1,608 1,361 2,162 2,489
## 196 Lincoln Lincoln Navigator 1,409 1,242 1,519 1,441
## 197 Lucid Lucid Air 260 249 281 203
## 198 Mazda Mazda 3 1,577 2,846 2,872 2,619
## 199 Mazda Mazda 6 0 0 1,690 0
## 200 Mazda Mazda CX-30 5,065 8,026 6,779 5,954
## 201 Mazda Mazda CX-5 9,833 12,282 16,612 14,333
## 202 Mazda Mazda CX-50 2,589 3,165 4,010 4,305
## 203 Mazda Mazda CX-9 3,170 3,515 3,151 3,311
## 204 Mazda Mazda CX-90 0 20 267 845
## 205 Mazda Mazda CX-90P 0 0 0 0
## 206 Mazda Mazda MX-30 9 2 4 17
## 207 Mazda Mazda MX-5 Miata 724 783 1,083 967
## 208 Mercedes-Benz Mercedes-Benz A-Class 41 40 45 8
## 209 Mercedes-Benz Mercedes-Benz AMG GT 210 202 227 240
## 210 Mercedes-Benz Mercedes-Benz C-Class 2,455 2,357 2,652 2,912
## 211 Mercedes-Benz Mercedes-Benz CLA-Class 832 799 899 851
## 212 Mercedes-Benz Mercedes-Benz E / CLS-Class 0 957 1,077 1,293
## 213 Mercedes-Benz Mercedes-Benz EQB 506 485 546 630
## 214 Mercedes-Benz Mercedes-Benz EQE Sedan 0 0 384 568
## 215 Mercedes-Benz Mercedes-Benz EQE SUV 0 0 0 961
## 216 Mercedes-Benz Mercedes-Benz EQS SUV 794 762 740 1,039
## 217 Mercedes-Benz Mercedes-Benz EQS-Sedan 685 658 857 829
## 218 Mercedes-Benz Mercedes-Benz G-Class 882 847 953 1,043
## 219 Mercedes-Benz Mercedes-Benz GL/GLS-Class 1,849 1,775 1,997 1,885
## 220 Mercedes-Benz Mercedes-Benz GLA-Class 1,398 1,342 1,510 1,712
## 221 Mercedes-Benz Mercedes-Benz GLB 1,415 1,359 1,528 1,219
## 222 Mercedes-Benz Mercedes-Benz GLC/GLK-Class 1,200 1,152 1,296 4,812
## 223 Mercedes-Benz Mercedes-Benz GLE-Class 5,234 5,024 5,652 4,650
## 224 Mercedes-Benz Mercedes-Benz Metris 1,372 1,317 1,481 2,273
## 225 Mercedes-Benz Mercedes-Benz S-Class 1,009 969 1,090 1,068
## 226 Mercedes-Benz Mercedes-Benz SL-Class 302 290 326 366
## 227 Mercedes-Benz Mercedes-Benz Sprinter 3,289 3,158 3,553 4,052
## 228 Mini Mini Cooper 1,479 1,420 1,597 1,727
## 229 Mini Mini Countryman 917 880 990 834
## 230 Mitsubishi Mitsubishi Eclipse Cross 517 496 558 932
## 231 Mitsubishi Mitsubishi Mirage 1,099 1,055 1,187 667
## 232 Mitsubishi Mitsubishi Outlander 3,228 3,099 3,487 4,852
## 233 Mitsubishi Mitsubishi Outlander PHEV 525 504 567 547
## 234 Mitsubishi Mitsubishi Outlander Sport 1,517 1,457 1,639 1,310
## 235 Nissan Nissan 350Z 0 0 0 0
## 236 Nissan Nissan 370Z 153 147 166 169
## 237 Nissan Nissan Altima 10,800 10,368 11,664 10,268
## 238 Nissan Nissan Ariya 941 903 1,016 788
## 239 Nissan Nissan Armada 2,392 2,296 2,583 1,997
## 240 Nissan Nissan Frontier 5,568 5,345 6,013 5,812
## 241 Nissan Nissan GT-R 47 45 51 25
## 242 Nissan Nissan Kicks 3,892 3,736 4,203 6,068
## 243 Nissan Nissan Leaf 774 743 836 635
## 244 Nissan Nissan Maxima 726 697 784 1,341
## 245 Nissan Nissan Murano 4,093 3,930 4,421 2,953
## 246 Nissan Nissan Pathfinder 7,819 7,506 8,445 6,417
## 247 Nissan Nissan Rogue 25,164 24,158 27,177 24,057
## 248 Nissan Nissan Sentra 7,407 7,111 7,999 11,797
## 249 Nissan Nissan Titan 1,328 1,275 1,435 2,199
## 250 Nissan Nissan Versa 1,283 1,232 1,386 2,402
## 251 Polestar Polestar Polestar 1 20 19 21 3
## 252 Polestar Polestar Polestar 2 967 928 1,044 1,119
## 253 Porsche Porsche 718 324 311 350 389
## 254 Porsche Porsche 911 803 771 867 1,060
## 255 Porsche Porsche Cayenne 1,560 1,497 1,685 1,559
## 256 Porsche Porsche Macan 2,118 2,033 2,287 2,474
## 257 Porsche Porsche Panamera 320 307 345 346
## 258 Porsche Porsche Taycan 613 589 662 552
## 259 Ram Ram Pickup 34,655 33,268 37,427 39,743
## 260 Ram Ram ProMaster 5,820 5,588 6,286 6,821
## 261 Ram Ram ProMaster City 1,868 1,793 2,017 1,389
## 262 Rivian Rivian EDV 500 0 0 0 54
## 263 Rivian Rivian EDV700 173 166 187 665
## 264 Rivian Rivian R1S 74 71 80 2,063
## 265 Rivian Rivian R1T 1,135 1,089 1,226 1,473
## 266 Subaru Subaru Ascent 4,582 4,406 5,794 5,965
## 267 Subaru Subaru BRZ 332 368 285 507
## 268 Subaru Subaru CrossTrek 12,706 14,816 14,040 10,310
## 269 Subaru Subaru Forester 10,114 10,030 10,264 9,651
## 270 Subaru Subaru Impreza 2,451 2,591 3,802 3,554
## 271 Subaru Subaru Legacy 1,269 1,526 2,265 2,494
## 272 Subaru Subaru Outback 10,414 9,108 13,245 15,263
## 273 Subaru Subaru Solterra 499 347 513 603
## 274 Subaru Subaru WRX 2,006 2,598 3,005 2,667
## 275 Tesla Tesla Model 3 20,724 19,895 22,382 19,753
## 276 Tesla Tesla Model S 5,263 5,053 5,684 1,047
## 277 Tesla Tesla Model X 1,974 1,895 2,132 1,992
## 278 Tesla Tesla Model Y 27,961 26,842 30,197 35,623
## 279 Toyota Toyota 4Runner 7,945 5,684 7,487 10,354
## 280 Toyota Toyota Avalon 13 20 5 2
## 281 Toyota Toyota bZ4X 458 509 731 734
## 282 Toyota Toyota C-HR 346 345 59 13
## 283 Toyota Toyota Camry 16,774 24,253 25,010 27,939
## 284 Toyota Toyota Corolla 13,049 16,398 13,528 16,729
## 285 Toyota Toyota Corolla Cross 3,279 5,240 5,995 5,622
## 286 Toyota Toyota Crown 0 58 1,335 1,920
## 287 Toyota Toyota GR86 441 592 1,005 1,078
## 288 Toyota Toyota Grand Highlander 0 0 0 0
## 289 Toyota Toyota Highlander 14,264 18,821 22,259 19,353
## 290 Toyota Toyota Land Cruiser 1 1 1 1
## 291 Toyota Toyota Mirai 222 238 208 203
## 292 Toyota Toyota Prius 2,486 864 0 3,001
## 293 Toyota Toyota RAV4 23,419 30,027 31,258 30,386
## 294 Toyota Toyota Sequoia 1,231 1,345 1,808 1,808
## 295 Toyota Toyota Sienna 2,506 2,745 5,236 4,768
## 296 Toyota Toyota Supra 307 317 247 276
## 297 Toyota Toyota Tacoma 17,851 17,058 18,674 21,454
## 298 Toyota Toyota Tundra 6,473 10,320 10,858 11,748
## 299 Toyota Toyota Venza 2,888 2,419 2,159 1,749
## 300 Volkswagen Volkswagen Arteon 174 167 188 212
## 301 Volkswagen Volkswagen Atlas 3,743 3,594 4,043 4,742
## 302 Volkswagen Volkswagen Atlas Sport 2,280 2,189 2,462 2,794
## 303 Volkswagen Volkswagen Golf 490 470 529 975
## 304 Volkswagen Volkswagen ID.4 3,210 3,081 3,467 2,259
## 305 Volkswagen Volkswagen Jetta 1,505 1,444 1,625 3,934
## 306 Volkswagen Volkswagen Taos 4,422 4,245 4,776 4,634
## 307 Volkswagen Volkswagen Tiguan 6,496 6,236 7,015 6,428
## 308 Volvo Volvo 60-Series 523 603 883 527
## 309 Volvo Volvo 90-Series 212 154 211 192
## 310 Volvo Volvo C40 292 341 532 904
## 311 Volvo Volvo XC40 1,641 2,178 2,264 1,759
## 312 Volvo Volvo XC60 2,515 2,738 3,506 3,431
## 313 Volvo Volvo XC90 2,510 2,546 2,834 2,798
## May Jun Jul Aug Sep Oct Nov Dec
## 1 0 0 0 0 0 0 0 0
## 2 2,806 2,608 2,742 2,794 2,784 2,336 2,259 2,661
## 3 5,935 5,048 4,397 4,172 4,386 3,638 4,074 4,968
## 4 0 0 0 0 0 0 0 0
## 5 2,791 3,502 3,292 3,962 4,273 4,200 3,692 4,134
## 6 2,173 2,013 1,631 1,231 1,229 980 1,085 1,093
## 7 281 292 277 299 288 252 252 262
## 8 431 448 410 443 427 430 430 447
## 9 38 40 239 258 249 406 406 422
## 10 1,219 1,267 900 972 936 986 986 1,025
## 11 1,022 1,063 808 873 840 869 869 904
## 12 2,162 2,278 1,935 2,090 2,012 1,804 1,804 1,876
## 13 498 518 762 823 793 796 796 828
## 14 101 105 121 131 126 189 189 197
## 15 180 187 247 267 258 179 179 186
## 16 344 358 204 221 213 256 256 266
## 17 103 107 1,749 3 3 0 0 0
## 18 214 223 5 5 5 0 0 0
## 19 1,646 1,712 0 1,889 1,819 2,568 2,568 2,671
## 20 631 656 784 847 815 685 685 712
## 21 180 187 267 289 278 236 236 245
## 22 5,927 6,164 6,207 6,703 6,455 6,394 6,394 6,650
## 23 0 0 0 0 0 0 2,462 0
## 24 2,229 2,318 2,616 2,825 2,721 2,462 0 2,560
## 25 1,130 1,175 1,189 1,284 1,236 1,151 1,151 1,197
## 26 253 263 881 951 916 299 962 1,001
## 27 110 115 0 294 283 0 299 311
## 28 29 30 61 65 63 84 84 87
## 29 68 70 71 77 74 37 37 38
## 30 911 947 1,005 1,085 1,045 1,413 1,413 1,470
## 31 2,489 2,588 2,837 3,064 2,951 3,529 3,529 3,670
## 32 4,469 4,648 4,381 4,731 4,556 3,733 3,733 3,882
## 33 2,371 2,466 555 600 578 1,917 1,917 1,994
## 34 750 780 762 823 792 1,065 1,065 1,108
## 35 478 497 429 463 446 451 451 469
## 36 1,343 1,396 1,776 1,918 1,847 1,735 1,735 1,804
## 37 1,309 1,361 1,827 1,973 1,900 2,678 2,678 2,785
## 38 20 21 11 12 12 5 5 5
## 39 4,103 4,267 4,702 5,078 4,890 6,828 6,828 7,101
## 40 621 646 634 685 659 1,049 1,049 1,091
## 41 6,031 6,272 5,124 5,534 5,329 6,808 6,808 7,081
## 42 848 882 693 749 721 992 992 1,032
## 43 2,329 2,422 1,924 2,078 2,001 2,912 2,912 3,028
## 44 247 257 142 153 148 231 231 240
## 45 235 244 106 115 110 141 141 147
## 46 2,963 3,082 3,382 3,653 3,518 3,595 3,595 3,739
## 47 677 704 225 243 234 40 40 42
## 48 5,862 6,096 6,249 6,944 6,687 4,525 4,525 4,706
## 49 4,379 4,554 2,333 2,520 2,426 3,105 3,105 3,229
## 50 0 0 1,726 1,864 1,795 2,604 2,604 2,708
## 51 884 920 610 659 634 594 594 618
## 52 1,752 1,822 1,413 1,526 1,469 1,380 1,380 1,435
## 53 3,752 3,902 3,429 3,704 3,567 3,357 3,357 3,492
## 54 438 455 967 1,045 1,006 1,257 1,257 1,307
## 55 1,862 1,936 1,699 1,835 1,767 1,612 1,612 1,676
## 56 2,213 2,301 1,991 2,150 2,071 2,137 2,137 2,222
## 57 1,722 1,791 1,313 1,418 1,366 1,630 1,630 1,695
## 58 5,870 6,105 4,973 5,371 5,172 5,478 5,478 5,697
## 59 4,532 4,713 5,075 5,481 5,278 4,129 4,129 4,294
## 60 3,103 3,227 2,356 2,545 2,450 2,086 2,086 2,169
## 61 6,464 6,723 8,179 8,834 8,507 4,078 4,078 4,241
## 62 2,963 3,081 2,695 2,911 2,803 2,933 2,933 3,050
## 63 17,191 17,879 15,478 16,716 16,097 19,263 19,263 20,033
## 64 2,996 3,116 4,078 4,404 4,241 3,327 3,327 3,460
## 65 13,224 13,753 10,667 11,520 11,093 6,215 6,215 6,463
## 66 45,876 47,711 45,983 49,662 47,822 47,168 47,168 49,054
## 67 0 0 0 0 0 0 0 0
## 68 5,409 5,626 3,873 4,183 4,028 3,337 3,337 3,470
## 69 9,499 9,879 8,839 9,546 9,193 8,630 8,630 8,975
## 70 10,993 11,432 9,830 10,617 10,224 6,097 6,097 6,341
## 71 12,061 12,543 10,358 11,187 10,773 0 7,420 7,717
## 72 6,793 7,064 12,138 13,109 12,623 14,515 14,515 15,096
## 73 0 0 0 0 0 1 1 1
## 74 1,366 1,421 1,270 1,371 1,321 661 661 688
## 75 14,589 15,173 12,293 13,276 12,784 2,749 2,859 2,859
## 76 0 0 0 0 0 1 1 0
## 77 4,190 4,357 3,550 3,834 3,692 3,161 3,161 3,288
## 78 7,988 8,308 5,421 5,855 5,638 4,037 4,037 4,199
## 79 0 0 0 0 0 1 1 1
## 80 6,377 6,632 5,280 5,702 5,491 5,136 5,136 5,342
## 81 0 0 0 0 0 8 8 9
## 82 843 877 562 607 584 1,633 1,633 1,698
## 83 0 0 1 0 0 8 8 8
## 84 0 0 0 0 0 1 1 0
## 85 0 0 0 0 0 9 9 10
## 86 0 0 1 0 0 5 5 5
## 87 0 0 0 0 0 1 1 1
## 88 46 48 46 50 48 43 43 45
## 89 8,211 8,456 12,755 10,450 9,683 4,805 2,911 6,481
## 90 10,594 11,152 12,939 11,301 8,992 8,306 9,949 12,846
## 91 2,732 2,820 4,558 3,613 2,811 4,218 4,150 4,087
## 92 250 289 0 0 0 0 0 0
## 93 7,685 7,483 9,633 6,259 8,325 11,015 9,939 14,443
## 94 11,733 14,824 12,413 12,432 13,929 12,573 11,542 13,240
## 95 6,782 6,970 4,753 6,923 5,385 4,704 4,906 7,359
## 96 14,531 13,474 8,664 8,572 16,473 16,634 12,513 19,520
## 97 70,566 72,355 68,536 63,287 58,654 53,509 53,069 70,841
## 98 0 0 0 0 0 0 0 0
## 99 6,965 7,473 7,627 8,299 8,005 9,530 10,379 7,719
## 100 3,559 2,060 1,233 2,036 6,575 4,270 4,293 4,727
## 101 2,917 4,110 3,937 5,033 5,872 2,732 4,294 4,863
## 102 4,002 4,415 4,315 2,069 1,001 453 206 172
## 103 11,282 11,343 13,516 11,641 8,849 8,142 8,585 14,230
## 104 1,270 1,508 1,095 1,695 2,587 995 1,476 1,455
## 105 1,156 1,353 1,310 1,394 1,751 982 684 897
## 106 490 887 627 293 437 472 338 404
## 107 113 114 108 119 92 68 68 130
## 108 276 265 261 258 379 353 434 395
## 109 2,234 1,878 2,525 2,451 1,994 2,059 2,322 2,837
## 110 1,336 1,506 1,499 1,938 1,991 1,790 2,084 2,140
## 111 7,859 8,173 4,935 5,330 5,133 3,544 3,544 3,686
## 112 2,178 2,265 2,445 2,640 2,542 1,022 1,022 1,063
## 113 15 16 374 404 389 667 667 694
## 114 2,360 2,454 2,306 2,491 2,399 831 831 865
## 115 24,614 25,598 23,468 25,345 24,406 26,155 26,155 27,201
## 116 6,395 6,651 5,450 5,886 5,668 5,667 5,667 5,894
## 117 7,230 7,519 6,781 7,324 7,053 6,290 6,290 6,541
## 118 20,007 17,735 17,873 17,661 16,823 15,346 13,935 16,464
## 119 16,110 15,979 17,154 17,077 18,696 17,228 16,837 19,435
## 120 33,521 31,159 33,097 30,991 34,566 31,397 31,412 36,297
## 121 9,300 9,136 8,919 11,404 12,801 11,696 10,642 12,834
## 122 1 0 0 0 0 0 0 0
## 123 7,011 5,239 5,240 2,713 5,713 5,500 5,919 6,960
## 124 4,420 3,710 3,280 0 3,550 3,411 3,173 3,571
## 125 10,439 10,691 9,962 10,089 6,563 8,223 9,113 10,565
## 126 4,931 4,678 4,175 3,910 4,053 4,133 3,894 4,406
## 127 0 0 1 0 0 0 0 0
## 128 15,605 13,424 11,898 11,262 9,405 9,456 8,813 8,577
## 129 2,446 3,136 4,135 3,572 3,958 2,979 2,372 3,261
## 130 971 1,162 1,745 1,663 1,665 1,239 1,386 2,056
## 131 5,613 6,261 6,123 5,777 6,693 7,927 6,991 7,680
## 132 16 8 34 18 16 23 20 25
## 133 7,013 5,873 5,752 6,107 7,551 7,071 9,185 14,396
## 134 3,526 3,627 2,903 3,079 3,051 2,555 2,396 2,641
## 135 10,039 11,624 10,612 11,732 12,676 9,700 13,497 12,215
## 136 4,321 3,834 3,209 3,397 3,401 2,460 2,321 3,222
## 137 18,038 17,707 17,534 16,242 18,813 15,638 21,382 19,424
## 138 0 0 0 0 0 0 0 0
## 139 2,413 2,695 2,581 2,197 1,732 1,757 1,716 1,667
## 140 594 618 586 632 609 388 388 403
## 141 113 118 689 74 71 41 41 42
## 142 775 806 780 843 812 917 917 954
## 143 418 434 455 491 473 443 443 461
## 144 2,510 2,610 2,421 2,615 2,518 2,289 2,289 2,381
## 145 957 995 992 1,071 1,032 1,142 1,142 1,187
## 146 16 17 27 29 28 26 26 89
## 147 372 387 333 359 346 481 481 501
## 148 68 71 91 99 95 86 86 89
## 149 54 56 21 23 22 59 59 61
## 150 69 72 64 70 67 86 86 89
## 151 1,950 2,028 1,217 1,315 1,266 524 524 545
## 152 9,118 9,483 6,496 7,016 6,756 8,096 8,096 8,420
## 153 4,465 4,643 4,552 4,916 4,734 4,493 4,493 4,673
## 154 22,875 23,790 18,563 20,048 19,305 20,304 20,304 21,116
## 155 1,047 1,089 919 992 956 817 817 849
## 156 1,630 1,695 2,055 2,220 2,137 3,438 3,438 3,575
## 157 2,622 2,727 2,323 2,509 2,416 2,719 2,719 2,828
## 158 15,153 15,759 13,432 14,507 13,970 8,789 9,878 10,273
## 159 7 7 8 9 8 0 0 0
## 160 1 1 4 4 4 0 0 0
## 161 3,231 4,431 5,285 5,428 4,638 3,507 3,404 3,603
## 162 2,237 1,458 1,937 2,449 2,084 1,542 1,290 1,249
## 163 0 0 0 0 0 0 5 1,113
## 164 10,023 10,330 11,004 11,333 10,737 9,393 9,849 9,576
## 165 5,502 6,072 6,215 6,480 6,002 5,200 5,112 4,866
## 166 3,334 3,165 3,112 3,896 2,752 2,408 2,366 2,441
## 167 2,216 2,180 2,358 2,546 2,096 2,544 1,785 1,279
## 168 7,449 5,652 5,251 4,649 4,736 4,355 4,214 4,425
## 169 7,764 7,912 8,569 8,147 8,103 6,388 6,872 7,739
## 170 5,971 5,202 5,123 4,911 5,290 4,192 3,601 3,399
## 171 12,862 13,917 11,853 12,280 11,562 11,053 11,010 11,133
## 172 903 642 464 237 117 49 20 11
## 173 10,005 9,534 9,759 9,791 9,147 8,533 8,810 9,441
## 174 1,120 1,165 2,007 2,168 2,087 2,551 2,551 2,653
## 175 91 95 271 293 282 297 297 309
## 176 205 213 163 176 169 190 190 197
## 177 1,341 1,395 1,356 1,465 1,411 1,548 1,548 1,610
## 178 223 232 217 234 226 279 279 290
## 179 544 565 922 996 959 1,386 1,386 1,442
## 180 536 557 488 527 508 529 529 550
## 181 3,554 3,475 3,222 3,006 3,394 3,093 3,210 3,873
## 182 2,216 2,438 2,418 2,818 2,932 2,852 3,310 4,256
## 183 1,838 1,854 2,042 2,124 1,888 1,685 1,578 2,090
## 184 128 132 162 166 178 149 127 154
## 185 241 174 181 180 153 169 159 181
## 186 605 493 531 566 731 594 506 585
## 187 6,237 6,925 5,951 5,565 6,131 6,930 7,332 8,579
## 188 143 165 136 167 169 142 127 169
## 189 10,737 9,819 8,815 7,899 9,405 8,591 9,703 12,248
## 190 349 281 495 456 443 743 1,107 1,025
## 191 0 0 0 0 0 1,384 3,083 3,734
## 192 1,172 1,012 898 848 826 851 738 883
## 193 835 241 164 57 1,242 1,911 1,335 2,629
## 194 2,019 2,737 2,559 2,789 2,504 2,353 2,060 2,488
## 195 2,076 2,286 2,438 2,123 1,980 1,318 1,620 2,499
## 196 1,573 1,674 1,500 1,620 1,407 1,292 1,226 1,646
## 197 195 203 256 277 267 313 313 325
## 198 2,468 2,745 2,994 2,611 2,632 2,205 2,504 2,458
## 199 0 0 0 0 0 0 0 0
## 200 6,091 6,612 7,221 6,630 6,924 5,908 6,193 5,672
## 201 14,100 12,861 12,443 13,649 9,742 7,963 9,556 20,434
## 202 3,865 3,532 4,234 2,602 3,417 3,168 3,954 5,754
## 203 3,349 863 60 9 12 7 2 2
## 204 2,281 2,291 2,929 2,234 4,701 3,722 5,055 4,776
## 205 0 0 0 1,700 0 0 0 0
## 206 18 16 28 6 0 0 0 0
## 207 1,090 866 720 733 603 531 451 422
## 208 7 8 3 3 3 0 0 0
## 209 231 240 147 159 153 0 0 0
## 210 2,800 2,912 2,583 2,789 2,686 0 0 0
## 211 819 851 893 964 928 0 0 0
## 212 1,244 1,293 1,547 1,671 1,609 0 0 0
## 213 606 630 1,048 1,132 1,090 0 0 0
## 214 546 568 311 335 323 0 0 0
## 215 606 961 1,118 1,207 1,163 0 0 0
## 216 999 1,039 512 552 532 0 0 0
## 217 797 829 353 381 367 0 0 0
## 218 1,003 1,043 620 0 645 0 0 0
## 219 1,813 1,885 1,699 670 1,767 0 0 0
## 220 1,646 1,712 811 875 843 0 0 0
## 221 1,172 1,219 1,638 1,769 1,704 0 0 0
## 222 4,627 4,812 3,687 3,982 3,835 0 0 0
## 223 4,471 4,650 4,317 1,835 4,489 0 0 0
## 224 2,186 2,273 3,205 3,462 3,333 0 0 0
## 225 1,027 1,068 1,247 1,347 1,297 0 0 0
## 226 352 366 257 278 267 0 0 0
## 227 3,896 4,052 2,857 3,085 2,971 0 0 0
## 228 1,661 1,727 1,581 1,708 1,645 2,115 2,115 2,199
## 229 802 834 951 1,027 989 1,414 1,414 1,471
## 230 896 932 1,061 1,146 1,104 750 750 780
## 231 641 667 1,291 1,394 1,343 1,275 1,275 1,326
## 232 4,665 4,852 2,994 3,233 3,113 2,954 2,954 3,072
## 233 526 547 605 653 629 519 519 540
## 234 1,259 1,310 1,163 1,257 1,210 952 952 990
## 235 0 0 0 0 0 0 152 0
## 236 162 169 110 119 114 152 0 158
## 237 9,873 10,268 9,381 10,132 9,757 11,684 11,684 12,151
## 238 758 788 1,444 1,559 1,501 1,238 1,238 1,288
## 239 1,920 1,997 1,453 1,569 1,511 1,140 1,140 1,186
## 240 5,589 5,812 3,768 4,069 3,919 4,026 4,026 4,187
## 241 24 25 30 33 32 26 26 27
## 242 5,835 6,068 6,517 7,039 6,778 5,488 5,488 5,708
## 243 610 635 503 543 523 443 443 461
## 244 1,289 1,341 799 863 831 323 323 336
## 245 2,839 2,953 1,640 1,772 1,706 1,589 1,589 1,653
## 246 6,170 6,417 4,381 4,732 4,556 5,022 5,022 5,223
## 247 23,132 24,057 20,303 21,927 21,115 19,858 19,858 20,652
## 248 11,344 11,797 10,132 10,943 10,537 6,621 6,621 6,886
## 249 2,114 2,199 1,557 1,681 1,619 1,244 1,244 1,294
## 250 2,309 2,402 2,191 2,366 2,278 2,289 2,289 2,380
## 251 3 4 0 0 0 4 4 4
## 252 1,208 1,163 673 727 700 599 599 623
## 253 374 389 309 333 321 329 328 341
## 254 1,019 1,060 998 1,078 1,038 998 998 1,038
## 255 1,499 1,559 1,720 1,857 1,789 1,830 1,830 1,903
## 256 2,379 2,474 2,412 2,605 2,508 2,010 2,010 2,090
## 257 332 346 372 402 387 342 342 356
## 258 531 552 596 643 619 776 776 807
## 259 38,214 39,743 35,061 37,866 36,464 37,002 37,002 38,482
## 260 6,558 6,821 7,194 7,770 7,482 7,014 7,014 7,295
## 261 1,336 1,389 814 880 847 182 182 190
## 262 52 54 64 69 67 66 66 68
## 263 639 665 0 0 0 428 428 445
## 264 1,984 2,063 3,526 3,808 3,667 2,007 2,007 2,087
## 265 1,416 1,473 2,628 2,838 2,733 1,118 1,118 1,163
## 266 6,505 5,889 4,281 4,860 4,599 4,374 4,292 4,996
## 267 638 382 311 268 270 291 263 273
## 268 10,456 13,802 11,241 13,920 13,341 13,768 14,994 15,799
## 269 10,582 10,669 14,504 15,294 15,237 15,479 15,089 15,653
## 270 3,939 2,954 2,800 2,205 2,868 2,662 2,370 2,523
## 271 2,058 2,347 2,170 2,765 2,727 2,172 1,838 1,878
## 272 17,146 16,225 12,430 14,503 14,545 12,396 12,233 14,304
## 273 436 574 758 915 1,118 1,210 943 956
## 274 2,771 2,326 1,894 1,677 1,630 1,420 1,305 1,382
## 275 18,994 19,753 16,667 18,000 17,333 0 0 0
## 276 1,006 1,047 1,090 1,177 1,133 0 0 0
## 277 1,916 1,992 1,795 1,938 1,867 0 0 0
## 278 34,253 35,623 30,128 32,538 31,333 0 0 0
## 279 9,979 0 11,206 12,569 12,083 10,344 10,025 12,275
## 280 1 2 0 8 1 3 0 0
## 281 611 616 714 931 1,182 1,326 848 669
## 282 6 5 0 1 1 0 0 1
## 283 28,060 28,706 25,110 16,638 25,485 24,596 22,673 25,405
## 284 17,308 20,485 21,382 24,134 22,679 22,272 21,005 23,400
## 285 2,571 5,629 7,472 6,322 7,030 7,446 0 7,484
## 286 1,610 1,232 2,060 2,418 2,421 1,907 1,831 2,271
## 287 969 1,178 1,371 1,143 960 794 757 790
## 288 0 159 5,377 0 10,177 7,571 7,735 8,354
## 289 20,025 18,542 8,590 8,663 9,407 9,536 9,499 12,330
## 290 0 0 0 1 0 0 0 1
## 291 406 445 463 287 132 57 53 23
## 292 3,888 2,466 3,940 4,667 4,342 1,452 3,532 5,178
## 293 33,677 38,250 37,821 39,895 38,098 42,226 42,842 47,044
## 294 1,760 0 1,639 2,445 2,129 1,976 1,948 2,468
## 295 6,267 6,418 6,158 7,344 6,311 0 6,594 0
## 296 228 246 157 134 185 85 225 245
## 297 20,487 21,321 20,126 22,131 20,579 17,456 18,156 19,475
## 298 10,561 9,775 10,457 11,235 11,261 10,330 9,654 12,513
## 299 1,570 2,292 2,790 3,030 3,190 2,896 2,369 2,555
## 300 204 212 219 237 228 167 167 174
## 301 4,559 4,742 5,156 5,569 5,362 6,365 6,365 6,619
## 302 2,686 2,794 2,827 3,053 2,940 3,549 3,549 3,691
## 303 937 975 1,216 1,313 1,265 829 829 862
## 304 2,172 2,259 3,432 3,706 3,569 3,498 3,498 3,638
## 305 3,782 3,934 4,594 4,961 4,777 5,543 5,543 5,765
## 306 4,456 4,634 5,262 5,683 5,472 5,035 5,035 5,236
## 307 6,181 6,428 5,421 5,855 5,638 6,753 6,753 7,023
## 308 466 1,337 722 944 1,501 1,775 1,742 1,296
## 309 228 201 176 120 141 147 134 112
## 310 832 1,632 564 359 330 304 284 215
## 311 2,115 2,193 2,443 2,495 2,540 2,764 2,684 3,067
## 312 3,717 3,925 3,161 2,946 3,211 3,307 3,170 4,075
## 313 3,365 3,645 3,719 3,780 3,223 2,999 3,657 4,844brandata1 <- select(rawdata1, -Model)
brandata1 <- mutate_at(brandata1, vars(starts_with("Jan"):ends_with("Dec")), function(x) as.numeric(gsub(",", "", x)))
brandata1 <- mutate(brandata1, Total = rowSums(select(brandata1, starts_with("Jan"):ends_with("Dec"))))
brandresult <- brandata1 %>%
group_by(Brand) %>%
summarise(Sum_Total = sum(Total)) %>%
arrange(desc(Sum_Total))
brandresult## # A tibble: 38 × 2
## Brand Sum_Total
## <chr> <dbl>
## 1 Ford 1904038
## 2 Toyota 1888941
## 3 Chevrolet 1702700
## 4 Honda 1156591
## 5 Nissan 834091
## 6 Hyundai 796506
## 7 Kia 782468
## 8 Jeep 641166
## 9 Subaru 632083
## 10 GMC 563692
## # ℹ 28 more rowssummary(brandresult) ## Brand Sum_Total
## Length:38 Min. : 199
## Class :character 1st Qu.: 66729
## Mode :character Median : 183153
## Mean : 402055
## 3rd Qu.: 557638
## Max. :1904038ggplot(data = brandresult, aes(x = Brand, y = Sum_Total)) +
geom_point() +
labs(title = "2023 Total US Vehicle Model Sales by Brand ", x = "Brand", y = "Total Sum") +
theme(axis.text.x = element_text(angle = 45, hjust = 1))
Conclusion
The plot indicates that the majority of vehicle brands did not surpass sales of 500,000 units. Among them, only the top three brands, Ford, Toyota, and Chevrolet, achieved sales exceeding 1,500,000 units. Ford led the pack with sales reaching 1,904,038 units, while Karma sold fewer than 200 units, totaling just 199.