Data Journalism Trend Report - 7/2 - Basic Age Trends Report

Lakshmi Iyengar
Sep 22, 2021 · 3 min read

Methodology Exclusion Criteria

Our data set comprises user data for every user Jerry has run final quotes for in the last year. Initially, this was a data set of 1,039,376 quotes for 147,380 users. We normalized this to one quote (lowest option) for each of the 147,380 users. This is our primary data set.
We created two sub-datasets with our user data. For the first, we controlled for outliers by removing users with entered monthly premiums above 4,000 USD, or 200% of the average monthly premium after an at-fault wreck. If a state had under 1% total users, the state was not counted. This left us with 88,572 points of user data. This data set is henceforth referred to as Entered Premiums Data Set.
For the second, we controlled for outliers by removing quotes we’ve provided to customers above 4,000 USD per month. If a state or subgroup had under 1% total users, the state was not counted. This left us with 147,372 points of user data. This data set is henceforth referred to as Quoted Price Data Set.

Description of our Primary Data Set

Our top five user states are Florida, Texas, Georgia, California, and New York. Our bottom five user states are Alaska, Hawaii, North Dakota, Vermont, and South Dakota. Hawaii and Alaska have under 10 data points each and were therefore not used in our data analyses.
40% of our users are between 25-34, the second-highest number between 21-24, and 17% are between 35-44. A minority of our users are above 65.
Primary Data Set in Age Groups
Age GroupsPercentage of Our Users
18-206.66%
21-2423.30%
25-3440.08%
35-4417.32%
45-548.54%
55-643.04%
65+1.06%
Finally, 39.7% of our users identify as Female and 58.01% identify as Male. These categories are gender categories defined by insurance providers and are not options decided by Jerry itself.

Most and Least Expensive States to Insure Teen Drivers

Methods/ Data Sets Used:

  • Quoted Price Data Set
  • Age group 16-19
  • N = 3515, only states with above 35 users included
  • HI and AK excluded
  • No Violations
  • Tried with violations, not enough data to be significant

Results

Key Insights
  • Iowa, Alabama, North Carolina least expensive for teens with no violations
  • New York, Louisiana, and Rhode Island most expensive
Least Expensive States to Insure Teen Drivers, no Violations
StateAverage Monthly PremiumStd.MedianCount
IA134.3965.6512138
AL189.4690.4317036
NC192.69681.16142250
IN197.5891.9518639
CA203.1820.5158233
IL203.9848.4218591
NM20635.10187.538
ID21231.3721732
MT213.3329.3017136
OH220.5929.82192149
Most Expensive States to Insure Teen Drivers, no Violations
StateAverage Monthly PremiumStd.MedianCount
NY646.2845.42522151
LA627.1642.0556035
RI455.1682.0844536
NJ445.6241.1241637
MD444.1631.27416.556
DE431.218.7640435
FL415.925.80356.5224
CT403.2453.09240561
GA400.1639.77357285
NV393.6440.7641434
MI392.1738.5537737
CO37723.62297.538

Most and Least Expensive States for Retiree Car Insurance

Methods/ Data Sets Used:

  • Quoted Price Data Set
  • Age group 65+
  • HI and AK excluded
  • Violations and No Violations combined to have appropriate data set size
  • N= 1556, only states above 15 users included

Results

Key Insights
  • West Virginia, Iowa, Wisconsin least expensive for retirees
  • Maryland, New York, NJ most expensive for retirees
  • Maryland average monthly premium for retirees (most expensive) 3.5x West Virginia (least expensive)
Least Expensive States to Insure Retirees
StateAverage Monthly PremiumStd.MedianCount
IA84.124.087920
WI85.4550.847621
OH95.17568.877.540
IN100.87576.139816
MT10250.969316
NM10444.449720
OR110.8561.7595.514
TN113.7251.0610322
NC117.9732.78248
MA118.5748.0299.514
Most Expensive States to Insure Retirees
StateAverage Monthly PremiumStd.MedianCount
MD285.0335.218029
NY266.7957.96199110
NJ263.4722.8916340
KY259.854.35186.530
MS247.7738.9815419
LA236.1524.39204.532
GA202.1355.08171143
FL190.9142.24156193
CT188.8343.1714618
MI177.1431.5116414

Easiest way to compare and buy car insurance

√
No long forms
√
No spam or unwanted phone calls
√
Quotes from top insurance companies
Find insurance savings — it's 100% free