04 May Four Hotels Took Part In A Survey On Hotel Guest Satisfaction. A Follow Up Question Was Asked Of All Respondents Who Were Dissatisfied With The Service …
1. Four hotels took part in a survey on hotel guest satisfaction. A follow up question was asked of all respondents who were dissatisfied with the service. These guests were asked to indicate the main reason for their dissatisfaction. You are asked to investigate whether the choice of hotel has any bearing on the main reason for dissatisfaction.
Do not use Excel in this question! Write your answers on paper, showing full working.
(a) State appropriate hypotheses that could be tested to answer the question: “Do the results of the survey provide evidence that the nature of dissatisfaction and the choice of hotel are related?”
(b) A contingency table, summarizing the results of the survey, is given below. The table shows the observed frequencies for each cell, as well as some of the expected frequencies under H0 (in parentheses). Copy down this table, and without using Excel, calculate the remaining expected frequencies under H0. Show working!
Hotel
Fijian Tradeswest Sheraton Coral Reef Totals
Politeness 23 ( ) 7 ( ) 37 (33.7410) 67 (62.0192) 134
Knowledge 25 ( ) 13 ( ) 25 (30.9712) 60 (56.9281) 123
Responsiveness 13 (11.0024) 5 (6.6906) 13 (15.6115) 31 (28.6954) 62
Other 13 (17.3909) 20 (10.5755) 30 (24.6763) 35 (45.3573) 98
Totals 74 45 105 193 417
(c) Write down an expression for the relevant test statistic, and state its distribution under H0(together with any associated parameters!).
(d) Without using Excel, calculate the contribution from the upper-left cell to the observed value of the test statistic.
(e) Given that the observed value of the test statistic is 2
obs = 20.8059, carry out the test (with-out using Excel) at the 5% significance level, and state your conclusion. Is there sufficient evidence to conclude that there is a relationship between the choice of hotel and the nature of
dissatisfaction?
2. 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?
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.