Question

You have done a market research study for a local restaurant by surveying 50 customers. You asked several Likert-type scaled questions, requesting level of agreement with a series of statements (where 1 = completely disagree and 7 = completely agree). These questions include:

X1: I liked the food at the restaurant. (respond on a 1-7 scale)

X2: I liked the service at the restaurant. (respond on a 1-7 scale).

Your results are in the Excel spreadsheet “Customer Satisfaction Study Part 1.”  

You think there might be a difference between how much people like the food and how much they like the service and you will do a statistical analysis to see if the difference is significant.

Part 1--State the null and alternate hypotheses in plain English sentences (not equations).

Part 2--Using Excel or any statistical package you are familiar with, do the appropriate statistical analysis to determine if these two variables are significantly different from each other. Clearly justify your choice of statistical analysis. Print out the computer results.  

Part 3--Can you reject the null hypothesis? Why or why not? Make a brief recommendation to management based on your findings.

Customer No.	X1: I liked the food	X2: I liked the service
1	6	4
2	5	5
3	7	2
4	7	3
5	6	4
6	7	5
7	6	4
8	7	2
9	6	5
10	7	5
11	6	3
12	5	2
13	4	2
14	7	3
15	5	3
16	7	3
17	7	3
18	6	2
19	4	2
20	6	5
21	7	2
22	4	2
23	7	3
24	7	1
25	4	3
26	7	4
27	5	4
28	5	5
29	7	2
30	4	3
31	7	3
32	7	4
33	7	6
34	6	5
35	7	4
36	6	4
37	6	3
38	7	6
39	7	6
40	7	4
41	5	4
42	6	4
43	5	3
44	6	4
45	5	3
46	7	3
47	6	3
48	6	3
49	6	3
50	7	2

Answer 1

Null Hypothesis H₀ : The liking for food and service are independent (i.e) correlation coefficient=0

Alternative Hypothesis H₁ :The liking of food and service are dependent (ie)correlation coefficient

0

Level of significance = 0.05

Since it is a ordinal data ,we may use of Spearmen rank correlation coefficient,r_s = .077

To test for significance of r_s ,t test is used .

The p value is .594

Since p value > 0.05 ,we accept null hypothesis and we can conclude that the liking of food and service are indepenfind and the recommendation is that the restaurant can continue their services without depending on one and another