on
“car_insurance_claims.sav”
Analysis of the file car_Insurance claim.sav
INDEX
Table of Contents Objective: 3 Analysis: 3 Statistics of Data 3 Frequency Table 4 Crosstabs 8 Analysis of Variance 13 Conclusion: 15
Objective:
* To analyze the complete damage claims for cars on the factors like policyholder age, vehicle type, and vehicle age * To find out the reasons for the claims * To find out which group of vehicle is taken for more claims
Analysis:
Statistics of Data | | Policyholder age | Vehicle group | Vehicle age | Average cost of claims | Number of claims | N | Valid | 128 | 128 | 128 | 123 | 128 | | Missing | 0 | 0 | 0 | 5 | 0 | Mean | 4.50 | 2.50 | 2.50 | 231.14 | 69.86 | | | | | | |
Comments: The mean cost of claims is 231 Rs and mean Number of claims 69.86
\
Frequency Table Policyholder age | | Frequency | Percent | Valid Percent | Cumulative Percent | Valid | 17-20 | 16 | 12.5 | 12.5 | 12.5 | | 21-24 | 16 | 12.5 | 12.5 | 25.0 | | 25-29 | 16 | 12.5 | 12.5 | 37.5 | | 30-34 | 16 | 12.5 | 12.5 | 50.0 | | 35-39 | 16 | 12.5 | 12.5 | 62.5 | | 40-49 | 16 | 12.5 | 12.5 | 75.0 | | 50-59 | 16 | 12.5 | 12.5 | 87.5 | | 60+ | 16 | 12.5 | 12.5 | 100.0 | | Total | 128 | 100.0 | 100.0 | |
Vehicle group | | Frequency | Percent | Valid Percent | Cumulative Percent | Valid | A | 32 | 25.0 | 25.0 | 25.0 | | B | 32 | 25.0 | 25.0 | 50.0 | | C | 32 | 25.0 | 25.0 | 75.0 | | D | 32 | 25.0 | 25.0 | 100.0 | | Total | 128 | 100.0 | 100.0 | |
Vehicle age | | Frequency | Percent | Valid Percent | Cumulative Percent | Valid | 0-3 | 32 | 25.0 | 25.0 | 25.0 | | 4-7 | 32 | 25.0 | 25.0 | 50.0 | | 8-9 | 32 | 25.0 | 25.0 | 75.0 | | 10+ | 32 | 25.0 | 25.0 | 100.0 | | Total | 128 | 100.0 | 100.0 | |
Descriptive Statistics | | N | Mean | Std. Deviation | Skewness | | Statistic | Statistic | Statistic | Statistic |