Contingency analysis

Posted on Updated on

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?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s