Question 2 (20 marks)

In a survey, 228 students were asked which award they would prefer to win: an Academy Award, a Nobel Prize, or an Olympic gold medal. They were asked their gender too. Use the data in \awards- gender.xlsxwhich can be downloadable from the Assessment section on the Moodle page for SCI1020.

a)Create a two-way contingency table of gender and preferred award. You will need to sort the data

according to the two categories; e.g., Award first and Gender secondly.

b)Find the marginal distribution of preferred award. Which award is the most popular with students

involved in the survey?

c)Find the conditional distribution of preferred award for each gender. Based on the conditional

distribution, is there a relationship between gender and preferred award?

d)Do the data indicate there is some association between gender and preferred award? Give all details

of the test and use a 5% significance level.

Student ID Award Gender 77875 N F N: Nobel prize 29983 0 M A: Academy award 78068 N M O: Olympic gold meda 28909 N M 97431 N F 52113 N M M: Male 12164 0 M F: Female 57126 N F 84994 0 F 69091 N M 43839 N M 15922 N M 58133 N M 59925 0 F 94513 N F 14570 A M 15502 N F 39624 N M 51237 N F 58247 A M 78997 N M 95702 A M 53797 A F 40406 A F 24730 A M 41533 0 M 48514 N M 90617 N F 45901 N F 75516 N M 36083 N M 69949 N M 35525 N F 74748 N M 67136 A F 76027 0 M 13653 N F 15871 N F 76357 N F 80449 0 49603 0 M49603 0 M 39640 N M 51194 N F 98824 N M 98501 N F 79916 A F 32162 N M 62968 N F 65994 N F 21933 A F 78642 N M 19091 N 43145 N F 53991 A F 37758 A F 32336 N F 42932 N F 83218 A F 94785 N M 22911 0 F 70813 0 F 87656 N F 29582 A F 29094 0 M 57906 0 F 63444 N F 95401 N M 23920 N F 97723 0 M 82578 A M 89480 N IVI 98415 0 M 67971 N M 78799 N F 57605 N F 82545 A M 71048 A F 52138 0 M 98261 A F 42645 N M 57017 N M 56661 N M24463 0 M 89389 A F 37285 0 M 84531 0 F 81265 A F 60497 A F 86610 A M 28843 N F 79013 A F 41970 N M 73689 A F 34591 N M 12498 N M 63939 N M 67081 N F 56895 0 M 37155 A M 83542 0 F 85518 0 M 62843 N F 64716 0 M 83644 0 M 90807 N F 39968 0 F 36275 A F 93489 0 M 29288 A F 31795 N M 66754 0 M 94080 0 M 34454 A F 12287 A F 63705 N M 11567 N M 91439 N F 14826 N F 65860 0 M 75461 N IVI 79399 0 F 72700 N M 93551 N M 21869 A M83301 N F 31319 A M 68576 0 M 43719 0 M 25255 A M 32575 N F 50352 A F 70778 0 M 89174 N M 86553 N F 13433 0 F 54803 0 M 31410 A F 64038 N F 84358 N M 55466 0 F 34312 N M 25137 0 M 76988 N M 63931 0 M 30345 N M 90143 N F 54753 A M 76917 N F 89963 A F 41601 0 M 21044 N F 76189 A M 32794 0 M 95988 N M 98615 A F 85489 N M 94729 0 M 31857 A F 73947 N M 41230 A M 65634 0 M 56561 A M 74404 N F 84313 0 M 55882 0 F 60989 N M98211 N M 71794 0 F 65264 N M 43812 0 M 35273 N M 71333 N M 68035 N M 10584 0 M 94995 N M 82449 0 M 44889 N F 36498 A M 53361 A F 12635 A M 85982 N F 87811 N F 86055 0 M 47144 N F 43335 N M 85327 N F 88353 0 M 35190 A M 96601 N F 13364 N M 37399 0 F 82307 N M 12554 N M 80881 A M 90528 0 M 31924 A F 19754 0 M 27876 A F 25973 N M 73819 N M 71599 N M 74309 A F 43783 N IVI 88352 0 M 94629 A M 40386 A F 61737 0 F 89640 N69136 / F 49399 N M 62901 A M 41537 A M 25030 N M 62279 N F 25258 N F 91156 M 35522 N M 13637 N F 30028 A F 79571 M 96209 A 73357 N 84728 M 55872 N M 86700 A M 87268 A F 31151 N 16116 0 F