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.