Please answer the following

*** TO BE DONE WITH THE USE OF EXCEL*** A large hotel chain claims that 96% of its customers leave satisfied with their stay. The results of a customer service study are contained. At a 5% significance level, is there evidence that the proportion of satisfied cus- tomers is not actually 96%? Hotel Satisfaction Survey Answers to question: Were you satisfied with your stay? YES YES YES YES YES YES YES YES YES NO YES YES YES YES YES YES YES YES YES YES YES YES YES NO YES YES YES NO YES YES YES YES YES NO YES YES YES YES TES YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES NO YES NO YES YES YES YES YES YES NO YES YES YES YES YES YES YES YES YES NO YES YES YES YES YES YES YES YES YES YES YES YES NO YES YES YES YES YES YES YES YES YES NO a) Hypotheses: b) p-value: c) Conclusion: (YOU MUST EXPLAIN YOUR ANSWER MATHEMATICALLY) a) b ) PLEASE SHOW YOUR WORK BY COMPLETING THIS TABLE FUNCTION: FIELD 1: FIELD 2: FIELD 3: FIELD 4: ANY ADDITIONAL CALCULATIONS CAN BE SHOWN HERE FINAL ANSWER: ANSWER TO 4 DECIMALS c)