Homework SourseRead the minicase Sizzlegrill Burrito House on page 302 and
Read the mini-case, Sizzlegrill Burrito House on page 302 and answer the questions at the end. Note that the excel data file mentioned in the case is attached via the link above. Note that the questions here are different than the ones in the textbook. Answer these questions.
1. What conclusions do you reach when you look at the descriptive statistics for the answers to each of the survey questions in the database (see Survey Responses attachment above)?
2. If you average the responses to the first seven questions by customer, how closely are those averages correlated to the satisfaction score (see Survey Responses attachment above)? Explain your findings. Do they make sense to you?
3. Analyze the data on burrito weights (see Burrito Statistics attachment above). Notice that the Mean, Median, Mode, and Standard Deviation are calculated for you (you are welcome). What do your results tell you about the consistency of the food servings?
4. Should Juan Nicely be concerned about the burrito weight variance? Explain why or why not?
5. What recommendations for improvement can you make to Juan Niceley?
***TEXT BELOW***
Survey Responses
Customer Survey Responses
Mean (Average)
Standard Deviation
Menu was easy to read
4.56
1.06
Order was prepared correctly
4.23
1.06
Food was tasty
3.90
1.08
Food was served hot
3.78
1.34
Employees were courteous and polite
4.03
0.92
Restaurant was clean
4.00
1.01
Good value for price paid
4.01
1.19
Overall satisfaction
3.90
1.05
Likely to dine with us again?
3.62
1.13
Likely to recommend us to a friend?
3.57
1.17
Questions were asked on a 5-point scale (5 = Excellent or Strongly Agree, 1 = Poor or Strongly Disagree)
Burrito Statistics
Weight
Frequency
1.25
0
1.30
3
1.35
9
1.40
16
1.45
17
1.50
34
1.55
22
1.60
23
1.65
11
1.70
7
1.75
6
1.80
1
1.85
1
More
0
Mean = 1.509
Median = 1.500
Mode = 1.570
Standard Deviation = 0.108
The “Weight” in the col. on the left designates a weight range. The Frequency” in the col. on the right designates the number of burritos sampled that were within that range. For example, no burritos weighed 1.25 lb. or less, three burritos weighed between 1.30 and 1.25 lbs., etc.
| Customer Survey Responses | Mean (Average) | Standard Deviation |
| Menu was easy to read | 4.56 | 1.06 |
| Order was prepared correctly | 4.23 | 1.06 |
| Food was tasty | 3.90 | 1.08 |
| Food was served hot | 3.78 | 1.34 |
| Employees were courteous and polite | 4.03 | 0.92 |
| Restaurant was clean | 4.00 | 1.01 |
| Good value for price paid | 4.01 | 1.19 |
| Overall satisfaction | 3.90 | 1.05 |
| Likely to dine with us again? | 3.62 | 1.13 |
| Likely to recommend us to a friend? | 3.57 | 1.17 |
Solution
\"Menu was easy to read\" has the highest mean and \"Likely to recommend us to a friend\" has the lowest mean.So,\"Menu was easy to read\" serves best and \"Likely to recommend us to a friend\" is worst among all services.
The service \"Food was served hot\" has the highest variance,so it is least consistent and the service \"Employees were courteous and polite \" has the lowest variance,so it is most consistent.
The burrito weight variance is (0.108)2=0.011664 which is signficantly different from 0,that means the different burrito weights are different from each other.Juan Nicely should be concerned about the burrito weight variance
