Question: Customer Response 1 Recommend 2 Not recommend 3 Recommend 4 Recommend 5 Recommend 6 Not recommend 7 Recommend 8 Not recommend 9 Not recommend 10
Customer Response 1 Recommend 2 Not recommend 3 Recommend 4 Recommend 5 Recommend 6 Not recommend 7 Recommend 8 Not recommend 9 Not recommend 10 Recommend 11 Recommend 12 Recommend 13 Recommend 14 Not recommend 15 Not recommend 16 Recommend 17 Recommend 18 Recommend 19 Not recommend 20 Not recommend 21 Not recommend 22 Recommend 23 Not recommend 24 Not recommend 25 Recommend 26 Recommend 27 Recommend 28 Not recommend 29 Not recommend 30 Recommend 31 Recommend 32 Recommend 33 Recommend 34 Recommend 35 Recommend 36 Recommend 37 Recommend 38 Recommend 39 Recommend 40 Recommend 41 Recommend 42 Recommend 43 Recommend 44 Recommend 45 Not recommend 46 Recommend 47 Recommend 48 Recommend 49 Recommend 50 Not recommend 51 Recommend 52 Not recommend 53 Not recommend 54 Recommend 55 Not recommend 56 Recommend 57 Recommend 58 Recommend 59 Recommend 60 Recommend 61 Recommend 62 Recommend 63 Recommend 64 Not recommend 65 Recommend 66 Recommend 67 Recommend 68 Recommend 69 Recommend 70 Not recommend 71 Not recommend 72 Recommend 73 Recommend 74 Recommend 75 Recommend 76 Recommend 77 Not recommend 78 Recommend 79 Recommend 80 Recommend 81 Recommend 82 Recommend 83 Recommend 84 Recommend 85 Recommend 86 Recommend 87 Recommend 88 Recommend 89 Recommend 90 Recommend 91 Not recommend 92 Recommend 93 Recommend 94 Recommend 95 Recommend 96 Not recommend 97 Recommend 98 Recommend 99 Recommend 100 Not recommend 101 Not recommend 102 Recommend 103 Recommend 104 Recommend 105 Recommend 106 Recommend 107 Not recommend 108 Recommend 109 Recommend 110 Recommend 111 Not recommend 112 Recommend 113 Not recommend 114 Recommend 115 Recommend 116 Not recommend 117 Recommend 118 Not recommend 119 Recommend 120 Not recommend 121 Recommend 122 Recommend 123 Recommend 124 Not recommend 125 Recommend 126 Recommend 127 Recommend 128 Recommend 129 Recommend 130 Not recommend 131 Recommend 132 Recommend 133 Recommend 134 Recommend 135 Recommend 136 Recommend 137 Not recommend 138 Recommend 139 Not recommend 140 Recommend 141 Recommend 142 Not recommend 143 Recommend 144 Not recommend 145 Recommend 146 Recommend 147 Not recommend 148 Recommend 149 Recommend 150 Not recommend
I need help with the formulas in Excel to resolve this please.
Hypothesis Testing for the Population Proportion | ||
Use a cell reference or a single formula where appropriate in order to receive full credit. | ||
1-2. In cell B3, find the number of customers who would "Recommend" the restaurant in the Data sheet. Hint: use the COUNTIF function. | ||
3. In cell B4, find the sample size of the sample of customers who responded in the Data sheet.Hint: use the COUNTA function. | ||
4. In cell B5, find the proportion of customers who would recommend the restaurant. | ||
| 5. In cell B6, find the standard deviation of the proportion. Hint: use the formula standard deviation = sqrt(p*(1-p)/n). | ||
| 6. To test the null hypothesis for the proportion of customers that would recommend the restaurant, what is the appropriate probability table to use? Choose your answer from the dropdown menu in cell B7. Options: a) Normal Standart Distribution B) T-Distribution c) Chi-squared distribution | ||
| 7. The manager would like to test the claim (null hypothesis) that at least 80% of the customers would recommend the restaurant. Is this a two-sided test? Choose your answer from the dropdown menu in cell B8. Options: a)No, it's a left-sided test. b) No, it's a right-sided test. c) Yes, it is two-sided. | ||
8. In cell B9, find the value of the test statistic. | ||
9. In cell B10, find the critical value from the appropriate probability table to test the claim at alpha = 0.01. Hint: use the NORM.S.INV function. | ||
| 10. By assessing the values in cells B9 and B10, do you reject the null hypothesis? Choose your answer from the dropdown menu in cell B11. Options: a)Yes,I reject b) No, I do not reject. | ||
| 11. Justify the answer you chose in cell B11. Choose your answer from the dropdown menu in cell B12. Options: a)Because the test statistic is negative. b) Because the test statistic does not fall in the rejection region. c) Because the test statistic falls in the rejection region. | ||
| 12. Based on your answer in cell B12, we can conclude at alpha = 0.01 that: Choose your answer from the dropdown menu in cell B13. Options: a) there is not enough evidence to reject the claim that at least 80% of the customers would recommend the restaurant. b)there is enough evidence to reject the claim that at least 80% of the customers would recommend the restaurant. | ||
13. In cell B14, find the critical value from the appropriate probability table to test the claim at alpha = 0.05. Hint: use the NORM.S.INV function. | ||
| 14. By assessing the values in cells B9 and B14, do you reject the null hypothesis? Choose your answer from the dropdown menu in cell B15. Options: a) Yes,I reject. b) No, I do not reject. | ||
| 15. Justify the answer you chose in cell B15. Choose your answer from the dropdown menu in cell B16. Options: a)Because the test statistic is negative. b) Because the test statistic does not fall in the rejection region. c) Because the test statistic falls in the rejection region. | ||
| 16. Based on your answer in cell B16, we can conclude at alpha = 0.05 that: Choose your answer from the dropdown menu in cell B17. Options: a) there is not enough evidence to reject the claim that at least 80% of the customers would recommend the restaurant. b)there is enough evidence to reject the claim that at least 80% of the customers would recommend the restaurant. | ||
17. In cell B18, find the observed level of significance (p-value). Hint: use the NORM.S.DIST function. | ||
| 18. By considering the p-value, can the same conclusion be made about rejecting or not rejecting the claim at alpha = 0.01? Choose your answer from the dropdown menu in cell B19. Options: a) Yes, since the p-value is greater than alpha we reject the claim. b) Yes, since the p-value is greater than alpha we do not reject the claim. c) No, since the p-value is greater than alpha we reject the claim. d) No, since the p-value is greater than alpha we do not reject the claim. | ||
| 19. By considering the p-value, can the same conclusion be made about rejecting or not rejecting the claim at alpha = 0.05? Choose your answer from the dropdown menu in cell B20. Options: a) Yes, since the p-value is greater than alpha we reject the claim. b) Yes, since the p-value is greater than alpha we do not reject the claim. c) No, since the p-value is greater than alpha we reject the claim. d) No, since the p-value is greater than alpha we do not reject the claim. | ||
| 20. Based on your answer in cell B11, what type of error might have been made? Choose your answer from the dropdown menu in cell B21. Options: a)Type I: Rejecting the null hypothesis that might be true. b)Type I: Not rejecting the null hypothesis that might be true. c)Type II: Rejecting the null hypothesis that might be false. d) Type II: Not rejecting the null hypothesis that might be false. | ||
| 21. Based on your answer in cell B15, what type of error might have been made? Choose your answer from the dropdown menu in cell B22. Options: a)Type I: Rejecting the null hypothesis that might be true. b)Type I: Not rejecting the null hypothesis that might be true. c)Type II: Rejecting the null hypothesis that might be false. d) Type II: Not rejecting the null hypothesis that might be false. |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help