Best Car Insurance Company in North Carolina

The automobile has already become the best travel tools in American. So my question is what is the best car insurance company in North Carolina. First, I google the best car insurance companies. Then I entered this website--NerdWallet https://www.nerdwallet.com/blog/insurance/best-car-insurance-companies/

NerdWallet is an American personal finance website that helps people make and manage financial decisions by comparing various products available from various banks and insurance companies. They rank 21 car insurance companies.

[pic 1]

In the following, they also show the customers how they calculated their rating.

[pic 2]

If you want to learn more, you can lick the link. Like the first one, 2015 consumer

complaints data from the National Association of Insurance Commissioners.

When I entered the NAIC, I just need to put the car insurance company name in the

search box. Like this [pic 3]

And then I can learn the specific data about this car company.

Because of different state has different traffic policy. So I go back to Nerdwallet and search the best car insurance companies in NC. Like this https://www.nerdwallet.com/blog/insurance/cheapest-car-insurance-in-north-carolina-nc/#young

[pic 4]

If I click young drivers, it will like this  [pic 5]

With Nerdwallet recommend I search the StateFarm on NAIC. Through the relative

data analysis, I will select GEICO as one of my considering company.  

(a).

Through the box plot chat, we can find it: no matter is minimum and maximum value white collar is more as compared to blue collar.

Specifically, the mean and median part: white collar is bigger than the blue collar.

The interquartile range part: both collars are almost same, but the white one is a little bit bigger than the blue one.

The lower whisker part: the white one is a little bit bigger than the blue one.

The upper whisker part: the white one is much bigger than the blue one.

The extreme outlier: the white one has two points and blue one has three points.

(b).

In white collar the point of 9.1 should be omitted. And in blue collar the point of 5.6 is outlier which should be omitted.

The box plots are relevant. But we can remove these outliers and then rerun analysis for more reliable results.