Incident Table

The following table displays the four recorded types of vehicular incidents and some relevant cooresponding data. One highly valuable piece of information that can be derived from this is the fact that the majority of incidents occur between one or two moving vehicles. With further study into, it should be possible to find ways to prevent these common and costly collisions.

incident_type median_auto_year median_claim_amount median_age Totals
Multi-vehicle Collision 2006.0 61650 39.0 419
Parked Car 2005.0 5490 36.5 84
Single Vehicle Collision 2005.0 62640 38.0 403
Vehicle Theft 2004.5 5495 38.0 94

Time Frame Table

This table uses much of the same info as before with the type of incident switched out for the time frame of said incident. With this representation, we can find similarly valuable realizations. For example, the the time frames with the most collisions are from 10am-5pm and from midnight to 6am. This data could be due to the wider tracked time frame but it could also indicate peek hours of reckless driving.

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

Time Frame and Incident Table

This final table aggregates the previous two tables into one to allow for further info to be derived. This table may be slightly less legible due to the increased density of data but it allows for more specific insights to be made. One interesting realization that can be made in regards to this newly aggregated table is that no vehicle theft was reported between the hours of 10pm to midnight. This is fascinating as many would consider this to be a time where they and their belongings, such as a their vehicle, would be at higher risk for theft.

time_frame incident_type median_auto_year median_claim_amount median_age Totals
10a.m.-4:59p.m. Multi-vehicle Collision 2007.0 60750 38.0 137
10a.m.-4:59p.m. Parked Car 2004.0 5900 40.0 7
10a.m.-4:59p.m. Single Vehicle Collision 2004.0 63700 39.0 138
10a.m.-4:59p.m. Vehicle Theft 2005.0 6820 40.0 11
10p.m.-midnight Multi-vehicle Collision 2008.0 64800 40.0 41
10p.m.-midnight Parked Car 2013.0 5700 41.0 3
10p.m.-midnight Single Vehicle Collision 2004.0 62640 37.0 45
5p.m.-7:59p.m. Multi-vehicle Collision 2005.0 61400 41.0 65
5p.m.-7:59p.m. Parked Car 2011.0 6490 37.0 5
5p.m.-7:59p.m. Single Vehicle Collision 2005.0 61110 41.0 62
5p.m.-7:59p.m. Vehicle Theft 2000.0 5100 28.0 3
6a.m.-9:59a.m. Multi-vehicle Collision 2004.0 64320 39.0 41
6a.m.-9:59a.m. Parked Car 2005.5 5830 39.0 34
6a.m.-9:59a.m. Single Vehicle Collision 2006.0 63685 37.5 46
6a.m.-9:59a.m. Vehicle Theft 2006.0 4975 38.0 42
8p.m.-9:59p.m. Multi-vehicle Collision 2005.0 61440 39.0 47
8p.m.-9:59p.m. Parked Car 2004.0 5005 32.0 2
8p.m.-9:59p.m. Single Vehicle Collision 2005.0 59355 38.0 22
8p.m.-9:59p.m. Vehicle Theft 2005.0 6500 35.0 5
midnight-5:59a.m. Multi-vehicle Collision 2006.0 61625 36.5 88
midnight-5:59a.m. Parked Car 2004.0 4900 34.0 33
midnight-5:59a.m. Single Vehicle Collision 2005.0 60185 36.0 90
midnight-5:59a.m. Vehicle Theft 2004.0 5220 39.0 33

Insurance Claims by Type of Incident and Time of Day Bar Chart

The following chart is a great visual example of much of the information above. It allows for you to be able to quickly distinguish between which incident type is most common and when. One striking feature of the chart below is the fact that single car and multiple car collisions seem to alternate between being the most common at any given period. From a quick analysis it may be possible to deduce that single car collisions are more likely in the morning while multiple car collisions are more likely in the afternoon. Looking more into the number could easily help support this.

Median Age vs. Incident Type Box Plot

Finally, the graph below shows a series of box plots that aim to show any correlation between the incident types, their quantity, and the age of those who committed/experienced them. One interesting relationship that can be made noticed based on the plot below could be that collisions are more likely as you age while parking and vehicle theft remain consistent. This could be an anomaly based on the limited number of reports though so more data could either support or deny this.