Hypothesis Testing for the Population Proportion Use a cell reference or a single formula where appropriate...

 

Transcribed Image Text:

Hypothesis Testing for the Population Proportion Use a cell reference or a single formula where appropriate in order to receive full credit. Do not copy and paste values or type values, as you will not receive full credit for your answers. 1-2. In cell B3, find the number of customers who would "Recommend" the restaurant in the Data sheet. 110 3. In cell B4, find the sample size of the sample of customers who responded in the Data sheet. 150 0.733 0.036 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. 6. To test the null hypothes is 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. 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. 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. 10. By assessing the values in cells B9 and B10, do you reject the null hypothes is? Choose your answer from the dropdown mena in cell B11. 11. Justify the answer you chose in cell B11. Choose your answer from the dropdown menu in cellB12. 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. 13. In cell B14, find the critical value from the appropriate probability table to test the claim at alpha 0.05. 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. 15. Justify the answer you chose in cell BIS. Choose your answer from the dropdown mena in cell B16. 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. 17. In cell B18, find the observed level of significance (p-value). 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. 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. 20. Based on your answer in cell B11, what type of eror might have been made? Choose your answer from the dropdown menu in cell B21. 21. Based on your answer in cell Bl5, what type of eror might have been made? Choose your answer from the dropdown menu in cell B22, Hypothesis Testing for the Population Proportion Use a cell reference or a single formula where appropriate in order to receive full credit. Do not copy and paste values or type values, as you will not receive full credit for your answers. 1-2. In cell B3, find the number of customers who would "Recommend" the restaurant in the Data sheet. 110 3. In cell B4, find the sample size of the sample of customers who responded in the Data sheet. 150 0.733 0.036 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. 6. To test the null hypothes is 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. 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. 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. 10. By assessing the values in cells B9 and B10, do you reject the null hypothes is? Choose your answer from the dropdown mena in cell B11. 11. Justify the answer you chose in cell B11. Choose your answer from the dropdown menu in cellB12. 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. 13. In cell B14, find the critical value from the appropriate probability table to test the claim at alpha 0.05. 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. 15. Justify the answer you chose in cell BIS. Choose your answer from the dropdown mena in cell B16. 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. 17. In cell B18, find the observed level of significance (p-value). 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. 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. 20. Based on your answer in cell B11, what type of eror might have been made? Choose your answer from the dropdown menu in cell B21. 21. Based on your answer in cell Bl5, what type of eror might have been made? Choose your answer from the dropdown menu in cell B22,