A large hotel chain claims that 96% of its customers leave satisfied with their stay.The results of a customer service study are containedbelow (this sample is also contained in the DATA 1 tab of the downloaded excel file)..At a 1% significance level, is there evidence that the proportion of satisfied customers is actually less than 96%?

Satisfied with hotel stay?YESYESYESYESYESYESYESYESYESNOYESYESYESYESYESYESYESNOYESYESYESNOYESYESYESYESYESYESYESYESYESYESNOYESYESNOYESYESYESYESYESNOYESYESYESYESYESYESYESYESYESYESYESYESYESYESYESNOYESYESYESYESYESYESYESYESYESYESYESYESYESYESYESYESNOYESYESYESYESYESYESNOYESYESYESYESYESYESYESYESYESYESYESYESYESYESYESYESYESYESYESYESYESYESYESYESNOYESYESYESYESYES

a) Properly state the hypotheses:(1 mark)

b) Calculate the p-value (SHOW ALL WORK):(3 marks)

IN ORDER TO SHOW YOUR WORK FOR PART B...CREATE A TABLE THAT MIMICS THE EXCEL FUNCTION YOU ARE USING...YOUR ANSWER SHOULD INCLUDE THE FOLLOWING:

1) FUNCTION NAME:

2) FIELD 1 ENTRY:

3) FIELD 2 ENTRY:

4) FIELD 3 ENTRY:

5) FIELD 4 ENTRY:

6) YOUR FINAL ANSWER:

IF THERE ARE NOT 4 "ARGUMENTS" FOR THE EXCEL FUNCTION, INCLUDE ONLY THE NUMBER OF FIELDS THAT ARE APPLICABLE.

YOUR FIELD ENTRIES MUST BE NUMERICAL VALUES...NOT CELL REFERENCES

c) Conclusion:(Must be mathematically justified)(1 mark)

Question