1) Based on your data set, is the average age of the drivers involved in a fatal accident is significantly MORE THAN the average age of the drivers who involved in a non-fatal accident? Test at the 10% level of significance. Note that SPSS only performs a 2-sided test.

2) Provide possible reasons why you should expect to find a significant statistical difference between the ages of these 2 groups

3) Based on your findings, should the insurance company charge higher premiums based on the collision severity? Explain your reasoning

EXCEL CAN BE USED OR SPSS.

Collision Severity Data: There is 7/600= 1's

Collision Severity Data: There is also 593/600=2's

Collision Severity Data: 2 2 2 1 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 1 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 1 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 1 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 1 2 1 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 1 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2

Person Age Table: 25 24 17 38 66 26 50 2 17 21 26 31 58 5 30 45 27 66 37 75 53 26 73 85 53 40 44 22 26 36 46 18 24 62 76 40 23 15 4 6 1 25 71 41 55 62 75 76 15 63 24 44 3 55 32 58 27 19 58 53 27 45 47 54 83 37 18 27 26 48 21 24 59 18 48 20 74 8 61 27 31 72 54 55 25 25 63 24 47 21 48 66 16 19 18 35 47 73 49 37 30 40 39 28 32 65 26 73 7 18 1 18 43 43 30 19 36 17 47 31 19 34 30 40 63 58 26 70 33 34 33 13 37 53 41 48 24 46 49 29 24 18 8 82 25 25 48 68 40 23 72 47 35 17 58 25 34 42 23 52 17 30 19 33 15 29 57 63 29 30 59 17 23 37 12 16 40 81 60 18 64 44 27 2 52 44 21 25 47 31 57 17 24 40 21 49 85 39 2 63 58 54 62 67 85 57 5 19 43 18 3 40 29 70 38 25 31 3 63 59 57 19 45 55 58 49 28 55 17 33 7 65 45 8 73 22 20 17 31 40 32 52 23 25 77 25 60 37 25 46 18 21 68 60 35 16 61 22 53 30 6 21 16 22 59 67 43 51 56 29 16 35 23 59 34 54 35 22 38 24 42 20 26 23 36 29 63 20 37 51 46 25 33 28 25 29 24 30 72 61 46 22 33 16 66 55 50 58 35 27 27 47 62 34 68 44 29 36 25 84 66 35 59 37 43 20 27 42 41 59 35 45 61 50 59 16 67 20 56 5 82 54 65 42 33 39 20 40 54 30 21 18 36 52 1 33 70 46 34 26 29 57 48 41 67 21 60 10 47 26 39 64 13 33 86 74 56 42 39 56 33 59 19 35 5 67 33 75 42 45 29 7 54 59 27 3 19 42 43 29 51 91 18 81 35 53 51 69 75 24 68 32 37 43 14 44 19 19 25 29 77 33 20 25 21 45 24 27 32 59 22 18 63 3 20 34 7 36 50 41 57 62 65 50 82 71 60 50 27 67 58 55 84 30 5 17 26 22 25 51 40 56 23 22 49 16 29 69 29 33 48 42 35 5 21 69 21 37 9 36 27 72 13 50 33 77 23 68 30 35 40 31 29 20 41 79 58 60 55 35 34 40 78 51 26 48 17 23 18 58 35 54 68 49 32 46 25 22 24 49 28 31 48 44 47 55 61 45 36 34 18 19 39 55 34 21 29 69 22 31 59 18 17 5 18 24 25 31 45 31 68 36 23 94 58 48 5 42 24 23 29 42 36 15 26 72 17 52 47 89 64 59 36 59 23 61 77 54 23 23 20 25 33 39 3 21 54 35 79 14 50 16 56 43 27 31 57 72 54 51