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

alot of people are coming to claim their vehicle either had multiple vehicle collisions or just one

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

for each different time frame the claim amounts are high

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

for each time frame we had each type of incident happening not just one particlular incident

all the inicidents are happening in each time frame but their are more collisions happening than parked car and vehicle theft.

alot off people have gone through multiple and single collisions