To undertake contingency analysis in Excel, first enter the data, then go KaddSTAT -> Hypothesis
Testing -> Chi-Square Test. Select the data as Input Range, tick the Header Row and Column
Included box, and choose where you want Excel to print the output.
Enter the data from Q1 as shown below:
(a) Use Excel to generate an appropriate output for a test for independence of the two variables of interest, carry out the test, and check that your conclusions are the same as in Q1.
(b) If there is evidence that the nature of dissatisfaction is related to the choice of hotel, where do the discrepancies lie? Which hotel(s) could be advised to improve their service, and in which area(s)? Do any of the hotels appear to provide significantly better service than the others in a particular area?