*** 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 below (also available for download hereHotel.xlsx).At a 1% significance level, is there evidence that the proportion of satisfied customers is not actually 96%?

Hotel Satisfaction SurveyAnswers 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 NO YES YES YES NO YES YES YES YES YES YES YES YES YES YES NO YES YES NO YES YES YES YES YES NO YES YES YES YES YES YESYES YES YES YES YES YES YES YES YES NO YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES NO YES YES YES YES YES YES NO YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES NO YES YES YES YES YES

a) Hypotheses:(1 mark)

b) p-value:(3 marks)

c) Conclusion:(1 mark)(YOU MUST EXPLAIN YOUR ANSWER MATHEMATICALLY FOR THE MARK)