Please let me know if I did my formulas correct below. 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 B$3,$ find the number of customers who would "Recommend" the restaurant in the Data sheet.

In cell B$4,$ find the sample size of the sample of customers who responded in the Data sheet.

In cell B$5,$ find the proportion of customers who would recommend the restaurant.

In cell B$6,$ find the standard deviation of the proportion.

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 B$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 B$8.$

$8.$ In cell $B9,$ find the value of the test statistic.

In cell B$10,$ find the critical value from the appropriate probability table to test the claim at alpha $=0\mathrm{.}01.$

By assessing the values in cells B$9$ and B$10,$ do you reject the null hypothesis? Choose your answer from the dropdown menu in cell B$11.$

Justify the answer you chose in cell B$11.$ Choose your answer from the dropdown menu in cell B$12.$

Based on your answer in cell B$12,$ we can conclude at alpha $=0\mathrm{.}01$ that: Choose your answer from the dropdown menu in cell B$13.$

In cell B$14,$ find the critical value from the appropriate probability table to test the claim at alpha $=0\mathrm{.}05.$

By assessing the values in cells B$9$ and B$14,$ do you reject the null hypothesis? Choose your answer from the dropdown menu in cell B$15.$

Justify the answer you chose in cell B$15.$ Choose your answer from the dropdown menu in cell B$16.$

Based on your answer in cell B$16,$ we can conclude at alpha $=0\mathrm{.}05$ that: Choose your answer from the dropdown menu in cell B$17.$

In cell B$18,$ find the observed level of significance $($p$-$value$).$

By considering the p$-$value, can the same conclusion be made about rejecting or not rejecting the claim at alpha $=0\mathrm{.}01?$ Choose your answer from the dropdown menu in cell

B$19.$

By considering the p$-$value, can the same conclusion be made about rejecting or not rejecting the claim at alpha $=0\mathrm{.}05?$ Choose your answer from the dropdown menu in cell

B$20.$

Based on your answer in cell B$11,$ what type of error might have been made? Choose your answer from the dropdown menu in cell B$21.$

Based on your answer in cell B$15,$ what type of error might have been made? Choose your answer from the dropdown menu in cell B$22.$