a white house with a red door

This post is adapted from the blog of Gavop a Priceonomics Data Studio customer. Does your company have interesting data? Become a Priceonomics customer.

***

Home insurance is one of those expenses that can feel mysterious. There are vague rules like “$3.50 a year for every $1,000 of home value”, but they vary considerably from city to city. It’s hard to get an intuitive sense of what “good” or “bad” home insurance prices are.

So, when you get a quote, it’s tempting to just take the first offer you get. Compared to the sticker shock of the house itself, the number might feel like small change.  After all, it’s the same house no matter who you get insurance from, so it can’t matter too much who you ask — right?

To investigate, we analyzed home insurance filing data from Priceonomics customer Gavop, a real estate dat company. Gavop assembled data from various insurers in twelve states to see how much their quotes differed for similar levels of coverage. These quotes were all publicly submitted to the state insurance regulators in response to survey questions on how much they charge for different types of homes. 

Then, we grouped those quotes by location (generally county) and all locations with at least ten quotes were analyzed. The difference between the 75th percentile of premiums for a location and the 25th percentile of premiums was used to measure how much quotes could vary for the same location and coverage.

We found that the difference between the premiums was substantial, and shopping around can lead to dramatic changes in pricing. Of all the states we looked at, Texas had the biggest discrepancy in prices — there was a $2,182 range in insurance prices between a 25th and 75th percentile quote. Even at the low end, in New Hampshire the price ranges between quotes at these percentiles was $363 per year.

We also did a detailed analysis of California home insurance quotes. In most notable cities in the state, after controlling for every single variable, there was a $300-500 price range between a 25th and 75th percentile quote for the same kind of house.

***

To start, let’s look at all of the quotes for yearly premiums for home insurance with coverage between $150,000 and $350,000. This lets us get a high-level overview of which states have the largest difference between the cheap premiums (the 25th percentile) and expensive premiums (the 75th percentile).

table

Data source: Gavop

Generally speaking, the more expensive premiums are in an area, the greater the difference between cheap plans and expensive plans. In Texas, for example, even the 25th percentile of premiums ($1,635) is more than the 75th percentile of premiums in New Hampshire ($1,020). And the Texan 75th percentile is $3,817, making the difference between them a whopping $2,182! In other words, in Texas, you can reasonably expect shopping around to save you more on home insurance than people in many states even pay.

We can see this trend in more detail by looking at the locations in the dataset with the largest difference between the 75th and 25th percentiles. These are areas where shopping around can have an extremely dramatic difference. Note here that we’re defining “low” coverage as $150,000 or less, “medium” coverage as greater than $150,000 but less than or equal to $350,000, and “high” coverage as anything greater than $350,000.

table

Data source: Gavop

You can see that no median price was less than $2,000, and that it’s mostly high coverage plans that are represented. The largest one, Nueces County (which includes Mustang Island, an extreme flood risk) had differences of over $5,000! They are also all in Texas, Florida, and Louisiana – three of the four most expensive states in our data set. (The area with the biggest difference in Kansas is Gove County at $2,090).

Next, let’s look at the locations with the smallest variation. These are ones where shopping around would have the least impact, because plans really are mostly the same.

table

Data source: Gavop

As we can see, the plans are much more likely to be low coverage, and the median premiums are much smaller. Missoula, the lowest difference location in our whole data set, is a great example of how the premiums being low forces the difference to be low. Since your insurance costs won’t be negative, there’s simply no way for the high and low end to vary that much when the plans are all so cheap.

To get an even better view of this trend, we can look at a plot of the median premium for a given location and level of coverage against the difference between the 75th and 25th percentile of premiums for that location and level of coverage. This will allow us to see what happens to the differences as the median increases.

chart, scatter chart

Data source: Gavop

For every $1,000 increase in median price, you can expect the difference between the cheap and expensive quotes to increase by around $700. If the median premium is $1,000, the plans will likely all have fairly similar premiums. But for a median premium of $6,000, you could save $4,000 by just shopping around!

Now, let’s turn to look at California specifically. By limiting our investigation to a single state, we can control for all factors and look at the differences in quotes for truly identical criteria. Let’s dig into the difference between the 75th and 25th percentile of yearly premiums for some California cities:

table

Data source: Gavop

San Francisco is a city infamous for high housing prices, so it should come as no surprise that it’s top of the charts. However, it’s interesting that the differences are relatively constrained here. It appears that California is a more “fair” state where differences in insurance premiums are lessened – so even though the more expensive locations still have more variation, the variation is just lower across the board.

We can contrast that with data from Texas. Note that the Texas data is partitioned by zip code, not city, although we’ve included the city the zip code resides within:

table

Data source: Gavop

It’s night and day between California and Texas. Texas is one of the most expensive states to get home insurance in the country, owing partly to the frequency of catastrophic weather events and partly due to higher insurer expenses. Not only does zip code 78521 in Brownsville have a 25th percentile of premium greater than San Francisco’s 75th percentile, but it’s 75th percentile is more than double that!

Turning back to California, let’s find the same trend line we originally found for the whole dataset:

chart, scatter chart

Data source: Gavop

This trendline has a higher R squared han the national one – it’s even more likely that a higher median premium means more variation. However, the degree of that variation is lessened. In California, for every $1,000 increase in medium premium, the difference between the 75th and 25th percentile of premiums increases by just $400. (This is the measure of “fairness” for a state).

We can see this in more detail by viewing the data with a stacked area chart. In this kind of chart, we draw a line to show how many of the locations controlling for all criteria had differences no more than a certain value. So, the halfway point on the X-axis (denoted here with a red line) shows the value of difference of the median location, and half of the locations had a difference less than that.

chart

Data source: Gavop

We can see that the halfway point is only $400. Shopping around in California gets you a lot less far than the average state. This is because both forces we’ve analyzed are constraining the prices – the state is a “more fair” one, and the median premiums are on the smaller side, compared to the national standard. Florida, by contrast, is an even more “fair” state than California (each $1000 increase in median premium corresponds to about a $275 increase in difference), but the premiums are high enough that the Florida differences are still much higher than the ones in California.

Some states seem to just be intrinsically more fair than other states when it comes to home insurance quotes. However, no matter how fair the state, more expensive locations always means bigger differences between premiums if you shop around. So if you get a home insurance quote and the yearly premium is expensive, you should get a second opinion – you might be able to save thousands of dollars a year.

***

Note: If you’re a company that wants to work with Priceonomics to turn your data into great stories, learn more about the Priceonomics Data Studio.