Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

2. If you average the responses to the first seven questions by customer, how closely are those averages correlated to the satisfaction score? Include a

2. If you average the responses to the first seven questions by customer, how closely are those averages correlated to the satisfaction score? Include a scatter chart in your analysis.

Hint: use a regression analysis, check the appropriate boxes to display a useful chart for your analysis and use theR2value as a reference in your discussion.

Burrito Brothers
Customer survey Results
Customer Number Customer survey responses
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Avg Std. dev. Avg Std. dev.
Menu was easy to read 3 5 5 5 5 5 5 5 5 5 4 5 5 4 3 5 4 5 5 5 5 5 5 3 5 4.64 0.69 Menu was easy to read
Order was prepared correctly 3 4 5 4 5 4 3 5 4 5 3 4 5 4 4 5 3 4 5 5 5 4 5 4 5 4.28 0.72 Order was prepared correctly
Food was tasty 2 4 5 2 5 5 4 4 3 4 3 5 5 5 3 4 3 4 3 4 3 4 5 3 4 3.84 0.92 Food was tasty
Food was served hot 2 5 4 3 5 5 5 5 2 3 1 5 5 4 2 3 1 5 3 3 4 5 5 2 3 3.60 1.36 Food was served hot
Employees were courteous and polite 4 4 5 3 5 4 4 5 3 4 3 4 5 5 4 4 3 4 4 4 4 4 4 4 4 4.04 0.60 Employees were courteous and polite
Restaurant was clean 5 4 5 3 5 4 4 5 3 3 3 4 5 5 5 4 3 4 3 4 4 4 4 5 3 4.04 0.77 Restaurant was clean
Value for price paid 4 5 5 2 5 5 5 5 2 3 2 5 5 5 4 3 2 5 3 3 3 5 5 4 3 3.92 1.16 Value for price paid
Overall satisfaction 2 4 5 3 5 4 4 5 2 4 3 4 5 4 3 4 3 4 3 4 4 4 5 3 4 3.80 0.85 Overall satisfaction
Likely to dine with us again? 2 4 5 2 5 4 4 5 2 3 2 4 5 4 3 3 2 4 5 3 3 4 5 3 3 3.56 1.06 Likely to dine with us again?
Likely to recommend us to friends? 2 4 5 2 5 4 4 5 1 3 2 4 5 4 2 3 2 4 5 3 3 4 5 2 3 3.44 1.20 Likely to recommend us to friends?
Average score: items 1-7 2.9 4.3 4.9 2.9 5.0 4.4 4.2 4.9 2.7 3.7 2.6 4.4 5.0 4.4 3.3 3.8 2.6 4.3 3.9 3.8 3.8 4.3 4.8 3.3 3.7
1 2 3 4
How often do you eat at here? First time, less than once/month, 1-3 times a month, weekly, [1,2,3,4] 2 2 4 1 1 4 3 1 1 2 3 4 4 3 2 1 1 4 1 2 3 3 4 2 3 2.44 1.13 Use the count if funtion to find out many customers often eat there and what type of food they get. Count 7 5 6 5
What was the main ingredient: chicken, beef, pork, beans [1,2,3,4] 1 1 3 4 1 1 2 2 3 4 2 2 2 3 1 1 2 1 3 4 1 1 2 3 1 2.04 1.04 Count 10 7 5 3
Burrito Brothers
Weights of Burritos (Pounds)
Sample Number Weights
1 1.13 Descriptive Statistics Bin Frequency
2 1.10
3 1.17
4 1.08
5 1.09
6 1.05
7 1.09
8 1.12
9 1.09
10 1.07
11 1.07
12 1.15
13 1.13
14 0.97
15 1.17
16 1.15
17 1.09
18 1.01
19 1.05
20 1.10
21 1.09
22 1.03
23 1.09
24 1.02
25 1.14
26 1.08
27 1.11
28 1.08
29 1.04
30 1.10
31 1.01
32 1.03
33 1.12
34 1.13
35 1.20
36 1.10
37 1.20
38 1.07
39 0.96
40 1.18
41 1.11
42 1.13
43 1.07
44 1.17
45 1.02
46 1.15
47 1.10
48 1.18
49 1.04
50 1.13
51 1.18
52 1.14
53 1.13
54 1.14
55 1.16
56 1.07
57 1.07
58 1.17
59 1.06
60 1.04
61 1.16
62 1.15
63 1.03
64 1.08
65 1.09
66 1.16
67 1.19
68 1.04
69 1.12
70 1.10
71 1.18
72 1.11
73 1.05
74 1.13
75 1.14
76 1.13
77 1.03
78 1.17
79 1.09
80 1.16
81 1.10
82 1.06
83 1.12
84 1.17
85 1.18
86 1.13
87 1.04
88 1.06
89 1.11
90 1.06
91 1.07
92 1.16
93 1.07
94 1.10
95 1.10
96 1.13
97 1.09
98 1.13
99 1.15
100 1.18
101 1.06
102 1.17
103 1.08
104 1.14
105 1.13
106 1.15
107 1.05
108 1.07
109 1.09
110 1.11
111 1.09
112 1.03
113 1.07
114 1.09
115 1.06
116 1.09
117 1.11
118 1.13
119 1.15
120 1.10
121 1.01
122 1.11
123 1.08
124 1.10
125 1.04
126 1.11
127 1.05
128 1.11
129 1.03
130 1.07
131 1.03
132 1.05
133 1.14
134 1.10
135 1.09
136 1.09
137 1.10
138 1.07
139 1.06
140 1.07
141 1.07
142 1.07
143 1.12
144 1.12
145 1.15
146 1.17
147 1.10
148 1.15
149 1.08
150 1.09

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Successful Writing At Work Concise Edition

Authors: Philip C Kolin

4th Edition

1285974344, 9781285974347

More Books

Students also viewed these Mathematics questions

Question

What is the purpose of a journal?

Answered: 1 week ago

Question

1. Empirical or factual information,

Answered: 1 week ago

Question

1. To take in the necessary information,

Answered: 1 week ago