Column
VIN..1.10. County City State Postal.Code Model.Year Make Model
1 5YJYGDEE1L King Seattle WA 98122 2020 TESLA MODEL Y
2 7SAYGDEE9P Snohomish Bothell WA 98021 2023 TESLA MODEL Y
3 5YJSA1E4XK King Seattle WA 98109 2019 TESLA MODEL S
4 5YJSA1E27G King Issaquah WA 98027 2016 TESLA MODEL S
5 5YJYGDEE5M Kitsap Suquamish WA 98392 2021 TESLA MODEL Y
6 3FA6P0SU8H Thurston Yelm WA 98597 2017 FORD FUSION
Electric.Vehicle.Type
1 Battery Electric Vehicle (BEV)
2 Battery Electric Vehicle (BEV)
3 Battery Electric Vehicle (BEV)
4 Battery Electric Vehicle (BEV)
5 Battery Electric Vehicle (BEV)
6 Plug-in Hybrid Electric Vehicle (PHEV)
Clean.Alternative.Fuel.Vehicle..CAFV..Eligibility Electric.Range
1 Clean Alternative Fuel Vehicle Eligible 291
2 Eligibility unknown as battery range has not been researched 0
3 Clean Alternative Fuel Vehicle Eligible 270
4 Clean Alternative Fuel Vehicle Eligible 210
5 Eligibility unknown as battery range has not been researched 0
6 Not eligible due to low battery range 21
Base.MSRP Legislative.District DOL.Vehicle.ID Vehicle.Location
1 0 37 125701579 POINT (-122.30839 47.610365)
2 0 1 244285107 POINT (-122.179458 47.802589)
3 0 36 156773144 POINT (-122.34848 47.632405)
4 0 5 165103011 POINT (-122.03646 47.534065)
5 0 23 205138552 POINT (-122.55717 47.733415)
6 0 2 122057736 POINT (-122.61023 46.94126)
Electric.Utility X2020.Census.Tract
1 CITY OF SEATTLE - (WA)|CITY OF TACOMA - (WA) 53033007800
2 PUGET SOUND ENERGY INC 53061051938
3 CITY OF SEATTLE - (WA)|CITY OF TACOMA - (WA) 53033006800
4 PUGET SOUND ENERGY INC||CITY OF TACOMA - (WA) 53033032104
5 PUGET SOUND ENERGY INC 53035940100
6 PUGET SOUND ENERGY INC 53067012532
VIN..1.10.
0
County
0
City
0
State
0
Postal.Code
0
Model.Year
0
Make
0
Model
0
Electric.Vehicle.Type
0
Clean.Alternative.Fuel.Vehicle..CAFV..Eligibility
0
Electric.Range
0
Base.MSRP
0
Legislative.District
0
DOL.Vehicle.ID
0
Vehicle.Location
0
Electric.Utility
0
X2020.Census.Tract
0
VIN..1.10. County City State
Length:177477 Length:177477 Length:177477 Length:177477
Class :character Class :character Class :character Class :character
Mode :character Mode :character Mode :character Mode :character
Postal.Code Model.Year Make Model
Min. :98001 Min. :1997 Length:177477 Length:177477
1st Qu.:98052 1st Qu.:2019 Class :character Class :character
Median :98122 Median :2022 Mode :character Mode :character
Mean :98260 Mean :2021
3rd Qu.:98370 3rd Qu.:2023
Max. :99403 Max. :2024
Electric.Vehicle.Type Clean.Alternative.Fuel.Vehicle..CAFV..Eligibility
Length:177477 Length:177477
Class :character Class :character
Mode :character Mode :character
Electric.Range Base.MSRP Legislative.District DOL.Vehicle.ID
Min. : 0.00 Min. : 0 Min. : 1.00 Min. : 4385
1st Qu.: 0.00 1st Qu.: 0 1st Qu.:18.00 1st Qu.:181524136
Median : 0.00 Median : 0 Median :33.00 Median :228269128
Mean : 58.83 Mean : 1071 Mean :29.13 Mean :220252717
3rd Qu.: 75.00 3rd Qu.: 0 3rd Qu.:42.00 3rd Qu.:254850396
Max. :337.00 Max. :845000 Max. :49.00 Max. :479254772
Vehicle.Location Electric.Utility X2020.Census.Tract
Length:177477 Length:177477 Min. :5.300e+10
Class :character Class :character 1st Qu.:5.303e+10
Mode :character Mode :character Median :5.303e+10
Mean :5.304e+10
3rd Qu.:5.305e+10
Max. :5.308e+10
Rows: 177,477
Columns: 17
$ VIN..1.10. <chr> "5YJYGDEE1L", "7SAYG…
$ County <chr> "King", "Snohomish",…
$ City <chr> "Seattle", "Bothell"…
$ State <chr> "WA", "WA", "WA", "W…
$ Postal.Code <int> 98122, 98021, 98109,…
$ Model.Year <int> 2020, 2023, 2019, 20…
$ Make <chr> "TESLA", "TESLA", "T…
$ Model <chr> "MODEL Y", "MODEL Y"…
$ Electric.Vehicle.Type <chr> "Battery Electric Ve…
$ Clean.Alternative.Fuel.Vehicle..CAFV..Eligibility <chr> "Clean Alternative F…
$ Electric.Range <int> 291, 0, 270, 210, 0,…
$ Base.MSRP <int> 0, 0, 0, 0, 0, 0, 0,…
$ Legislative.District <int> 37, 1, 36, 5, 23, 2,…
$ DOL.Vehicle.ID <int> 125701579, 244285107…
$ Vehicle.Location <chr> "POINT (-122.30839 4…
$ Electric.Utility <chr> "CITY OF SEATTLE - (…
$ X2020.Census.Tract <dbl> 53033007800, 5306105…
Call:
lm(formula = ev_count ~ Model.Year, data = yearly_ev)
Residuals:
Min 1Q Median 3Q Max
-12676 -6223 -4058 3131 38796
Coefficients:
Estimate Std. Error t value Pr(>|t|)
(Intercept) -1934010.2 531492.8 -3.639 0.00163 **
Model.Year 965.3 264.2 3.654 0.00158 **
---
Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
Residual standard error: 10520 on 20 degrees of freedom
Multiple R-squared: 0.4003, Adjusted R-squared: 0.3704
F-statistic: 13.35 on 1 and 20 DF, p-value: 0.001577
Column
Chart B
Call:
lm(formula = Electric.Range ~ Model.Year, data = ev_data)
Residuals:
Min 1Q Median 3Q Max
-364.87 -37.06 -22.39 9.61 270.59
Coefficients:
Estimate Std. Error t value Pr(>|t|)
(Intercept) 2.970e+04 1.296e+02 229.2 <2e-16 ***
Model.Year -1.467e+01 6.413e-02 -228.8 <2e-16 ***
---
Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
Residual standard error: 80.85 on 177864 degrees of freedom
Multiple R-squared: 0.2274, Adjusted R-squared: 0.2274
F-statistic: 5.235e+04 on 1 and 177864 DF, p-value: < 2.2e-16
Model.Year Predicted.Range
1 2025 -6.956096
2 2026 -21.628507
3 2027 -36.300919
4 2028 -50.973330
5 2029 -65.645742
6 2030 -80.318153
Chart C
# A tibble: 22 × 2
Model.Year Number_of_EVs
<int> <int>
1 1997 1
2 1998 1
3 1999 5
4 2000 7
5 2002 2
6 2003 1
7 2008 20
8 2010 23
9 2011 775
10 2012 1618
# ℹ 12 more rows
Call:
lm(formula = Number_of_EVs ~ Model.Year, data = ev_yearly)
Residuals:
Min 1Q Median 3Q Max
-12676 -6223 -4058 3131 38796
Coefficients:
Estimate Std. Error t value Pr(>|t|)
(Intercept) -1934010.2 531492.8 -3.639 0.00163 **
Model.Year 965.3 264.2 3.654 0.00158 **
---
Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
Residual standard error: 10520 on 20 degrees of freedom
Multiple R-squared: 0.4003, Adjusted R-squared: 0.3704
F-statistic: 13.35 on 1 and 20 DF, p-value: 0.001577
Model.Year Predicted_EVs
1 2025 20721.47
2 2026 21686.77
3 2027 22652.07
4 2028 23617.37
5 2029 24582.67
6 2030 25547.97
[1] NA
