Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can the likelihood of the customer dining again at Burrito Brothers be predicted by using the satisfaction score and regression analysis? How good is that
- Can the likelihood of the customer dining again at Burrito Brothers be predicted by using the satisfaction score and regression analysis? How good is that prediction likely to be, based on the R2 value?
Hint: use the regression analysis to construct the relationship between the two variables "overall satisfaction" and "likely to dine again". Make sure to include the scattered
chart that shows the line fit.
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started