please answer on excel

A D E 1 Insured insured si Carage Marital Carte Credit sco Region 2 62 Female 9 Married Private 836 Urban 55 Female 13 Married Commute 835 Urban 67: Female 1 Single Commute 751 Urban 5 43 Mate 9. Married Private 821 Urban 70 Female 7 Married Private 936 Rural 61 Male 7 Married Commute 836 Urban 8 30 Female 3 Single Commute 558 Urban 9 45 Male 6. Married Commute 324 Urban 10 71 Male 2 Married Private 390 Rural 11 34 Female 6 Married Private 900 Urban 12 26 Male 3 Single Commute 857 Urban 59 Male 6 Married Private 814 Urban 14 68 Male Married Private 830 Urban 19 46 Female 5 Single Commute 712 Urban 16 52 Female 4 Single Commerc 782 Rural 17 59 Female O Married Commute 730 Urban 15 39 Female 1 Married Commute 836 Urban 18 74 Malo 1 Married Private 708 Urban 20 64 Female 3 Married Private 900 Urban -48 Male 1 Single Commute 341 Urban 36 Male 4 Single Private 725 Urban 25 83 Male 9 Married Private 856 Urban 24 69 Male 3 Married Private 377 Urban 25 29 Mate O Married Private 713 Urban 28 49 Female 7 Single Commute 830 Rural 22 49 Male 2 Married Commute 772 Urban 29 71 Male 10 Married Private 900 Urban 29 47 Mala 11 Married Private 399 Urban 30 34 Male 10 Married Commute 849 Urban 17 Female 12 Single Commute 759 Rural 32 47 Male 7 Married Private 341 Urban 33 38 Female S Single Commute 687 Urban 34 32 Male 1 Married Private 792 Urban 05 31 Mala 9 Single Commute 748 Urban 38 42 Female 2 Married Private 821 Urban 37 84 Female 7 Married Private 900 Urban 38 12 Female O Married Farmer 879 Rural 39 41 Male O Married Commute 814 Urban 40 57 Male 1 Married Private 833 Urban 41 56 Female 10 Single Private 900 Urban 42 50 Female 11 Married Private 520 Urban 15 70 Female 10 single Private 859 Urban 52 Female 6 Single Commute 863 Urban 45 24 Female 6 Single 763 Urban Commute 46 47 Female 7 Married Commute 745 Urban 47 36 Male O Married Private 667 Rural 48 65 Male 7 Married Private 823 Rural 49 827 Urban 52 Female 5 Married Private 50 274 Urban 46 Male 3 Married Commute 51 771 Rural 46 Malm 2 Married Commute Annualm Years noc Territory Claim. Oce AMT_Claim 9320.57 18 12427.4 52 1242714 13 6213.71 36 6213.71 39 6213.71 64 9072.02 54 6213.71 26 12427.4 43 9320.57 68 124274 32 6213.71 37 6213.71 43 12427.4 29 15 186411 79 9320.57 86 124274 67 124274 57 69 9320.57 36 6213.71 70 6213.71 59 1 16050 S 5903.02 57 57 0 932057 39 0 6213.71 66 0 6213.71 29 89 0 12427.4 33 83 o 6213.71 54 67 0 9320.57 11 0 6213.71 33 0 o 124274 2 39 o 0 124274 0 0 6213.71 39 5213.71 64 36 6213.71 66 4401.5 6213.71 22 63 6213.71 57 9320.57 37 6213.71 12 23 124274 41 88 0 3106.86 36 86 6213 71 32 43 5213.71 54 33 6213.71 3 37 11681.8 6 61 9320.57 28 124274 39 6213.71 48 34 3106 86 24 6213.7: 72 155343 35 &BEEN CON SUSA OOOOOOOOOOOOOOOOOOO oo o o o o o o o o o o o o o o o o o o o o o o ooo ooooooooooooooooooooooooooo OOOOOO OOOOOOOOOOO OOOOOOOOOOOOOOOOOO 50 S: 52 53 54 55 58 57 58 59 60 61 60 63 64 65 66 67 88 69 70 OOOOOOOOOOOO 0 0 0 0 0 0 0 0 0 257 24 A B 62 Female 46 Male 45 Male 68 Female 60 Female 53 Female 67 Female 37 Male 32 Male 79 Male 63 Female 44 Female 41 Female 62 Female 27 Female 59 Male 54 Female 27 Male 71 Male 50 Male 48 Male 23 Female 54 Male 55 Female 40 Female 61 Male 33 Female 79 Female 52 Female 50 Malo 58 Female 80 Male 43 Female 42 Male 30 Male 35 Female 52 Malo 48 Male 63 Female 43 Male 63. Mala 76 Male 66 Female 76 Female 59 Female 63 Male 56 Male 60 Male 79 Male 79 Male 31 Male 72 79 5 Married Private 3 Married Commute 2 Married Commute 8 Married Private 5 Single Commute 1 Single Commute 7 Single Private 8 Married Commute 1 Single Commute 15 Married Private 7 Married Commute 1 Married Private 2 Married Commute 4 Married Commerc 3 Martied Commute 9 Married Private Single Private 1 Single Commute 6 Married Private 8 Single Commute 3 Married Private 2 Single Commute 5 Martied Commute 4 Married Commute 1 Married Commute 1 Married Private 12 Single Commute 10 Married Private 7 Married Private o Single Private 3 Married Commute 3 Married Private 13 Married Commute 9 Married Private 6 Single Farmer 9 Married Commute 5 Married Commute 2 Married Private 14 Single Commute S Married Commute 10 Married Private 6 Married Private O Married Private 1 Married Private 4 Married Private 11 Married Private 3 Single Commute 2 Married Commute 11 Married Private 4 Married Private 4 Single Commute F 3 327 Urban 774 Urban 771 Rural 379 Urban 900 Urban 688 Rural 757 Urban 587 Rural 796 Urban 847 Urban 900 Rural 853 Urban 816 Rural 798 Urban 791 Urban 563 Urban 752 Urban 347 Urban 831 Urban 849 Rural 861 Urban 853 Urban 615 Urban 847 Urban 833 Urban 868 Urban 770 Urban 900 Urban 820 Urban 842 Urban 858 Rural 900 Urban 712 Urban 841 Rural 862 Rural 638 Urban 847 Urban 848 Urban 798 Urban 776 Urban 877 Urban 900 Urban 786 Rural 734 Urban 839 Urban 859 Urban 868 Urban 900 Urban 900 Rural 897 Urban 760 Urban 3106.86 6213171 155343 9320.57 186411 124274 6213.71 6213.71 9320.57 6213.74 12427.4 3106.86 12427.4 124274 6213.71 6213.71 3728,23 124274 6213.71 12427.4 6275.35 6213.71 9320.57 6213.71 12427.4 3106.86 9320.57 6213.71 12427.4 6213.71 9941.94 6213.71 12427.4 6213.71 124274 9320.57 12427.4 6213.71 6213.71 6213.71 4970.97 12427.4 9320.57 6213.71 6213.71 12427.4 6213.71 12427.4 9320.57 9320.57 9320,57 24 72 86 27 29 52 91 24 36 18 84 62 39 54 60 62 14 31 26 86 74 59 38 99 63 12 36 90 38 73 86 69 43 8 28 48 43 41 52 20 17 57 37 6 23 44 9 19 34 11 48 34 3 9 31 19 23 39 13 60 45 29 41 63 24 26 14 8 2 28 38 26 26 54 46 42 38 47 13 39 65 63 13 1 878.939 75 776 77 78 379 80 43 182 83 84 BS 88 87 08 89 immmmm $ 53588 588 84 38 54 32 84 57 SO 62 67 89 36 35 82 68 32 38 36 39 94 1 1027.71 0 20 33 38 65 86 59 64 35 12 OOOOOO 0 76 2 10 48 39 0 o 0 g B 54 Female 49 Male 41 Female 29. Mata 27. Female 38 Mate 50 Mala 58 Mata 68 Male 05 Male 48 Female 73 Female 42 Female 731 Female 27 Female 27: Female 65 Female 40 Female 67 Male 65 Male 71 Female 36 Male 72 Female 62 Female 31 Mala 20 Female 44 Male 53 Female 45 Male 36 Female 33 Female 35 Male 75 Female 31 Female 32 Male 40 Female 52 Female 74 Male 68 | Female 3 Male 56 Female 4 Male 29. Malo 27 Female 57 Male 24 Female 02 Mole 41 Mile 47 Female Male Samole 28 8 82 74 D E 3 Married Private 13 Single Commute 11 Married Commute 11 Married Commute O Married Private 6 Married Commute 6 Martied Private 2. Married Private 1 Married Private 3 Married Private 6 Married Commute 10 Married Private 2 Married Private Married Private 2 Single Commute 7. Single Commute 8 Married Private 5 Married Private 8 Marted Private 7 Married Commute 7. Married. Private 14 Married Private 4 Single Private 9 Single Commute 13 Single Private 9 Single Private I Married Commute -1 Single Commute 1 Married Commerc 5 Married Commute 11 Single Commute 7 Single Commute 9 Married Private 6 Married Private 2 Married Commute 1 Married Commute 11 Married Commute 3 Married Private 7 Marned Private O Married Private 11 Married Comenute 1 Married Commute 10 Married Commute 12 Single Commute 8 Married Private ang Commute 6 Single Commute O Married Private 1 Marded Commute Married Private 10 binele Commute OOOOOOOOOOOooola o GD OOOOOOO 1303.28 0 F 813 Rural 824 Urban 644 Rural 807 Urban 878 Rural 853 Urban 850 Urban 545 Rural 340 Rural 807 Rural 885 Urban 795 Urban 340 Urban 275 Urban 862 Urban 622 Rural 852 Rural 799 Urban 351 Rural 812 Urban 850 Urban 692 Urban 829 Rural B56 Urban 522 Urban 833 Rural SSO Urban 881 Urban 314 Urban 358 Rural 828 Urban 853 Urban 844 Urban 900 Urban 690 Urban 823 Urban 746 Urban 847. Urban 868 Rural 831 Urban 687 Urban 752 Rural 753 Urban 345 Urban 757 Urban 642 Urban 333 Urban 714 Urban 710 Urban 759 Diban 453 Urban H 124274 6213.71 6217 9320.57 6213.71 6213.71 6213.71 12427.4 9320.57 15534.3 9320.57 6213.71 6213.71 6213.71 12427.4 9320.57 6213.71 6213.71 3106.86 21748 6213.71 6213.71 6213,74 6213.71 3106.85 6213.71 9920.57 7456.45 18641.2 15534.3 6213.71 6213.71 12427.4 12427.4 6835 03 124274 3728,23 6213.71 6213.71 6213.71 155343 154721 6213.71 12427.4 4970,97 9320.57 9320.52 124274 621371 9320.57 62121 18 91 988869888898 OOOOOO 30 71 91 19 15 0 g 31 o 88 46 42 15 72 30 1937 136 sa 10 101 1.2 149 8 57 8 48 27 27 11 35 79 NONNASSA OOOOOOOOOOOOOOOOOO OOOOOOOOOOOOOOOOOO 34 2560.78 145 NG NY 40 19 10 24 30 39 12 03 @ 27 43 S7 31 33 S 43 64 96 54 35 39 57 OOOOOOOOOOO oooooooooooooOOOOO . 26 84 35 65 63 30 75 23 31 43 18 81 33 73 39 18 KESAN O 26 5 174 A B 51 66 Male 32 59 Female 53 75 Female 54 53 Male 55 49 Male 56 24 Female 57 50 Female 58 65 Female 159 48. Female 180 63 Male 361 32 Female 162 58 Female 163 65 Female 354 39 Female 5165 58 Male 188 35 female 767 55 Male 166 65 Female 283 58 Female 46 Male 171 76 Male 172 50 Mala 173 58 Male 62 Female IS 38 Male 63 Male TRA 56 Male 178 59 Male Ta 89 Mala 100 46 Male 42 Female 182 46 Male 163 50 Female 184 68 Female 185 57 Male 108 38 Male 187 34 Male 168 40 Male 139 59 Male 190 51 | Female 47 Male 182 78 Female 133 45 Male 28 Male 199 70 Mo 196 45 Male AP 149 Female 139 63 Famale 39 Male 200 57 Female 40 Femala 37 D E 7. Married Private Married Commute 7. Married Farmer 13 Martied Commare 7 Married Commute 4. Single Commute 2 Married Commute 4 Married Private 7 Married Private 15 Single Commute 5 Single Commute 8 Married Private O Married Farmer O Married Private 1 Married Private O Single Private 13 Married Private 4 Married Private 1 Married Commute 1 Married Commute 8 Married Private 11 Single Commute 10 Married Private 7 Single Private 4 Married Commute 14 Married Private 10 Single Private 8 Married Commute 9 Married Private 7 Married Private 1 Single Private 5 Married Commute 9 Single Private 4 Single Private 13 Married Commerc 6 Married Commute 7 Married Commute 3 Married Commute 7 Martied Commute 6 Married Private A Married Commute 2 Married Private O Married Commute 6 Married Commute 5 Married Private 1 Single Commute O Married Private Single Commute Married Private o single Commute Single Commute F G 838 Urban 814 Urban 993 Urban 341 Urban 683 Urban 624 Urban 814 Urban 838 Urban 880 Urban 696 Urban 863 Urban 848 Urban 900 Urban 745 Urban 756 Urban 583 Urban 346 Urban 900 Rural 842 Urban 832 Urban 900 Urban 444 Urban 636 Urban 847 Rural 639 Rural 834 Rural 797 Rural 822 Urban 895 Urban 832 Urban 642 Urban 874 Rural 330 Rural 745 Rural 323 Urban 887 Urban 737 Urban 818 Rural 733 Urban 227 Urban 794 Rural 276 Urban 750 Urban 457 Urban 871 Urban 712 Rural 813 Rural 883 Urban 776 Urban 981 Urban 948 Urban B 124274 12427.4 6213.71 6213.71 12427.4 9320.57 6213 71 12427.4 6213.71 932052 12427.4 6213.71 9320.57 6213.71 9320.57 186411 4970.97 5213.71 12427.4 9320.52 6213.71 124274 6213 71 6213.71 124274 12427.4 733218 124274 6835.08 124274 124274 124274 12427.4 7456,45 12427.4 124274 155343 9320.57 12427.4 3106.86 124274 9941.94 9320,57 9920.57 124274 124274 124274 621371 6213.71 12427 4 7456 49 0 0 0 F%sa88 Ansum 84 26 79 36 31 79 0 0 121 36 43 73 22 25 6 34 46 24 21 8 0 37 43 24 74 43 75 43 18 39 52 73 35 29 53 24 393INESS TOOOOOOOOOOOOOOOOOOOOOOOO 43 20 OOOOOOOOOOOO 20 25 32 32 39 72 12 12 24 05 199 300 201 202 203 112 12 57 38 33 OOOOOOOO 200 16 37 24 53 9 18 47 28 15 34 58 53 52 18 23 16 38 , 205 200 207 208 209 210 211 212 213 24 2015 218 217 218 219 220 221 69 58 78 34 39 10 OOO 36 22 3 A B 39 Mate 52 Female 40 Female 70 Male 26 Female 34 Female 54 Female 45 Female 31 Female 51 Mala 78 Mala 69 Male 70. Male 40 Female 66 Male 37 Female 76 Male 65 Female 59 Male 27 Mate 30 Female 54 Male 37 Female 24 Female 60 Male 79 Male 64 Male 38 Male 31 Male 68 Female 70 Female 71 Male 66 Male 54 Mala 53 Male 58 Male 31 Male 32 Male 61 Male 82 Male 41 Male 43 Female 52 Female 38 Femalo 63 Male 33 Male 64 Mala 64 Malo 37 Male 73 Female 89 Female 54 E 8 Married Private O Single Commute 2 Single Commute O Married Private 7 Single Commute 8 Single Commute 2 Married Private 5 Married Commute 1 Married Private O Married Commerc 5 Single Private 1 Married Private 17 Married Private 5 Married Commute O Married Private 4 Single Commute 5 Married Commute 1 Single Private 9 Single Commute 5 Single Commute 2 Single Commute 5 Single Commute 1 Married Private o Married Commute 12 Married Commute 8 Martied Private 2 Married Private 1 Single Commute 9 Single Commute 8 Single Commute 1 Married Commute S Married Private 3 Married Private 9 Married Commute 3 Single Commute 6 Married Private 4 Single Commute 4 Married Farmer 4 Married Private 6 Married Private 2 Married Commute O Married Commute 7 Married Commute B Married Commute 4 Married Private 4 Single Commute 8 Married Private Married Commute 6 Married Commute 2 Married Farmer 1 Single Commute 776 Urban 731 Urban 748 Urban 900 Orban 796 Urban 815 Urban 345 Urban 315 Urban 364 Urban 513 Rural 877 Urban 863 Urban 777 Urban 570 Rural 347 Urban 694 Urban 886 Rural 8.84 Urban 889 Urban 744 Urban 543 Rural 831 Urban 715 Urban 686 Urban 817 Urban 900 Urban 900 Urban 325 Urban 346 Urban 900 Rural 857 Urban 935 Rural 840 Rural 846 Urban 741 Rural 839 Rural 863 Urban 778 Rural 807 Rural 892 Urban 713 Urban 691 Rural 706 Urban 356 Urban 839 Rural 945 Urban 830 Urban 842 Urban 870 Urban 857 Rural 666 Urban H 621371 124274 7456,45 32427.4 124274 124274 124274 12427.4 7456,45 124274 6213,73 9320.57 6213.71 12427-4 6213.71 12427.4 12427.4 11184.7 5213.71 9320,57 12427,4 12427.4 6213 71 1242714 12427.4 6213.71 6213.71 932057 124274 6213.71 6213.71 6213.71 124274 6213.21 18641.1 124274 12427.4 12427.4 124274 6213.71 6213.71 6213.71 6213.71 6213.71 124274 6213.71 6213.71 6213.71 6213.71 6213.71 6213.71 0 0 0 0 0 O 0 0 0 g o 0 g o o a 0 0 0 o 0 0 1987 111 0 0 0 0 0 0 0 0 0 60 72 + u. BE 4 + 8 w &&&&&SNRS SNESS 74 5 49 41 53 50 26 32 OOOOOOOOOOOOOOO 70 33 0 0 38 200 201 232 289 234 235 2361 237 238 239 240 241 2 22 243 245 246 247 248 249 13 16 41 66 25 24 7 22 45 7 43 49 OOOOOOOOOOOOOOOOOO 0 0 0 0 74 OOOO 56 4 24 03 - G C H 0 347 248 249 250 251 OO 2 GOOOOOOO 25 284 25 362 59 258 259 360 27 20 30 21 33 H 15 43 RO 26 264 285 265 267 32 36 18 A B 37 Male 73 Female 39 Female 44 Female 22 Male 43 Female 38 Male 59 Female 26 Female 49 Female 39 Female 49 Male 24 Female 37 Male 19 Male 60 Male 57 Male 58 Female 59 Male 60 Male 54 Female 54 Female 34 Male 40 Male 69 Female 47 Male 52 Male 54 Male 45 Female 54 Male 54 Male 41 Female 38 Female 33 Female 52 Female 76 Famate 49 Female 66 Female 72 Female 37 Male 33 Female 75 Female 43 Male 40 Male 7 Male 48 Female 53 Male 60 Female 40 Female 62 Male Male 209 20 6 Married Commute 2 Married Farmer 1 Single Commute 7. Married Commerc 33 Single Commute 3 Married Commute 1 Single Commute 10 Single Private 4 Single Commute 3 Married Commute 9 Martied Commute 5 Married Commute 4 Single Commute 4 Single Commute 3 Married Commute 12 Single Commute 6. Married Private 6 Single Private 2 Married Private 5 Married Commute O Married Commute 5 Single Commute 3 Single Commerc 1 Married Commute 4 Married Private -1 Married Commute Married Commute 12 Married Private 3 Married Private 14 Married Commute 6 Married Private O Married Commute 7. Married Commute 1 Married Commute 8 Married Commute 7. Single Private 14 Single Private 3 Married Private 7 Single Private 9 Married Private 11 Single Private 4 Married Private 2 Married Commute 9 Single Commute 11 Single Privata 4 Single Commute 3 Married Commute 11 Single Private 5 Married Commute 10 Single Private 6 Single Commute G 870 Urban 357 Rural 555 Urban 383 Urban 304 Urban 313 Rural 651 Urban 709. Urban 350 Urban 720 Rural 840 Urban 363 Urban 664 Urban 533 Urban 846 Rural 349 Rural sso Urban 772 Rural 900 Urban 805 Urban 323 Urban 752 Urban 842 Urban 359 Urban 755 Urban 835 Urban 345 Urban 701 Rural 735 Rural 770 Urban 314 Urban 793 Rural 836 Rural 550 Urban 578 Urban 850 Urban --- 377 Urban 393 Urban 307 Urban 353 Urban 344 Rural 900 Rural 531 Urban 782 Rural 598 Rural 774 Urban 831 Urban 566 Urban SOO Urban 756 Urban 352 Rural 6213.71 62237 6213.71 12427.4 9320.57 9320.57 7456 45 6213.71 18670.2 12427.4 124274 6213.71 12427 4 9320.57 12427.4 6213.71 4349.6 12427.4 621373 12427.4 12427.4 9258.43 372523 3106.86 12427.4 6213.71 12427.4 3106.36 12427.4 6213.71 6213.71 12427,4 12427.4 6213.71 12427.4 6213.71 6213.71 6213.71 6213.71 6213.71 6213.71 6213.71 6213.71 12427.4 6213.71 124274 7456.45 6213.71 6213.71 6213.71 12427.4 1575,551 0 0 0 3848.4 D O 0 0 0 0 0 1 0 0 o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o 0 0 0 0 0 0 0 MSNBERGHAUSHBUB BUNS 74 BG 24 33 14 31 16 72 35 39 18 52 63 65 52 84 83 86 73 31 56 14 26 66 12 39 63 79 38 57 68 57 87 68 57 13 35 14 31 39 18 82 31 37 24 33 66 52 51 43 35 46 24 2731 274 275 26 0 0 0 278 279 280 20 0 0 0 0 0 0 0 54 20 282 283 284 205 386 LOOOOOOOOOOOOOOOOOO 27 24 58 23 RENS 368 00OOOOOOOOOOOO 03 93 299 300 801 35 43 50 312 79 Tololo DODOO 32 800 041 IS o o o o o o o o o o - 800 16 4 300 1352:5 35 7 19 34 32 1 0 0 0 0 368 310 311 312 313 314 315 316 317 310 319 35 1 0 262.51 a 0 0 0 O 0 A 5 70 Mato 5 Female 29 Female 79 Female 43: Male 52 Male 46 Male 41 Male 44 Male 51 Female 53 Female 28 Female 36 Male 53 Female 53 Female 71 Female 56 Male 44 Male 49 Male 35 Female 25 Female 36 Female 68 Female 66 Male 80 Male 52 Female 62 Male 61 Female 61 Male 56 Male 43 Male 51 Female 51 Female 42 Female 49 Female 27 Female 35 Female 31 Female 54 Female 33 Male 41 Female 39 Female 36 Male 74 Male 24 Male 62 Female 26 Male 53 Female 30 Female 58 Female 65 Fernate 5 Single Private 4 Martied Commute 2 Married Private 9 Married Private 3 Married Private 21 Single Private 9 Married Commute 1 Single Commute O Married Private 3 Single Commute 7. Married Private o Single Commute 1 Single Commute 9 Single Private 5 Married Commute 1 Married Private 1 Married Commute 1 Married Commute 7 Married Commute 12 Married Private B Married Commute 3 Married Private 1 Married Private 9 Married Commute 12 Married Private 8 Married Commute 4 Married Commute 4 Single Private 3. Married Private 5 Married Commute O Married Private 3 Married Commute 4 Married Commute 4 Married Commute o Married Commute 8 Single Commute -1 Married Commute 6 Single Private S Married Private 3 Single Commute 2 Single Commute 1 Married Commerc 8 Single Commute 1 Married Private 9 Single Commute O Married Private Married Private O Single Private 7 Married Private 19 Married Private 11 Single Private F 340 Urban SG3 Urban 592 Urban 900 Rural 742 Rural 745 Urban 821 Urban 334 Rural 302 Urban 900 Urban 715 Urban 339 Urban 816 Rural 856 Urban 776 Urban 344 Urban 333 Urban 773 Urban 261 Urban 526 Urban 799 Urban 339 Urban 389 Urban 772 Urban 832 Urban 755 Urban 858 Rural 828 Rural 814 Urban 840 Urban 799 Urban 832 Urban 345 Urban 723 Urban 749 Urban 817 Urban 645 Urban 619 Urban 810 Urban 740 Urban 761 Urban 552 Urban 799 Urban 843 Urban 357 Urban 348 Urban 696 Rural 900 Urban 576 Urban 792 Urban B16 Urban 0 4970 97 111847 4970.97 6213.71 621371 5213.71 621371 155343 6213.73 6213.71 124274 62137 124224 6233.92 12427.4 5213.71 124274 12427.4 621371 6213.71 124274 6213.71 6213.71 623372 6213.71 6213.75 186411 12427.4 311347 12427.4 5213.71 7456.45 5213.71 621373 186411 12427.4 12427.4 186411 6213.71 124274 12427.4 135410 124274 9320.57 621371 6213 7: 124274 6213.71 113347 6215.73 6213.72 0 24 25 326 397 WEB KESO BAGSUSUN BERNAMA OSAGARCANERES RSSG 0 0 6 25 380 831 30 333 334 835 336 16 OOOOOOOOOOOOOOOOOOOOOOOO 17 337 30 1781 38 3.0 341 3:2 23 4 345 340 OOOOOOOOOOOOOOO 7 3 03 A F. H Das 350 351 982 353 54 359 31 26 30 39 60 74 33 15 81 54 61 357 OOOOOOOOOOOOOOOO SSS 380 361 0 O 383 384 255 282 98 0 0 0 0 0 0 0 0 O 370 0 0 38 Female 30 Female 33 Female 52 Mate BS Male 51 Male 43 Female 48 Male 65 Female GO Male 70 Male 67 Mele 72 Female 26 Male 43 Female 53 Female 65 Male 57 Female 51 Female 73 Female 36 Male 49 Male 58 Male 55 Female 50 Male 50 Female 55 Male 68 Male 53 Female 75 Female 59 Male 45 Female 48 Female 39 Female 28 Female 41 Male 57 Male 43 Female 34 Female 59 Female 47 Female 49 Mald 55 Male 53. Malo 33 Male 67 Male 70 Male 56 Female 54 Male 73 Famil 46 Male 0 E 0 Married Private 1 Married Commute 10 Single Private 2 Married Private 4 Married Private 6 Single Commute 6 Single Private 15 Married Commute 10 Married Private 6 Single Commute 12 Married Private 3 Married Private 3 Married Private O Single Commute Married Private 14 Married Commute 1 Married Private 4 Married Private 6 Married Commute 5 Married Private 2 Married Commute 5 Married Private 1 Married Private 1 Single Private 15 Married Commute 2 Married Commute 2 Married Commute 12 Married Private 2 Single Private 3 Married Farmer 2 Married Commerc 2 Single Private 10 Married Commute 9 Married Commute 2. Single Commute 10 Single Private 3 Married Commute 5 Married Commute 9 Single Commute 5 Single Commute 5 Single Commute 4 Married Private 15 Married Commute Married Commers 4 Single Commute o Married Commute Married Private 1 Married Private O Strigle Commare Married Private Married Commute 0 874 Rural 872 Urban 661 Urban 332 Rural 888 Urban 340 Urban 694 Urban 870 Urban 847 Rural 770 Urban 831 Urban 897 Urban 897 Urban 349 Urban 803 Urban 845 Urban 797 Urban 779 Rural 846 Urban 872 Rural 566 Rural 749 Rural 900 Urban 52 Urban 710 Urban 803 Urban 719 Urban 900 Urban 852 Urban 784 Rural 343 Urban 813 Urban 685 Urban 695 Urban 824 Urban 623 Urban 885 Urban 595 Urban 795 Urban 779 Rural 810 Urban 38 Urban 886 Rural 705 Orban 760 Urban 799 Urban 594 Urban 514 Rural 562 Urban 782 Rural 863 Rural 6233.71 7456.45 6213.71 6213.71 3728 23 6213.71 6213.71 124274 5592 34 9320.57 6213.71 6213.73 6213.71 124274 6213.71 6213.71 124274 8699.19 5213.71 6213.71 6213.71 12427.4 9320.57 4970.97 1553413 12427.4 6213171 3106.86 6213.71 155343 186411 6213.71 12427.4 15534.3 6213.71 9320.57 9320,57 6213.71 6213.71 7456,45 6213.71 124274 155343 12427.4 6213.71 9320.52 12427.4 6213.71 124274 124274 9320.57 19 8 6 35 69 22 19 26 48 42 49 47 47 10 24 21 49 40 35 53 20 32 37 37 33 33 30 52 36 52 42 27 32 22 9 15 40 6 2 7 31 32 35 36 7 50 53 32 10 29 30 D OOOOOOO 0 S78 522 $ Syg 380 361 382 383 88 67 72 59 87 85 71 38 31 79 72 74 35 62 35 38 88 85 43 84 32 24 37 88 89 65 71 85 Ba 91 32 35 74 26 18 73 78 314 1 O O 0 1 497 302 0 089 329 OOOOOOOOOOOOOOOOOO OOOOOOOOOOOOOO 1144.59 397 198 188 03 B 12 33 73 74 400 401 403 403 404 405 405 40V 400 OOOOO ooOOOO 15076.47 Basws UBE 0 0 90 11 12 413 14 47 22 49 22 32 28 19 54 56 24 13 16 36 57 1 14 80 72 417 17 0 0 0 0 0 0 0 0 0 0 o 0 O 1491-652 0 o 25 73 59 47 420 401 422 23 424 425 426 427 31 35 Female 51 Male 51 Female 39 Female 77 Female 63 Male 45 Male 47. Female A Female 73 Male 74 Male 41 Female 33 Female 34 Male 53 Female 73 Female 26 Male 55 Male 45 Femala 57 Male 63 Male 78 Male 53 Female 66 Male 63 Male 74 Female 37. Female 74 Female 29 Female 58 Female 51 Male 60 Male 66 Female 30 Male 67 Female 29 Male 74 Male 60 Male 23 Male 67 Male 25 Male 64 Mald 71 Male 41 Female 7A Female 49 Male 66 Male 52 Famala 56 Female 72 Main HOM E 6 Married Commute 12 Married Commute 9 Single Commute 5. Married Commute 3 Married Private 8 Married Commute 6 Single Commute 2 Married Commute 9 Married Private 9 Married Private 1 Married Private 3 Married Commute 7 Single Commute 8 Married Commute 4 Married Commute 10 Married Private 12 Single Commute 10 Married Private 5 Married Private 6 Married Private 6 Married Private 12 Married Private 1 Married Private 3 Married Commute 8 Married Farmer 17 Married Private 1 Married Commute 17 Married Private 1 Married Commute 2 Married Private O Married Commute 4 Married Private 1 Married Private 10 Married Commute 13 Single Private 4 Single Commute 8 Married Private S Married Private 12 Single Commute 2 Married Private 8 Single Commute 2 Married Private O Married Private 7 Single Commute 3 Married Private 1 Married Private 11 Single Private 13 Married Private 10 Married Private 4 Mamed Private 1 Married Private + 321 Urban 332 Urban 738 Urban 596 Urban 848 Urban 802 Urban 900 Orban 617 Urban 574 Urban 900 Rural 356 Urban 811 Urban 838 Urban 535 Urban 369 Urban 900 Rural 634 Urban 850 Urban 394 Urban 343 Urban 785 Urban 825 Urban 327 Urban 803 Urban 850 Rural 900 Orban 826 Urban 900 Urban 853 Urban 852 Urban 816 Urban 305 Rural 382 Urban 663 Rural BOS Urban 714 Rural 900 Rural 851 Urban SOS Urban 366 Urban 577 Urban 732 Urban BOS Urban 730 Urban 900 Urban 838 Rural 310 Urban 378 Urban 304 Rural 849 Rural 377 Rural 621371 224274 124274 12427.4 6213.71 5213.71 124274 6213.71 7456 45 6213.71 6213.71 521373 6213.71 124274 9941 94 6835.00 6213.71 932057 9320 57 12427 4 6213.71 6213.71 6213.71 24912.9 9320.57 3106 85 6213.71 3106.86 6213.71 6213.71 12427.4 9320.57 6213.71 9320.57 6213.71 18641.1 6213.71 6213.71 6213.71 9320.57 12427.4 12427.4 6213.71 12427.4 6213.71 6213.72 6213.71 6213.71 6213.71 6213.71 5213:23 ww888888888888888889W8 24 0 90 429 430 98 0 1 3425.97 0 25 32 433 D 434 135 438 437 438 189 140 4 42 03 DOOOOOOOOOOOOOOOOOOOOOOO o BISMO BE 32 60 5 446 GOOOOO 50 43 118 449 450 F 51 28 0 11205 52 O 7 0 DO 0 452 493 4154 155 456 457 48 158 480 461 1162 463 UFA 969 OOOO 45 0 0 0 0 4.68 0 O 467 489 469 470 471 472 4.78 474 415 476 477 4781 6 A B 53 Mate 42 Male 66 Femala 26 Female 53 Male 24 Female 26 Female 70 Female 32 Male 57 Male 71 Male 68 Male 33 Male 47 Female 35 Male 43 Male 28 Male 35 Mate 26 Female 35 Female 46 Femala 30. Female 28 Female 57 Male 28 Male 46 Female 51 Mala 51 Female 32 Male 25 Female 71 Female 38 Mala 19 Female 68 Male 60 Female 55 Male 67 Female 68 Female 59. Female 58 Female 33 Male 31 Male 28 Female 26 Male 70 Male 74 Female 38 Male 57 Female 76 Male 72 Male 3 Female 25 59 Married Commute 13 Married Commute 8 Married Commute 7 Single Cornute 8 Married Private o Single Commute 9 Single Private 1 Sinele Private 2 Single Commute 9 Married Commute 16 Married Private 1 Single Private 7 Married Commute 10 Married Commute 2 Married Commute 8 Married Commute 1 Single Commute 1 Married Private 5 Single Commute 3 Married Commute 6 Married Private 12 Married Private 1 Single Commute o Married Commute 9 Married Private 2 Married Commute 9 Married Commute 1 Married Private 12 Married Commute 9 Married Private 9 Married Private 1 Married Commute 7 Single Commute 8 Married Private 10 Married Private 5 Married Private 3 Married Private 9 Married Private 11 Married Commute 8 Married Private 13 Single Commute 4 Single Commute 1 Married Commute 12 Married Commute 3 Married Private 8 Married Private S Married Commute 9 Married Farmer B Married Private 11 Married Private 9 Single Private 77 62 90 79 34 30 30 35 74 177 14 52 31 37 33 75 66 18 54 33 52 32 31 87 74 38 35 66 73 39 32 60 326 Urban 327 Urban 310 Urban 575 Rural 771 Urban 752 Rural 375 Urban 794 Urban 817 Urban 346 Urban 304 Urban 735 Urban 840 Urban 303 Urban 661 Urban 643 Rural 854 Urban 832 Urban 613 Urban 817 Urban 875 Urban 790 Urban 763 Urban 900 Urban 785 Urban 884 Rural 359 Urbon 360 Urban 835 Urban 795 Rural 393 Urban 679 Urban 768 Urban 794 Rural 811 Urban 728 Urban 878 Urban 900 Urban 742 Rural BB2 Urban 734 Urban 802 Urban 671 Rural 835 Urban 851 Urban 570 Urban 772 Urban 894 Urban 840 Urban 339 Rural 825 Urban 0 0 0 0 0 0 0 0 124274 9320.57 155343 6213.71 5213.71 932057 621371 6215.71 124274 6213.71 3106.36 3723.23 16155.6 5213.71 7455 45 12427.4 124274 12427.4 12427.4 6213.71 6233.71 6213.71 559234 124274 6213.71 12427.4 12427.4 6213.71 621378 6213.71 2455.48 12427.4 6213.71 9320.57 6213.71 9320.57 6213.71 124274 6213.71 621373 6213.71 6213.71 6213.71 12427.4 9320.57 6213 71 621371 124274 124274 6213.71 621370 B8%8TwwBaw 30 0 28. % 8 Bit 43 0 479 o 0 0 46 0 3 180 481 482 483 484 465 488 187 489 189 490 13 75 81 24 401 37 45 SO 41 41 15 14 15 31 61 64 OOOOOOOOOOOOOOOOOOOOO 1 2079 28 191 OOOOOOOOOOOOOOOOOO 9 46 44 493 494 495 498 197 198 198 300 21 40 60 53 16 32 26 18 77 37 28 62 54 1 a) Based on your data set, is the average years of no claims ("Years,noclaims) of male drivers is significantly MORE THAN the average years of no claims ("Years.noclaims) of female drivers? Test both critical value and p-value approaches at the 8% level of significance. Note that SPSS only performs a 2-sided test. b) Based on your data set, is the relative claim frequency of the female drivers is significantly LESS THAN the relative claim frequency of the male drivers who involved in an accident? Test at the 12% level of significance. c) Provide possible reasons why you should expect to find a significant statistical difference between the genders. 5 d) Based on your findings, should the insurance company charge higher premiums based on the gender? Explain your reasoning. Should different tests have been conducted? A D E 1 Insured insured si Carage Marital Carte Credit sco Region 2 62 Female 9 Married Private 836 Urban 55 Female 13 Married Commute 835 Urban 67: Female 1 Single Commute 751 Urban 5 43 Mate 9. Married Private 821 Urban 70 Female 7 Married Private 936 Rural 61 Male 7 Married Commute 836 Urban 8 30 Female 3 Single Commute 558 Urban 9 45 Male 6. Married Commute 324 Urban 10 71 Male 2 Married Private 390 Rural 11 34 Female 6 Married Private 900 Urban 12 26 Male 3 Single Commute 857 Urban 59 Male 6 Married Private 814 Urban 14 68 Male Married Private 830 Urban 19 46 Female 5 Single Commute 712 Urban 16 52 Female 4 Single Commerc 782 Rural 17 59 Female O Married Commute 730 Urban 15 39 Female 1 Married Commute 836 Urban 18 74 Malo 1 Married Private 708 Urban 20 64 Female 3 Married Private 900 Urban -48 Male 1 Single Commute 341 Urban 36 Male 4 Single Private 725 Urban 25 83 Male 9 Married Private 856 Urban 24 69 Male 3 Married Private 377 Urban 25 29 Mate O Married Private 713 Urban 28 49 Female 7 Single Commute 830 Rural 22 49 Male 2 Married Commute 772 Urban 29 71 Male 10 Married Private 900 Urban 29 47 Mala 11 Married Private 399 Urban 30 34 Male 10 Married Commute 849 Urban 17 Female 12 Single Commute 759 Rural 32 47 Male 7 Married Private 341 Urban 33 38 Female S Single Commute 687 Urban 34 32 Male 1 Married Private 792 Urban 05 31 Mala 9 Single Commute 748 Urban 38 42 Female 2 Married Private 821 Urban 37 84 Female 7 Married Private 900 Urban 38 12 Female O Married Farmer 879 Rural 39 41 Male O Married Commute 814 Urban 40 57 Male 1 Married Private 833 Urban 41 56 Female 10 Single Private 900 Urban 42 50 Female 11 Married Private 520 Urban 15 70 Female 10 single Private 859 Urban 52 Female 6 Single Commute 863 Urban 45 24 Female 6 Single 763 Urban Commute 46 47 Female 7 Married Commute 745 Urban 47 36 Male O Married Private 667 Rural 48 65 Male 7 Married Private 823 Rural 49 827 Urban 52 Female 5 Married Private 50 274 Urban 46 Male 3 Married Commute 51 771 Rural 46 Malm 2 Married Commute Annualm Years noc Territory Claim. Oce AMT_Claim 9320.57 18 12427.4 52 1242714 13 6213.71 36 6213.71 39 6213.71 64 9072.02 54 6213.71 26 12427.4 43 9320.57 68 124274 32 6213.71 37 6213.71 43 12427.4 29 15 186411 79 9320.57 86 124274 67 124274 57 69 9320.57 36 6213.71 70 6213.71 59 1 16050 S 5903.02 57 57 0 932057 39 0 6213.71 66 0 6213.71 29 89 0 12427.4 33 83 o 6213.71 54 67 0 9320.57 11 0 6213.71 33 0 o 124274 2 39 o 0 124274 0 0 6213.71 39 5213.71 64 36 6213.71 66 4401.5 6213.71 22 63 6213.71 57 9320.57 37 6213.71 12 23 124274 41 88 0 3106.86 36 86 6213 71 32 43 5213.71 54 33 6213.71 3 37 11681.8 6 61 9320.57 28 124274 39 6213.71 48 34 3106 86 24 6213.7: 72 155343 35 &BEEN CON SUSA OOOOOOOOOOOOOOOOOOO oo o o o o o o o o o o o o o o o o o o o o o o ooo ooooooooooooooooooooooooooo OOOOOO OOOOOOOOOOO OOOOOOOOOOOOOOOOOO 50 S: 52 53 54 55 58 57 58 59 60 61 60 63 64 65 66 67 88 69 70 OOOOOOOOOOOO 0 0 0 0 0 0 0 0 0 257 24 A B 62 Female 46 Male 45 Male 68 Female 60 Female 53 Female 67 Female 37 Male 32 Male 79 Male 63 Female 44 Female 41 Female 62 Female 27 Female 59 Male 54 Female 27 Male 71 Male 50 Male 48 Male 23 Female 54 Male 55 Female 40 Female 61 Male 33 Female 79 Female 52 Female 50 Malo 58 Female 80 Male 43 Female 42 Male 30 Male 35 Female 52 Malo 48 Male 63 Female 43 Male 63. Mala 76 Male 66 Female 76 Female 59 Female 63 Male 56 Male 60 Male 79 Male 79 Male 31 Male 72 79 5 Married Private 3 Married Commute 2 Married Commute 8 Married Private 5 Single Commute 1 Single Commute 7 Single Private 8 Married Commute 1 Single Commute 15 Married Private 7 Married Commute 1 Married Private 2 Married Commute 4 Married Commerc 3 Martied Commute 9 Married Private Single Private 1 Single Commute 6 Married Private 8 Single Commute 3 Married Private 2 Single Commute 5 Martied Commute 4 Married Commute 1 Married Commute 1 Married Private 12 Single Commute 10 Married Private 7 Married Private o Single Private 3 Married Commute 3 Married Private 13 Married Commute 9 Married Private 6 Single Farmer 9 Married Commute 5 Married Commute 2 Married Private 14 Single Commute S Married Commute 10 Married Private 6 Married Private O Married Private 1 Married Private 4 Married Private 11 Married Private 3 Single Commute 2 Married Commute 11 Married Private 4 Married Private 4 Single Commute F 3 327 Urban 774 Urban 771 Rural 379 Urban 900 Urban 688 Rural 757 Urban 587 Rural 796 Urban 847 Urban 900 Rural 853 Urban 816 Rural 798 Urban 791 Urban 563 Urban 752 Urban 347 Urban 831 Urban 849 Rural 861 Urban 853 Urban 615 Urban 847 Urban 833 Urban 868 Urban 770 Urban 900 Urban 820 Urban 842 Urban 858 Rural 900 Urban 712 Urban 841 Rural 862 Rural 638 Urban 847 Urban 848 Urban 798 Urban 776 Urban 877 Urban 900 Urban 786 Rural 734 Urban 839 Urban 859 Urban 868 Urban 900 Urban 900 Rural 897 Urban 760 Urban 3106.86 6213171 155343 9320.57 186411 124274 6213.71 6213.71 9320.57 6213.74 12427.4 3106.86 12427.4 124274 6213.71 6213.71 3728,23 124274 6213.71 12427.4 6275.35 6213.71 9320.57 6213.71 12427.4 3106.86 9320.57 6213.71 12427.4 6213.71 9941.94 6213.71 12427.4 6213.71 124274 9320.57 12427.4 6213.71 6213.71 6213.71 4970.97 12427.4 9320.57 6213.71 6213.71 12427.4 6213.71 12427.4 9320.57 9320.57 9320,57 24 72 86 27 29 52 91 24 36 18 84 62 39 54 60 62 14 31 26 86 74 59 38 99 63 12 36 90 38 73 86 69 43 8 28 48 43 41 52 20 17 57 37 6 23 44 9 19 34 11 48 34 3 9 31 19 23 39 13 60 45 29 41 63 24 26 14 8 2 28 38 26 26 54 46 42 38 47 13 39 65 63 13 1 878.939 75 776 77 78 379 80 43 182 83 84 BS 88 87 08 89 immmmm $ 53588 588 84 38 54 32 84 57 SO 62 67 89 36 35 82 68 32 38 36 39 94 1 1027.71 0 20 33 38 65 86 59 64 35 12 OOOOOO 0 76 2 10 48 39 0 o 0 g B 54 Female 49 Male 41 Female 29. Mata 27. Female 38 Mate 50 Mala 58 Mata 68 Male 05 Male 48 Female 73 Female 42 Female 731 Female 27 Female 27: Female 65 Female 40 Female 67 Male 65 Male 71 Female 36 Male 72 Female 62 Female 31 Mala 20 Female 44 Male 53 Female 45 Male 36 Female 33 Female 35 Male 75 Female 31 Female 32 Male 40 Female 52 Female 74 Male 68 | Female 3 Male 56 Female 4 Male 29. Malo 27 Female 57 Male 24 Female 02 Mole 41 Mile 47 Female Male Samole 28 8 82 74 D E 3 Married Private 13 Single Commute 11 Married Commute 11 Married Commute O Married Private 6 Married Commute 6 Martied Private 2. Married Private 1 Married Private 3 Married Private 6 Married Commute 10 Married Private 2 Married Private Married Private 2 Single Commute 7. Single Commute 8 Married Private 5 Married Private 8 Marted Private 7 Married Commute 7. Married. Private 14 Married Private 4 Single Private 9 Single Commute 13 Single Private 9 Single Private I Married Commute -1 Single Commute 1 Married Commerc 5 Married Commute 11 Single Commute 7 Single Commute 9 Married Private 6 Married Private 2 Married Commute 1 Married Commute 11 Married Commute 3 Married Private 7 Marned Private O Married Private 11 Married Comenute 1 Married Commute 10 Married Commute 12 Single Commute 8 Married Private ang Commute 6 Single Commute O Married Private 1 Marded Commute Married Private 10 binele Commute OOOOOOOOOOOooola o GD OOOOOOO 1303.28 0 F 813 Rural 824 Urban 644 Rural 807 Urban 878 Rural 853 Urban 850 Urban 545 Rural 340 Rural 807 Rural 885 Urban 795 Urban 340 Urban 275 Urban 862 Urban 622 Rural 852 Rural 799 Urban 351 Rural 812 Urban 850 Urban 692 Urban 829 Rural B56 Urban 522 Urban 833 Rural SSO Urban 881 Urban 314 Urban 358 Rural 828 Urban 853 Urban 844 Urban 900 Urban 690 Urban 823 Urban 746 Urban 847. Urban 868 Rural 831 Urban 687 Urban 752 Rural 753 Urban 345 Urban 757 Urban 642 Urban 333 Urban 714 Urban 710 Urban 759 Diban 453 Urban H 124274 6213.71 6217 9320.57 6213.71 6213.71 6213.71 12427.4 9320.57 15534.3 9320.57 6213.71 6213.71 6213.71 12427.4 9320.57 6213.71 6213.71 3106.86 21748 6213.71 6213.71 6213,74 6213.71 3106.85 6213.71 9920.57 7456.45 18641.2 15534.3 6213.71 6213.71 12427.4 12427.4 6835 03 124274 3728,23 6213.71 6213.71 6213.71 155343 154721 6213.71 12427.4 4970,97 9320.57 9320.52 124274 621371 9320.57 62121 18 91 988869888898 OOOOOO 30 71 91 19 15 0 g 31 o 88 46 42 15 72 30 1937 136 sa 10 101 1.2 149 8 57 8 48 27 27 11 35 79 NONNASSA OOOOOOOOOOOOOOOOOO OOOOOOOOOOOOOOOOOO 34 2560.78 145 NG NY 40 19 10 24 30 39 12 03 @ 27 43 S7 31 33 S 43 64 96 54 35 39 57 OOOOOOOOOOO oooooooooooooOOOOO . 26 84 35 65 63 30 75 23 31 43 18 81 33 73 39 18 KESAN O 26 5 174 A B 51 66 Male 32 59 Female 53 75 Female 54 53 Male 55 49 Male 56 24 Female 57 50 Female 58 65 Female 159 48. Female 180 63 Male 361 32 Female 162 58 Female 163 65 Female 354 39 Female 5165 58 Male 188 35 female 767 55 Male 166 65 Female 283 58 Female 46 Male 171 76 Male 172 50 Mala 173 58 Male 62 Female IS 38 Male 63 Male TRA 56 Male 178 59 Male Ta 89 Mala 100 46 Male 42 Female 182 46 Male 163 50 Female 184 68 Female 185 57 Male 108 38 Male 187 34 Male 168 40 Male 139 59 Male 190 51 | Female 47 Male 182 78 Female 133 45 Male 28 Male 199 70 Mo 196 45 Male AP 149 Female 139 63 Famale 39 Male 200 57 Female 40 Femala 37 D E 7. Married Private Married Commute 7. Married Farmer 13 Martied Commare 7 Married Commute 4. Single Commute 2 Married Commute 4 Married Private 7 Married Private 15 Single Commute 5 Single Commute 8 Married Private O Married Farmer O Married Private 1 Married Private O Single Private 13 Married Private 4 Married Private 1 Married Commute 1 Married Commute 8 Married Private 11 Single Commute 10 Married Private 7 Single Private 4 Married Commute 14 Married Private 10 Single Private 8 Married Commute 9 Married Private 7 Married Private 1 Single Private 5 Married Commute 9 Single Private 4 Single Private 13 Married Commerc 6 Married Commute 7 Married Commute 3 Married Commute 7 Martied Commute 6 Married Private A Married Commute 2 Married Private O Married Commute 6 Married Commute 5 Married Private 1 Single Commute O Married Private Single Commute Married Private o single Commute Single Commute F G 838 Urban 814 Urban 993 Urban 341 Urban 683 Urban 624 Urban 814 Urban 838 Urban 880 Urban 696 Urban 863 Urban 848 Urban 900 Urban 745 Urban 756 Urban 583 Urban 346 Urban 900 Rural 842 Urban 832 Urban 900 Urban 444 Urban 636 Urban 847 Rural 639 Rural 834 Rural 797 Rural 822 Urban 895 Urban 832 Urban 642 Urban 874 Rural 330 Rural 745 Rural 323 Urban 887 Urban 737 Urban 818 Rural 733 Urban 227 Urban 794 Rural 276 Urban 750 Urban 457 Urban 871 Urban 712 Rural 813 Rural 883 Urban 776 Urban 981 Urban 948 Urban B 124274 12427.4 6213.71 6213.71 12427.4 9320.57 6213 71 12427.4 6213.71 932052 12427.4 6213.71 9320.57 6213.71 9320.57 186411 4970.97 5213.71 12427.4 9320.52 6213.71 124274 6213 71 6213.71 124274 12427.4 733218 124274 6835.08 124274 124274 124274 12427.4 7456,45 12427.4 124274 155343 9320.57 12427.4 3106.86 124274 9941.94 9320,57 9920.57 124274 124274 124274 621371 6213.71 12427 4 7456 49 0 0 0 F%sa88 Ansum 84 26 79 36 31 79 0 0 121 36 43 73 22 25 6 34 46 24 21 8 0 37 43 24 74 43 75 43 18 39 52 73 35 29 53 24 393INESS TOOOOOOOOOOOOOOOOOOOOOOOO 43 20 OOOOOOOOOOOO 20 25 32 32 39 72 12 12 24 05 199 300 201 202 203 112 12 57 38 33 OOOOOOOO 200 16 37 24 53 9 18 47 28 15 34 58 53 52 18 23 16 38 , 205 200 207 208 209 210 211 212 213 24 2015 218 217 218 219 220 221 69 58 78 34 39 10 OOO 36 22 3 A B 39 Mate 52 Female 40 Female 70 Male 26 Female 34 Female 54 Female 45 Female 31 Female 51 Mala 78 Mala 69 Male 70. Male 40 Female 66 Male 37 Female 76 Male 65 Female 59 Male 27 Mate 30 Female 54 Male 37 Female 24 Female 60 Male 79 Male 64 Male 38 Male 31 Male 68 Female 70 Female 71 Male 66 Male 54 Mala 53 Male 58 Male 31 Male 32 Male 61 Male 82 Male 41 Male 43 Female 52 Female 38 Femalo 63 Male 33 Male 64 Mala 64 Malo 37 Male 73 Female 89 Female 54 E 8 Married Private O Single Commute 2 Single Commute O Married Private 7 Single Commute 8 Single Commute 2 Married Private 5 Married Commute 1 Married Private O Married Commerc 5 Single Private 1 Married Private 17 Married Private 5 Married Commute O Married Private 4 Single Commute 5 Married Commute 1 Single Private 9 Single Commute 5 Single Commute 2 Single Commute 5 Single Commute 1 Married Private o Married Commute 12 Married Commute 8 Martied Private 2 Married Private 1 Single Commute 9 Single Commute 8 Single Commute 1 Married Commute S Married Private 3 Married Private 9 Married Commute 3 Single Commute 6 Married Private 4 Single Commute 4 Married Farmer 4 Married Private 6 Married Private 2 Married Commute O Married Commute 7 Married Commute B Married Commute 4 Married Private 4 Single Commute 8 Married Private Married Commute 6 Married Commute 2 Married Farmer 1 Single Commute 776 Urban 731 Urban 748 Urban 900 Orban 796 Urban 815 Urban 345 Urban 315 Urban 364 Urban 513 Rural 877 Urban 863 Urban 777 Urban 570 Rural 347 Urban 694 Urban 886 Rural 8.84 Urban 889 Urban 744 Urban 543 Rural 831 Urban 715 Urban 686 Urban 817 Urban 900 Urban 900 Urban 325 Urban 346 Urban 900 Rural 857 Urban 935 Rural 840 Rural 846 Urban 741 Rural 839 Rural 863 Urban 778 Rural 807 Rural 892 Urban 713 Urban 691 Rural 706 Urban 356 Urban 839 Rural 945 Urban 830 Urban 842 Urban 870 Urban 857 Rural 666 Urban H 621371 124274 7456,45 32427.4 124274 124274 124274 12427.4 7456,45 124274 6213,73 9320.57 6213.71 12427-4 6213.71 12427.4 12427.4 11184.7 5213.71 9320,57 12427,4 12427.4 6213 71 1242714 12427.4 6213.71 6213.71 932057 124274 6213.71 6213.71 6213.71 124274 6213.21 18641.1 124274 12427.4 12427.4 124274 6213.71 6213.71 6213.71 6213.71 6213.71 124274 6213.71 6213.71 6213.71 6213.71 6213.71 6213.71 0 0 0 0 0 O 0 0 0 g o 0 g o o a 0 0 0 o 0 0 1987 111 0 0 0 0 0 0 0 0 0 60 72 + u. BE 4 + 8 w &&&&&SNRS SNESS 74 5 49 41 53 50 26 32 OOOOOOOOOOOOOOO 70 33 0 0 38 200 201 232 289 234 235 2361 237 238 239 240 241 2 22 243 245 246 247 248 249 13 16 41 66 25 24 7 22 45 7 43 49 OOOOOOOOOOOOOOOOOO 0 0 0 0 74 OOOO 56 4 24 03 - G C H 0 347 248 249 250 251 OO 2 GOOOOOOO 25 284 25 362 59 258 259 360 27 20 30 21 33 H 15 43 RO 26 264 285 265 267 32 36 18 A B 37 Male 73 Female 39 Female 44 Female 22 Male 43 Female 38 Male 59 Female 26 Female 49 Female 39 Female 49 Male 24 Female 37 Male 19 Male 60 Male 57 Male 58 Female 59 Male 60 Male 54 Female 54 Female 34 Male 40 Male 69 Female 47 Male 52 Male 54 Male 45 Female 54 Male 54 Male 41 Female 38 Female 33 Female 52 Female 76 Famate 49 Female 66 Female 72 Female 37 Male 33 Female 75 Female 43 Male 40 Male 7 Male 48 Female 53 Male 60 Female 40 Female 62 Male Male 209 20 6 Married Commute 2 Married Farmer 1 Single Commute 7. Married Commerc 33 Single Commute 3 Married Commute 1 Single Commute 10 Single Private 4 Single Commute 3 Married Commute 9 Martied Commute 5 Married Commute 4 Single Commute 4 Single Commute 3 Married Commute 12 Single Commute 6. Married Private 6 Single Private 2 Married Private 5 Married Commute O Married Commute 5 Single Commute 3 Single Commerc 1 Married Commute 4 Married Private -1 Married Commute Married Commute 12 Married Private 3 Married Private 14 Married Commute 6 Married Private O Married Commute 7. Married Commute 1 Married Commute 8 Married Commute 7. Single Private 14 Single Private 3 Married Private 7 Single Private 9 Married Private 11 Single Private 4 Married Private 2 Married Commute 9 Single Commute 11 Single Privata 4 Single Commute 3 Married Commute 11 Single Private 5 Married Commute 10 Single Private 6 Single Commute G 870 Urban 357 Rural 555 Urban 383 Urban 304 Urban 313 Rural 651 Urban 709. Urban 350 Urban 720 Rural 840 Urban 363 Urban 664 Urban 533 Urban 846 Rural 349 Rural sso Urban 772 Rural 900 Urban 805 Urban 323 Urban 752 Urban 842 Urban 359 Urban 755 Urban 835 Urban 345 Urban 701 Rural 735 Rural 770 Urban 314 Urban 793 Rural 836 Rural 550 Urban 578 Urban 850 Urban --- 377 Urban 393 Urban 307 Urban 353 Urban 344 Rural 900 Rural 531 Urban 782 Rural 598 Rural 774 Urban 831 Urban 566 Urban SOO Urban 756 Urban 352 Rural 6213.71 62237 6213.71 12427.4 9320.57 9320.57 7456 45 6213.71 18670.2 12427.4 124274 6213.71 12427 4 9320.57 12427.4 6213.71 4349.6 12427.4 621373 12427.4 12427.4 9258.43 372523 3106.86 12427.4 6213.71 12427.4 3106.36 12427.4 6213.71 6213.71 12427,4 12427.4 6213.71 12427.4 6213.71 6213.71 6213.71 6213.71 6213.71 6213.71 6213.71 6213.71 12427.4 6213.71 124274 7456.45 6213.71 6213.71 6213.71 12427.4 1575,551 0 0 0 3848.4 D O 0 0 0 0 0 1 0 0 o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o 0 0 0 0 0 0 0 MSNBERGHAUSHBUB BUNS 74 BG 24 33 14 31 16 72 35 39 18 52 63 65 52 84 83 86 73 31 56 14 26 66 12 39 63 79 38 57 68 57 87 68 57 13 35 14 31 39 18 82 31 37 24 33 66 52 51 43 35 46 24 2731 274 275 26 0 0 0 278 279 280 20 0 0 0 0 0 0 0 54 20 282 283 284 205 386 LOOOOOOOOOOOOOOOOOO 27 24 58 23 RENS 368 00OOOOOOOOOOOO 03 93 299 300 801 35 43 50 312 79 Tololo DODOO 32 800 041 IS o o o o o o o o o o - 800 16 4 300 1352:5 35 7 19 34 32 1 0 0 0 0 368 310 311 312 313 314 315 316 317 310 319 35 1 0 262.51 a 0 0 0 O 0 A 5 70 Mato 5 Female 29 Female 79 Female 43: Male 52 Male 46 Male 41 Male 44 Male 51 Female 53 Female 28 Female 36 Male 53 Female 53 Female 71 Female 56 Male 44 Male 49 Male 35 Female 25 Female 36 Female 68 Female 66 Male 80 Male 52 Female 62 Male 61 Female 61 Male 56 Male 43 Male 51 Female 51 Female 42 Female 49 Female 27 Female 35 Female 31 Female 54 Female 33 Male 41 Female 39 Female 36 Male 74 Male 24 Male 62 Female 26 Male 53 Female 30 Female 58 Female 65 Fernate 5 Single Private 4 Martied Commute 2 Married Private 9 Married Private 3 Married Private 21 Single Private 9 Married Commute 1 Single Commute O Married Private 3 Single Commute 7. Married Private o Single Commute 1 Single Commute 9 Single Private 5 Married Commute 1 Married Private 1 Married Commute 1 Married Commute 7 Married Commute 12 Married Private B Married Commute 3 Married Private 1 Married Private 9 Married Commute 12 Married Private 8 Married Commute 4 Married Commute 4 Single Private 3. Married Private 5 Married Commute O Married Private 3 Married Commute 4 Married Commute 4 Married Commute o Married Commute 8 Single Commute -1 Married Commute 6 Single Private S Married Private 3 Single Commute 2 Single Commute 1 Married Commerc 8 Single Commute 1 Married Private 9 Single Commute O Married Private Married Private O Single Private 7 Married Private 19 Married Private 11 Single Private F 340 Urban SG3 Urban 592 Urban 900 Rural 742 Rural 745 Urban 821 Urban 334 Rural 302 Urban 900 Urban 715 Urban 339 Urban 816 Rural 856 Urban 776 Urban 344 Urban 333 Urban 773 Urban 261 Urban 526 Urban 799 Urban 339 Urban 389 Urban 772 Urban 832 Urban 755 Urban 858 Rural 828 Rural 814 Urban 840 Urban 799 Urban 832 Urban 345 Urban 723 Urban 749 Urban 817 Urban 645 Urban 619 Urban 810 Urban 740 Urban 761 Urban 552 Urban 799 Urban 843 Urban 357 Urban 348 Urban 696 Rural 900 Urban 576 Urban 792 Urban B16 Urban 0 4970 97 111847 4970.97 6213.71 621371 5213.71 621371 155343 6213.73 6213.71 124274 62137 124224 6233.92 12427.4 5213.71 124274 12427.4 621371 6213.71 124274 6213.71 6213.71 623372 6213.71 6213.75 186411 12427.4 311347 12427.4 5213.71 7456.45 5213.71 621373 186411 12427.4 12427.4 186411 6213.71 124274 12427.4 135410 124274 9320.57 621371 6213 7: 124274 6213.71 113347 6215.73 6213.72 0 24 25 326 397 WEB KESO BAGSUSUN BERNAMA OSAGARCANERES RSSG 0 0 6 25 380 831 30 333 334 835 336 16 OOOOOOOOOOOOOOOOOOOOOOOO 17 337 30 1781 38 3.0 341 3:2 23 4 345 340 OOOOOOOOOOOOOOO 7 3 03 A F. H Das 350 351 982 353 54 359 31 26 30 39 60 74 33 15 81 54 61 357 OOOOOOOOOOOOOOOO SSS 380 361 0 O 383 384 255 282 98 0 0 0 0 0 0 0 0 O 370 0 0 38 Female 30 Female 33 Female 52 Mate BS Male 51 Male 43 Female 48 Male 65 Female GO Male 70 Male 67 Mele 72 Female 26 Male 43 Female 53 Female 65 Male 57 Female 51 Female 73 Female 36 Male 49 Male 58 Male 55 Female 50 Male 50 Female 55 Male 68 Male 53 Female 75 Female 59 Male 45 Female 48 Female 39 Female 28 Female 41 Male 57 Male 43 Female 34 Female 59 Female 47 Female 49 Mald 55 Male 53. Malo 33 Male 67 Male 70 Male 56 Female 54 Male 73 Famil 46 Male 0 E 0 Married Private 1 Married Commute 10 Single Private 2 Married Private 4 Married Private 6 Single Commute 6 Single Private 15 Married Commute 10 Married Private 6 Single Commute 12 Married Private 3 Married Private 3 Married Private O Single Commute Married Private 14 Married Commute 1 Married Private 4 Married Private 6 Married Commute 5 Married Private 2 Married Commute 5 Married Private 1 Married Private 1 Single Private 15 Married Commute 2 Married Commute 2 Married Commute 12 Married Private 2 Single Private 3 Married Farmer 2 Married Commerc 2 Single Private 10 Married Commute 9 Married Commute 2. Single Commute 10 Single Private 3 Married Commute 5 Married Commute 9 Single Commute 5 Single Commute 5 Single Commute 4 Married Private 15 Married Commute Married Commers 4 Single Commute o Married Commute Married Private 1 Married Private O Strigle Commare Married Private Married Commute 0 874 Rural 872 Urban 661 Urban 332 Rural 888 Urban 340 Urban 694 Urban 870 Urban 847 Rural 770 Urban 831 Urban 897 Urban 897 Urban 349 Urban 803 Urban 845 Urban 797 Urban 779 Rural 846 Urban 872 Rural 566 Rural 749 Rural 900 Urban 52 Urban 710 Urban 803 Urban 719 Urban 900 Urban 852 Urban 784 Rural 343 Urban 813 Urban 685 Urban 695 Urban 824 Urban 623 Urban 885 Urban 595 Urban 795 Urban 779 Rural 810 Urban 38 Urban 886 Rural 705 Orban 760 Urban 799 Urban 594 Urban 514 Rural 562 Urban 782 Rural 863 Rural 6233.71 7456.45 6213.71 6213.71 3728 23 6213.71 6213.71 124274 5592 34 9320.57 6213.71 6213.73 6213.71 124274 6213.71 6213.71 124274 8699.19 5213.71 6213.71 6213.71 12427.4 9320.57 4970.97 1553413 12427.4 6213171 3106.86 6213.71 155343 186411 6213.71 12427.4 15534.3 6213.71 9320.57 9320,57 6213.71 6213.71 7456,45 6213.71 124274 155343 12427.4 6213.71 9320.52 12427.4 6213.71 124274 124274 9320.57 19 8 6 35 69 22 19 26 48 42 49 47 47 10 24 21 49 40 35 53 20 32 37 37 33 33 30 52 36 52 42 27 32 22 9 15 40 6 2 7 31 32 35 36 7 50 53 32 10 29 30 D OOOOOOO 0 S78 522 $ Syg 380 361 382 383 88 67 72 59 87 85 71 38 31 79 72 74 35 62 35 38 88 85 43 84 32 24 37 88 89 65 71 85 Ba 91 32 35 74 26 18 73 78 314 1 O O 0 1 497 302 0 089 329 OOOOOOOOOOOOOOOOOO OOOOOOOOOOOOOO 1144.59 397 198 188 03 B 12 33 73 74 400 401 403 403 404 405 405 40V 400 OOOOO ooOOOO 15076.47 Basws UBE 0 0 90 11 12 413 14 47 22 49 22 32 28 19 54 56 24 13 16 36 57 1 14 80 72 417 17 0 0 0 0 0 0 0 0 0 0 o 0 O 1491-652 0 o 25 73 59 47 420 401 422 23 424 425 426 427 31 35 Female 51 Male 51 Female 39 Female 77 Female 63 Male 45 Male 47. Female A Female 73 Male 74 Male 41 Female 33 Female 34 Male 53 Female 73 Female 26 Male 55 Male 45 Femala 57 Male 63 Male 78 Male 53 Female 66 Male 63 Male 74 Female 37. Female 74 Female 29 Female 58 Female 51 Male 60 Male 66 Female 30 Male 67 Female 29 Male 74 Male 60 Male 23 Male 67 Male 25 Male 64 Mald 71 Male 41 Female 7A Female 49 Male 66 Male 52 Famala 56 Female 72 Main HOM E 6 Married Commute 12 Married Commute 9 Single Commute 5. Married Commute 3 Married Private 8 Married Commute 6 Single Commute 2 Married Commute 9 Married Private 9 Married Private 1 Married Private 3 Married Commute 7 Single Commute 8 Married Commute 4 Married Commute 10 Married Private 12 Single Commute 10 Married Private 5 Married Private 6 Married Private 6 Married Private 12 Married Private 1 Married Private 3 Married Commute 8 Married Farmer 17 Married Private 1 Married Commute 17 Married Private 1 Married Commute 2 Married Private O Married Commute 4 Married Private 1 Married Private 10 Married Commute 13 Single Private 4 Single Commute 8 Married Private S Married Private 12 Single Commute 2 Married Private 8 Single Commute 2 Married Private O Married Private 7 Single Commute 3 Married Private 1 Married Private 11 Single Private 13 Married Private 10 Married Private 4 Mamed Private 1 Married Private + 321 Urban 332 Urban 738 Urban 596 Urban 848 Urban 802 Urban 900 Orban 617 Urban 574 Urban 900 Rural 356 Urban 811 Urban 838 Urban 535 Urban 369 Urban 900 Rural 634 Urban 850 Urban 394 Urban 343 Urban 785 Urban 825 Urban 327 Urban 803 Urban 850 Rural 900 Orban 826 Urban 900 Urban 853 Urban 852 Urban 816 Urban 305 Rural 382 Urban 663 Rural BOS Urban 714 Rural 900 Rural 851 Urban SOS Urban 366 Urban 577 Urban 732 Urban BOS Urban 730 Urban 900 Urban 838 Rural 310 Urban 378 Urban 304 Rural 849 Rural 377 Rural 621371 224274 124274 12427.4 6213.71 5213.71 124274 6213.71 7456 45 6213.71 6213.71 521373 6213.71 124274 9941 94 6835.00 6213.71 932057 9320 57 12427 4 6213.71 6213.71 6213.71 24912.9 9320.57 3106 85 6213.71 3106.86 6213.71 6213.71 12427.4 9320.57 6213.71 9320.57 6213.71 18641.1 6213.71 6213.71 6213.71 9320.57 12427.4 12427.4 6213.71 12427.4 6213.71 6213.72 6213.71 6213.71 6213.71 6213.71 5213:23 ww888888888888888889W8 24 0 90 429 430 98 0 1 3425.97 0 25 32 433 D 434 135 438 437 438 189 140 4 42 03 DOOOOOOOOOOOOOOOOOOOOOOO o BISMO BE 32 60 5 446 GOOOOO 50 43 118 449 450 F 51 28 0 11205 52 O 7 0 DO 0 452 493 4154 155 456 457 48 158 480 461 1162 463 UFA 969 OOOO 45 0 0 0 0 4.68 0 O 467 489 469 470 471 472 4.78 474 415 476 477 4781 6 A B 53 Mate 42 Male 66 Femala 26 Female 53 Male 24 Female 26 Female 70 Female 32 Male 57 Male 71 Male 68 Male 33 Male 47 Female 35 Male 43 Male 28 Male 35 Mate 26 Female 35 Female 46 Femala 30. Female 28 Female 57 Male 28 Male 46 Female 51 Mala 51 Female 32 Male 25 Female 71 Female 38 Mala 19 Female 68 Male 60 Female 55 Male 67 Female 68 Female 59. Female 58 Female 33 Male 31 Male 28 Female 26 Male 70 Male 74 Female 38 Male 57 Female 76 Male 72 Male 3 Female 25 59 Married Commute 13 Married Commute 8 Married Commute 7 Single Cornute 8 Married Private o Single Commute 9 Single Private 1 Sinele Private 2 Single Commute 9 Married Commute 16 Married Private 1 Single Private 7 Married Commute 10 Married Commute 2 Married Commute 8 Married Commute 1 Single Commute 1 Married Private 5 Single Commute 3 Married Commute 6 Married Private 12 Married Private 1 Single Commute o Married Commute 9 Married Private 2 Married Commute 9 Married Commute 1 Married Private 12 Married Commute 9 Married Private 9 Married Private 1 Married Commute 7 Single Commute 8 Married Private 10 Married Private 5 Married Private 3 Married Private 9 Married Private 11 Married Commute 8 Married Private 13 Single Commute 4 Single Commute 1 Married Commute 12 Married Commute 3 Married Private 8 Married Private S Married Commute 9 Married Farmer B Married Private 11 Married Private 9 Single Private 77 62 90 79 34 30 30 35 74 177 14 52 31 37 33 75 66 18 54 33 52 32 31 87 74 38 35 66 73 39 32 60 326 Urban 327 Urban 310 Urban 575 Rural 771 Urban 752 Rural 375 Urban 794 Urban 817 Urban 346 Urban 304 Urban 735 Urban 840 Urban 303 Urban 661 Urban 643 Rural 854 Urban 832 Urban 613 Urban 817 Urban 875 Urban 790 Urban 763 Urban 900 Urban 785 Urban 884 Rural 359 Urbon 360 Urban 835 Urban 795 Rural 393 Urban 679 Urban 768 Urban 794 Rural 811 Urban 728 Urban 878 Urban 900 Urban 742 Rural BB2 Urban 734 Urban 802 Urban 671 Rural 835 Urban 851 Urban 570 Urban 772 Urban 894 Urban 840 Urban 339 Rural 825 Urban 0 0 0 0 0 0 0 0 124274 9320.57 155343 6213.71 5213.71 932057 621371 6215.71 124274 6213.71 3106.36 3723.23 16155.6 5213.71 7455 45 12427.4 124274 12427.4 12427.4 6213.71 6233.71 6213.71 559234 124274 6213.71 12427.4 12427.4 6213.71 621378 6213.71 2455.48 12427.4 6213.71 9320.57 6213.71 9320.57 6213.71 124274 6213.71 621373 6213.71 6213.71 6213.71 12427.4 9320.57 6213 71 621371 124274 124274 6213.71 621370 B8%8TwwBaw 30 0 28. % 8 Bit 43 0 479 o 0 0 46 0 3 180 481 482 483 484 465 488 187 489 189 490 13 75 81 24 401 37 45 SO 41 41 15 14 15 31 61 64 OOOOOOOOOOOOOOOOOOOOO 1 2079 28 191 OOOOOOOOOOOOOOOOOO 9 46 44 493 494 495 498 197 198 198 300 21 40 60 53 16 32 26 18 77 37 28 62 54 1 a) Based on your data set, is the average years of no claims ("Years,noclaims) of male drivers is significantly MORE THAN the average years of no claims ("Years.noclaims) of female drivers? Test both critical value and p-value approaches at the 8% level of significance. Note that SPSS only performs a 2-sided test. b) Based on your data set, is the relative claim frequency of the female drivers is significantly LESS THAN the relative claim frequency of the male drivers who involved in an accident? Test at the 12% level of significance. c) Provide possible reasons why you should expect to find a significant statistical difference between the genders. 5 d) Based on your findings, should the insurance company charge higher premiums based on the gender? Explain your reasoning. Should different tests have been conducted