Scribd
Upload
15 views2 pages

Car Insurance Claims Analysis Insights

The document outlines key questions for exploratory data analysis (EDA) regarding car insurance claims, focusing on factors such as age, income, education, car age, car use, gender, car type, and marital status. Notable findings include that individuals born between 1946 and 1960 and those with a high school education tend to make more claims, while younger cars and SUVs have higher claim frequencies. Additionally, married individuals file more claims, but unmarried individuals claim larger amounts per claim.

Uploaded by

Jitendra Asati
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
15 views2 pages

Car Insurance Claims Analysis Insights

The document outlines key questions for exploratory data analysis (EDA) regarding car insurance claims, focusing on factors such as age, income, education, car age, car use, gender, car type, and marital status. Notable findings include that individuals born between 1946 and 1960 and those with a high school education tend to make more claims, while younger cars and SUVs have higher claim frequencies. Additionally, married individuals file more claims, but unmarried individuals claim larger amounts per claim.

Uploaded by

Jitendra Asati
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Tableau Public Story URL

[Link]
TableauProjectGL_17457102536400/Story1

Key Questions to be Answered (for EDA):

1. What is the distribution of car owners' ages (using the 'BIRTH' variable)?
Are there any outliers or notable trends in the age distribution?

Customers born between 1946 and 1960 have claimed more insurance
compared to other birth periods.

How does the average income ('INCOME') of drivers vary based on their
education level ('EDUCATION')? Are there any specific education levels
that tend to correlate with higher incomes?

Individuals with an income of less than $80,000 have accounted for


about 78% of the total claims and 81% of the total claim amount.

Individuals with a high school education as their highest level of


schooling have made more claims and claimed higher amounts of
insurance.

2. Is there a relationship between the age of the car ('CAR_AGE') and the
frequency of claims ('CLM_FREQ')? Does the age of the car influence the
likelihood of claims being filed?

The insurance claim frequency and amount are higher for cars in the 0–
7-year age bracket.

3. Are there any differences in the distribution of claimed amounts


('CLM_AMT') between drivers who use their cars for different purposes
('CAR_USE')? How does this difference compare between gender
('GENDER') groups as well?

Cars used for private purposes have been claimed more frequently than
those used for commercial purposes.

Females have a higher frequency and amount of insurance claims,


representing about 55% of the total claim frequency, while males
account for 45%. The total claim amount for females exceeds 57%,
while males account for over 43%.
4. Does the type of car ('CAR_TYPE') have an impact on the average worth
of the car ('BLUEBOOK')? Additionally, can you identify any patterns in
terms of marital status ('MSTATUS') and car type ('CAR_TYPE')
combinations?

Insurance claims have been made more frequently for SUVs than for
Minivans.

Individuals with cars valued between $0 and $17,000 have made more
claims and claimed higher amounts compared to others.

The data presents a contrasting trend. While married individuals have a


higher claim frequency, unmarried individuals have claimed a higher
amount of insurance. This indicates that married people are filing more
claims, but unmarried individuals are claiming larger amounts per
insurance claim.

Both married and unmarried individuals have a higher claim frequency


for SUV followed by minivan and Pickup

Common questions

Powered by AI

Insurance claims have been made more frequently for SUVs than for Minivans. Married individuals have a higher claim frequency, while unmarried individuals claim larger amounts per insurance claim. Both married and unmarried individuals have a higher claim frequency for SUVs, followed by minivans and pickups .

Drivers with a high school education as their highest level of schooling have made more claims and claimed higher amounts of insurance. Individuals with incomes of less than $80,000 have accounted for about 78% of the total claims and 81% of the total claim amount .

Customers born between 1946 and 1960 have claimed more insurance compared to other birth periods .

The insurance claim frequency and amount are higher for cars in the 0–7-year age bracket .

Married individuals file more claims, whereas unmarried individuals claim larger amounts per insurance claim. Both groups have a higher frequency of claiming for SUVs, followed by minivans and pickups .

Individuals with a high school education as their highest level of schooling have made more claims and claimed higher amounts of insurance .

Insurance claims have been made more frequently for SUVs than for Minivans .

Cars in the 0–7-year age bracket have a higher frequency and amount of insurance claims .

Females represent about 55% of the total claim frequency and exceed 57% of the total claim amount, compared to males who account for over 43% .

Cars used for private purposes have been claimed more frequently than those used for commercial purposes. Females have a higher frequency and amount of insurance claims, representing about 55% of the total claim frequency and 57% of the total claim amount, compared to males .

You might also like