1-2. In cell B3, find the number of customers who are "Satisfied" from the Data sheet.

3. In cell B4, find the sample size of the sample of customers who responded from the Data sheet.

4. In cell B5, find the proportion of customers who are satisfied.

5. In cell B6, find the standard error of the proportion.

6. To build the confidence interval for the proportion of satisfied customers from the Data sheet, what is the appropriate probability table to use?

7. In cell B8, find the value from the appropriate probability table to construct a 90% confidence interval.

8. In cell B9, find the margin of error at 90% confidence level.

9. In cell B10, find the upper limit for the population proportion at 90% confidence level.

10. In cell B11, find the lower limit for the population proportion at 90% confidence level.

11. Based on the numbers in cell B9 and B10, we can be 90% confident that

12. In cell B13, find the width of the confidence interval at 90% confidence level.

13. In cell B14, find the value from the appropriate probability table to construct a 99% confidence interval.

14. In cell B15, find the margin of error at 99% confidence level.

15. In cell B16, find the upper limit for the population proportion at 99% confidence level.

16. In cell B17, find the lower limit for the population proportion at 99% confidence level.

17. In cell B18, find the width of the confidence interval at 99% confidence level.

18. By comparing the width of the confidence interval (CI) at 90% and 99%, what can we conclude about the width of the CI?

19. Based on the upper and lower limit values for a 90% confidence level, can the gym's manager be 90% confident that 90% of his customers are satisfied?

20. Based on the upper and lower limit values for a 99% confidence level, can the gym's manager be 99% confident that 90% of his customers are satisfied?

21. What can the gym manager do to reduce the margin of error at 99% confidence interval?

22. In cell B23, find the required sample size to estimate the true proportion of satisfied customers within 3% margin of error, with 99% confidence.

Customer	Customer Response
1	Satisfied
2	Satisfied
3	Satisfied
4	Satisfied
5	Dissatisfied
6	Satisfied
7	Satisfied
8	Dissatisfied
9	Satisfied
10	Satisfied
11	Satisfied
12	Satisfied
13	Satisfied
14	Satisfied
15	Satisfied
16	Satisfied
17	Satisfied
18	Satisfied
19	Satisfied
20	Satisfied
21	Satisfied
22	Satisfied
23	Satisfied
24	Satisfied
25	Satisfied
26	Satisfied
27	Dissatisfied
28	Satisfied
29	Satisfied
30	Satisfied
31	Dissatisfied
32	Satisfied
33	Satisfied
34	Dissatisfied
35	Satisfied
36	Satisfied
37	Satisfied
38	Dissatisfied
39	Satisfied
40	Satisfied
41	Dissatisfied
42	Satisfied
43	Satisfied
44	Satisfied
45	Satisfied
46	Satisfied
47	Dissatisfied
48	Satisfied
49	Satisfied
50	Satisfied
51	Satisfied
52	Dissatisfied
53	Satisfied
54	Satisfied
55	Satisfied
56	Dissatisfied
57	Satisfied
58	Satisfied
59	Satisfied
60	Dissatisfied
61	Satisfied
62	Satisfied
63	Satisfied
64	Satisfied
65	Satisfied
66	Satisfied
67	Satisfied
68	Satisfied
69	Satisfied
70	Satisfied
71	Satisfied
72	Satisfied
73	Dissatisfied
74	Satisfied
75	Dissatisfied
76	Dissatisfied
77	Satisfied
78	Satisfied
79	Satisfied
80	Satisfied
81	Satisfied
82	Satisfied
83	Satisfied
84	Satisfied
85	Satisfied
86	Satisfied
87	Dissatisfied
88	Dissatisfied
89	Satisfied
90	Satisfied
91	Satisfied
92	Dissatisfied
93	Satisfied
94	Satisfied
95	Satisfied
96	Satisfied
97	Satisfied
98	Satisfied
99	Dissatisfied
100	Satisfied
101	Satisfied
102	Satisfied
103	Satisfied
104	Satisfied
105	Satisfied
106	Satisfied
107	Satisfied
108	Satisfied
109	Satisfied
110	Satisfied
111	Satisfied
112	Satisfied
113	Satisfied
114	Satisfied
115	Satisfied
116	Satisfied
117	Satisfied
118	Satisfied
119	Satisfied
120	Satisfied
121	Satisfied
122	Dissatisfied
123	Satisfied
124	Satisfied
125	Satisfied
126	Satisfied
127	Satisfied
128	Satisfied
129	Satisfied
130	Satisfied
131	Satisfied
132	Satisfied
133	Satisfied
134	Dissatisfied
135	Satisfied
136	Satisfied
137	Satisfied
138	Satisfied
139	Satisfied
140	Satisfied
141	Satisfied
142	Satisfied
143	Dissatisfied
144	Satisfied
145	Satisfied
146	Dissatisfied
147	Satisfied
148	Satisfied
149	Satisfied
150	Dissatisfied
151	Dissatisfied
152	Satisfied
153	Satisfied
154	Satisfied
155	Satisfied
156	Satisfied
157	Dissatisfied
158	Satisfied
159	Satisfied
160	Satisfied
161	Satisfied
162	Satisfied
163	Satisfied
164	Satisfied
165	Satisfied
166	Satisfied
167	Satisfied
168	Satisfied
169	Satisfied
170	Satisfied
171	Satisfied
172	Satisfied
173	Satisfied
174	Satisfied
175	Satisfied
176	Satisfied
177	Satisfied
178	Satisfied
179	Satisfied
180	Satisfied
181	Satisfied
182	Satisfied
183	Satisfied
184	Satisfied
185	Satisfied
186	Satisfied
187	Satisfied
188	Satisfied
189	Satisfied
190	Satisfied
191	Satisfied
192	Satisfied
193	Satisfied
194	Satisfied
195	Satisfied
196	Satisfied
197	Satisfied
198	Satisfied
199	Satisfied
200	Satisfied
201	Satisfied
202	Satisfied
203	Satisfied
204	Satisfied
205	Satisfied
206	Satisfied
207	Satisfied
208	Satisfied
209	Satisfied
210	Dissatisfied
211	Satisfied
212	Satisfied
213	Satisfied
214	Satisfied
215	Satisfied
216	Satisfied
217	Satisfied
218	Satisfied
219	Satisfied
220	Dissatisfied
221	Satisfied
222	Satisfied
223	Satisfied
224	Satisfied
225	Satisfied
226	Satisfied
227	Satisfied
228	Satisfied
229	Satisfied
230	Satisfied
231	Dissatisfied
232	Satisfied
233	Satisfied
234	Satisfied
235	Satisfied
236	Satisfied
237	Dissatisfied
238	Satisfied
239	Satisfied
240	Satisfied
241	Satisfied
242	Satisfied
243	Satisfied
244	Satisfied
245	Satisfied
246	Satisfied
247	Satisfied
248	Satisfied
249	Satisfied
250	Satisfied
251	Satisfied
252	Satisfied
253	Satisfied
254	Satisfied
255	Satisfied
256	Satisfied
257	Satisfied
258	Satisfied
259	Satisfied
260	Dissatisfied
261	Satisfied
262	Satisfied
263	Satisfied
264	Dissatisfied
265	Satisfied
266	Satisfied
267	Satisfied
268	Satisfied
269	Satisfied
270	Dissatisfied
271	Satisfied
272	Satisfied
273	Satisfied
274	Satisfied
275	Satisfied
276	Dissatisfied
277	Satisfied
278	Satisfied
279	Satisfied
280	Dissatisfied
281	Satisfied
282	Satisfied
283	Satisfied
284	Satisfied
285	Satisfied