No 75 YES 59 Total 134

Obtain the Excel file Ghosts.xIsx & , which contains 134 responses to the question "Do you believe in ghosts?" that was asked in a poll during a QM1 lecture in 2019. 1. Convert the Yes/No responses into 1/0 responses of the form X; = 1 if the response is "Yes" X; = 0 if the response is "No" by using the Excel (IF) command. For example to convert cell A3 from Yes/No to 1/0, use =IF(A3="Yes", 1, 0) which gives 1 if cell A3 contains Yes, and O otherwise. B C D E 1 Q1 2 Do you believe in ghosts? 3 No =if(A3="Yes",1,0) No F(logical test, [value if true], [value if false]) No 6 No 7 Yes 8 No 9 No 10 No 11 No 12 No 13 No 14 Yes 15 No 16 No 17 Yes Copy this down the length of the column. 2. Using these Xi's, calculate EX;, X , s. 3. How many people answered "Yes"? 4. What proportion of people answered "Yes"