Marks: 3M+IM Q.3 Suppose we want to determine what proportion of people lives in Hyderabad city are in engineering profession. For the same, we collected the sample data from 30 randomly chosen people in Hyderabad which is shown in Data Set 2. Write down functions in excel to determine point estimate, Margin of error for 95% confidence interval of the proportions of people are in engineering profession from the given sample data Note: "Yes" means the person is in engineering profession and "No" means the person is not in engineering profession Marks: 4MA B C D E F G 1 Person Response 2 1 Yes 3 2 No 4 Yes 5 Yes 6 5 Yes N 6 No 8 7 No 9 8 Yes 10 9 No 11 10 Yes 12 11 Yes 13 12 Yes 14 13 No 15 14 No 16 15 No 17 16 No 18 17 Yes 19 18 No 20 19 Yes 21 20 Yes 22 21 Yes 23 24 No 24 23 No 25 24 Yes 26 25 No 26 Yes 27 No 29 28 No 29 Yes 30 No BB