incident_type median_auto_year median_claim_amount median_age Totals
Multi-vehicle Collision 2006 61650 39 419
Parked Car 2005 5490 37 84
Single Vehicle Collision 2005 62640 38 403
Vehicle Theft 2005 5495 38 94

The table above shows that greater number of people that claimed their insurance had been involved in a collision, either a multi-vehicle collision or a single vehicle collision. There is also a consistent median age range of the late thirties for all the people that went through the different incidents that led to claiming their insurance. Is the age range targeted for theft and is there also a higher chance of people having at least one collision in their late thirties?

time_frame median_auto_year median_claim_ amount median_age Totals
10a.m.-4:59p.m 2005 61490 38 293
10p.m.-midnight 2006 62920 39 89
5p.m.-7.59p.m 2005 60190 40 135
6a.m.-9.59a.m 2005 40320 38 163
8p.m.-9.59p.m. 2005 60205 39 76
midnight-5.59a.m 2005 52590 36 244

A greater number of people had incidents in the early hours of the day and during day time and a few during the late hours of the day.Is this because during the day it is very busy and people are not guarded whereas in the late hours most people are home and are extra careful if they are on the road?

time_frame incident_type median_auto_year median_claim_ amount median_age Totals
10a.m.-4:59p.m Multi-vehicle Collision 2007 60750 38 137
10a.m.-4:59p.m Parked Car 2004 5900 40 7
10a.m.-4:59p.m Single Vehicle Collision 2004 63700 39 138
10a.m.-4:59p.m Vehicle Theft 2005 6820 40 11
10p.m.-midnight Multi-vehicle Collision 2008 64800 40 41
10p.m.-midnight Parked Car 2013 5700 41 3
10p.m.-midnight Single Vehicle Collision 2004 62640 37 45
5p.m.-7.59p.m Multi-vehicle Collision 2005 61400 41 65
5p.m.-7.59p.m Parked Car 2011 6490 37 5
5p.m.-7.59p.m Single Vehicle Collision 2005 61110 41 62
5p.m.-7.59p.m Vehicle Theft 2000 5100 28 3
6a.m.-9.59a.m Multi-vehicle Collision 2004 64320 39 41
6a.m.-9.59a.m Parked Car 2006 5830 39 34
6a.m.-9.59a.m Single Vehicle Collision 2006 63685 38 46
6a.m.-9.59a.m Vehicle Theft 2006 4975 38 42
8p.m.-9.59p.m. Multi-vehicle Collision 2005 61440 39 47
8p.m.-9.59p.m. Parked Car 2004 5005 32 2
8p.m.-9.59p.m. Single Vehicle Collision 2005 59355 38 22
8p.m.-9.59p.m. Vehicle Theft 2005 6500 35 5
midnight-5.59a.m Multi-vehicle Collision 2006 61625 37 88
midnight-5.59a.m Parked Car 2004 4900 34 33
midnight-5.59a.m Single Vehicle Collision 2005 60185 36 90
midnight-5.59a.m Vehicle Theft 2004 5220 39 33

The table above shows incidents taking place at different time frames and not one incident being restricted to a certain time frame.

The graph above shows that there is a higher occurance of multi-vehicle and single vehicle collisions at any time frame whereas parked car and vehicle theft incidents are fairly occur more during the day and their occurance decreases in the late hours of the day.

The graph above goes on to further show the extreme high amounts claimed in the year 2005 for multi and single-vehicle collisions as well as vehicle theft. What caused so many incidents in the year 2005? It also shows the consistent amount claimed from the year 2006 to around 2008 for multi-vehicle collision and it stops around 2008.Was there any measures taken to stop or reduce multi-vehicle collisions? As from the year 2010 the amounts claimed were only from parked car incidents, which brings the big question did they manage to stop all the other incidents from occuring except for parked cars?