A1 fix Burrito Brothers M N O Q R S U V w Y Z 0.960 Data Minimum Data Maximum 1.200 15 1.170 1.170 1.090 Enter number of cells (10 or less) Number of Cells 10 12 13 14 1.150 1.130 0.970 1.150 1.030 1.080 1.030 1.070 1.090 1.110 1.080 1.040 1.030) 1.170 1.090 1.050 1.110 1.030 1.130 1.070 1.170 1.160 1.070 1.100 1.070 1.120 1.120 1.100 1.150 1.080 Enter smallest and largest limits for the frequency distribution in the yellow cells below. 1.060 1.100 1.160 1.070 1.020 1.100 1.150 1.090 Lower limit Upper limit Cell width 0.950 The lower limit should be slightly less than the data minimum. 1.250 The upper limit should be slightly larger than the data maximum. 0.030 Cell 1.100 0.0481 A B . DE F G H 1 J K 1 3 Frequency Distribution and Histogram 4 This template is designed to handle up to 150 observations. Enter data only in yellow cells. 5 6 DATA 1 2 3 4 5 6 7 7 8 9 10 11 7 1 1.130 1.100 1.170 1.080 1.090 1.050 1.090 1.120 1.090 1.070 1.070 8 2 1.180 1.140 1.130 1.140 1.160 1.070 1.070 1.060 1.040 1.160 9 3 1.060 1.170 1.080 1.140 1.130 1.150 1.050 1.070 1.090 1.110 1.090 10 4 1.150 1.090 1.010 1.050 1.100 1.090 1.030 1.090 1.020 1.140 1.080 11 5 1.160 1.190 1.040 1.120 1.100 1.180 1.110 1.050 1.130 1.140 1.130 12 6 1.090 1.110 1.130 1.150 1.100 1.010 1.110 1.080 1.100 1.040 1.110 13 7 1.010 1.030 1.120 1.130 1.200 1.100 1.200 1.070 0.960 1.180 1.110 14 8 1.100 1.060 1.120 1.170 1.180 1.130 1.040 1.060 1.110 1.060 1.070 15 9 1.030 1.050 1.140 1.100 1.090 1.090 1.100 1.070 1.060 1.070 1.070 16 10 1.150 1.100 1.180 1.040 1.130 1.130 1.090 1.130 1.150 1.180 1.170 17 18 Histogram 19 20 40 21 35 22 23 30 24 25 25 26 20 27 28 15 29 10 30 31 5 32 33 0 0.95 34 0.98 1.01 1.04 1.07 1.10 1.13 1.16 35 Cell Upper Limit 36 37 38 1 2 3 From -Infinity 0.95 0.98 1.01 1.04 1.07 1.10 1.13 1.16 1.19 1.22 To (inclusive) Frequency 0.95 0 0.98 2 1.01 3 1.04 15 1.07 28 1.10 37 1.13 28 1.16 20 1.19 15 1.22 2 1.25 0 6 Frequency 7 8 9 10 1.19 1.22 A1 X fi Burrito Brothers E F G H . 1 J L M N N O P R S T U V W X Y Z Z AA AB AC AD AE AF AG AH AI AJ AK A Customer survey responses 4 5 4 2 3 5 5 5 5 5 10 5 5 4 3 11 4 3 3 1 12 5 4 5 5 13 5 5 5 5 5 14 4 4 5 4 15 3 4 3 2 16 5 5 5 4 3 17 4 3 3 1 1 18 5 4 4 4 4 5 5 19 5 5 3 3 20 5 5 4 3 21 5 5 3 4 22 5 4 4 5 23 5 5 5 5 24 3 4 3 2 25 5 5 4 3 Avg Std. dev. 4.64 0.70 4.28 0.74 3.84 0.94 3.60 1.38 Avg Std. dev. 4.64 0.70 4.28 0.74 3.84 0.94 3.60 1.38 3 5 4 6 7 8 9 5 5 5 5 4 3 5 4 5 4 4 3 5 5 5 2 4 4 5 3 4 4 5 3 5 5 5 2 4 4 5 2 4 4 5 2 4 4 5 1 3 4 5 5 4 4 3 4 4 4 4 4 4 4 4 4.04 0.61 4.04 0.61 A B C D 1 Burrito Brothers 2 3 Customer survey Results 4 Customer Number 5 1 2 3 6 Menu was easy to read 3 5 5 7 Order was prepared correctly 3 4 5 8 Food was tasty 2 4 5 9 Food was served hot 2 5 4 Employees were courteous and 4 4 5 10 polite 11 Restaurant was clean 5 4 5 12 Value for price paid 4 5 5 13 Overall satisfaction 2 2 4 5 14 Likely to dine with us again? 2 4 5 Likely to recommend us to friends? 2 4 5 15 16 17 Average score: items 1-7 3.3 4.4 4.9 18 How often do you eat at here? First time, less than once/month, 1-3 2 2 4 19 times a month, weekly, (1,2,3,4] What was the main ingredient: 1 1 3 20 chicken, beef, pork, beans (1,2,3,4] 21 22 4 5 4 5 Menu was easy to read Order was prepared correctly Food was tasty Food was served hot Employees were courteous and polite Restaurant was clean Value for price paid Overall satisfaction Likely to dine with us again? Likely to recommend us to friends? 3 3 2 3 2 5 5 5 5 3 2 3 2 3 3 4 3 5 5 5 5 5 5 4 4 5 4 3 3 4 3 4 3 3 2 3 2 3 3 3 5 4 3 4 3 4 3 4 3 4 5 4 4 4 5 5 5 5 4 3 3 3 3 4 3 4.04 3.92 3.80 3.56 4.04 3.92 3.80 3.56 0.79 1.19 0.87 1.08 1.23 0.79 1.19 0.87 1.08 4 4 4 4 2 5 3 2 4 4 5 4 2 3 2 4 5 3 3 4 5 2 3 3.44 3.44 1.23 3.1 5.0 4.6 4.3 4.9 3.1 3.9 2.7 4.6 5.0 4.6 3.6 4.0 2.7 4.4 3.7 4.0 4.0 4.4 4.7 3.6 3.9 4.05 0.69 1 1 4 3 1 1 2 3 4 4 3 2 1 1 4 1 2 3 3 4 2. 3 2.44 Count #1 = 7 #2 = 6 #3 = 6 #4 = 6 4 1 1 2 2 3 4 2 2 2 3 1 1 2 1 3 4 1 1 1 2 3 1 2.04 Count #1 = 10 #2 = 7 #3 = 5 #4 = 3 A9 fix 3.14285714285714 c D E F G H 1 J L M N 0 P B S U SUMMARY OUTPUT Overall satisfaction Line Fit Plot 6.0 5.0 Ayresin Paties Multiple R 0.869 R Square 0.756 Adjusted R Square 0.745 Standard Error 0.346 Observations 25.000 4.0 3.0 ANOVA Average score Predicted Average score 2.0 B 1 Burrito Brothers 2 3 Average Score vs. Overall Satisfaction 4 Overall Average score 5 satisfaction 6 3.3 2 7. 7 4.4 4 8 4.9 5. 9 3.1 3 10 5.0 5 11 4.6 4 12 4.3 4 13 4.9 5 14 3.1 2 15 3.9 4 16 2.7 3 17 4.6 4 18 5.0 5 19 4.6 4 20 3.6 3 21 4.0 4 4 22 2.7 3 23 4.4 4 24 3.7 3 25 4.0 4 26 4.0 4 4 27 4.4 4 28 4.7 5 29 3.6 3 30 3.9 4 31 32 33 1 Regression Residual Total ss AUS Siwanget 8.542 #### 71.211 1.696E-08 2.759 #### 11.301 23 24 1.0 0.0 D 1 1 5 6 Intercept Overall satisfaction Coats 1.434 0.689 RawatEnw Arale Zoner 95% Joer952 Zoner 95.0%Uboer 95.0% 0.318 #### 0.000 0.776 2.091 0.776 2.091 0.082 #### 0.000 0.520 0.858 0.520 0.858 2 3 Overall satisfaction RESIDUAL OUTPUT 34 35 36 37 38 39 40 41 bencinatedAerzy SVO Assidua's 1 2.811 0.474 2 4.189 0.239 3 4.878 -0.021 4 4 3.500 -0.357 5 4.878 0.122 6 4.189 0.382 7 4.189 0.097 8 4.878 -0.021 9 2.811 0.331 10 4.189 -0.332 11 3.500 -0.786 12 4.189 0.382 13 4.878 0.122 14 4.189 0.382 15 3.500 0.071 16 4.189 -0.189 17 3.500 -0.786 18 4.189 0.239 19 3.500 0.214 20 4.189 -0.189 21 4.189 -0.189 22 4.189 0.239 23 4.878 -0.164 24 3.500 0.071 25 4.189 -0.332 42 43 44 45 46 47 48 49 50 51 52 53 54 A1 fx Burrito Brothers C D E F G I 1 J K L M N Descriptive Statistics Bin Frequency 1 0 1 1 1 3 1 15 1.1 28 1.1 37 1.1 28 1.2 20 1.2 15 1.2 1.3 Mean 1.100 Standard Error 0.004 Median 1.100 Mode 1.090 Standard Deviatic 0.048 Sample Variance 0.002 Kurtosis -0.293 Skewness -0.138 Range 0.240 Minimum 0.960 Maximum 1.200 Sum Count Largest(1) 1.200 Smallest(1) 0.960 ON TWO A B 1 Burrito Brothers 2 3 Weights of Burritos (Pounds) 4 5 Sample Number Weights 6 1 1.13 7 2 1.10 8 3 1.17 9 4 1.08 10 5 1.09 11 6 1.05 12 7 1.09 13 8 1.12 14 9 1.09 15 10 1.07 16 11 1.07 17 12 1.15 18 13 1.13 19 14 0.97 20 15 1.17 21 16 1.15 22 17 1.09 23 18 1.01 24 19 1.05 25 20 1.10 26 21 1.09 27 22 1.03 28 23 1.09 29 24 1.02 30 25 1.14 31 26 1.08 32 27 1.11 33 28 1.08 34 29 1.04 35 30 1.10 31 1.01 37 1.03 33 1.12 34 1.13 35 1.20 41 36 1.10 42 37 1.20 43 38 1.07 44 39 0.96 Attit fit Histogram 40 35 30 25 Frequency 20 15 Frequency 10 5 32 o 0.95 0.98 1.01 1.04 1.07 1.1 1.13 1.16 1.19 1.22 1.25 Bin Burrito Brothers is a small regional chain of quick service restaurants in the Midwest. They specialize in four types of burritos: chicken, beef, pork, and a bean-based vegetarian item. The burritos are made-to- order, so customers can add rice, cheese, guacamole, tomato, lettuce, and salsa to fill out the wrap. The burrito is then placed in a paper wrapper to ensure ease of handling and sanitary delivery to the customer. Lately, one of the store managers, Hector Gustavo, has been hearing customer complaints, ranging from such comments as: "The tortilla wrap (bread) is too thin, it's breaking"; or "The food is not hot; Every time I get a burrito it seems to be a different size"; and I got the wrong ingredients on my burrito." Juan knew that he needed to systematically survey his customers. Many complaints were submitted through the corporate website. Hector's district manager was most concerned with the comment on size. To be competitive, it is important that customers receive consistent food and service. Hector knew a professor at the local university, who taught an MBA class in quality management. He told Hector that he was always looking for projects for his student teams. Hector decided to ask the professor if he would have a team of students design a customer survey, instruct his workforce on how to weigh and record burrito weights, gather customer comments, analyze the data, and make recommendations on what should be done to improve the operations of Burrito Brothers. The student team developed a survey using the questions in Table 6.3, based on a 5-point Likert scale [5 = excellent, or strongly agree; 1 = poor or strongly disagree) for the first 10 questions. The last two questions were coded as a 1, 2, 3, or 4. They administered the questionnaire to 25 random customers and gathered data on 150 burrito weights in samples of 3, each. See Excel workbook C06 Burrito Brothers Case Data on the Student Companion Site for the data. Customer Survey Questions Was the menu easy to read? Was order prepared correctly? Was the food tasty? Was the food served hot? Were employees courteous and polite? Was the restaurant clean? In your opinion, did you receive a good value for the price you paid? What was your level of satisfaction? How likely are you to dine with us again? How likely are you to recommend us to your friends/family? How often do you eat at Sizzle king? First time, less than once/month, 1-3 times a month, weekly? What was the main ingredient in your burrito: chicken, beef, pork, beans? Discussion Questions 1. What conclusions do you reach when you calculate descriptive statistics for the answers to each of the survey questions in the database? 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. 1. What conclusions do you reach when you calculate descriptive statistics for the answers to each of the survey questions in the database? 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. 3. 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 value? 4. Analyze the data on burrito weights using descriptive statistical measures such as the mean and standard deviation, and tools such as a frequency distribution and histogram. What do your results tell you about the consistency of the food servings? 5. What recommendations for decision-making and improvement can you make to Hector Gustavo