A B C D E F G H K L M N O Contingency Table The table shows the results of a survey in which 28,295 adults were asked Apply what you have learned by completing this grade whether they had a cold or the flu on the previous day. lab question here on this tab . Use excel formulas to complete the four remaining questions. Click on the Colds Flu Neither Total three answers in red to see how to get started. For Smoker 526 153 4,980 5.659 example the answer to (a) is =L11/011 Nonsmoker 1.494 430 20,712 22.636 Total 2.020 583 25,692 28.295 cold flu neither smoker 526 153 4980 A person is selected at random from the sample. Find the probability of non 1494 430 20712 2 each event. total 2020 583 25692 28 (a) The person had a cold (b) The person had a cold or the flu (a) 0.071391 (c) The person had neither illness. given that the person is a smoker (d) The person had neither illness, given that the person is a nonsmoker (b) (e) The person is a smoker, given that the person had the flu (c) 0.880014 (f) The person had the flu or is a nonsmoker (d) (g) The person had a cold and is a smoker (e) (f) 0.805407 (g)