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 a histogram.

Using the attached excel spreadsheet and the information below please answer the four case questions at the very bottom. Include a separate Excel document with all calculations and please make sure the case questions are answered in a word document in APA format.

Information for paper:

Rapido Burrito is a small, regional chain of quick service restaurants. Rather than wait in a cafeteria-style line, customers check boxes for their choice of ingredients, sauce, and so on paper menus at their table. The food is prepared quickly and then delivered to the tables.

Lately, one of the store managers has been hearing customer complaints, such as: “The tortillas are too thin”; “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.” Many complaints were submitted through the corporate website.

The district manager was most concerned with the comments about the consistency of size. One of the staff designed a customer survey using the questions below, 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.

Customer Survey Questions:

Was the menu easy to read?

Was the 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 Rapido Burrito? First time, less than once/month, one to three times a month, weekly?

What was the main ingredient in your burrito: chicken, beef, pork, or beans?

They administered the questionnaire to 25 random customers. The restaurant also gathered data on the weights of 50 samples of 3 burritos (a total of 150). Both the survey data and weight data are available on the Excel worksheet Rapido Burrito Case Data included in Week 1 of this course.

Case Questions:

What conclusions do you reach when you calculate descriiptive statistics for the answers to each of the survey questions in the database?

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.

Analyze the data on burrito weights using descriiptive statistical measures such as the mean and standard deviation, and tools such as a frequency distribution and a histogram. What do your results tell you about the consistency of the food servings?

What recommendations for decision making and improvement can you make to the store manager?

Answer & Explanation
VerifiedSolved by verified expert
To analyze the data on burrito weights, we would first need to collect the data. Once we have the data, we can perform various descriptive statistical measures and tools to analyze it.

Let’s assume we have collected data on burrito weights from a local restaurant, and we have the following weights (in ounces) for 50 burritos:

6.5, 7.2, 7.5, 7.8, 8.1, 8.2, 8.3, 8.5, 8.6, 8.6, 8.8, 8.9, 9.0, 9.2, 9.3, 9.5, 9.6, 9.7, 9.8, 9.8,
9.9, 10.0, 10.1, 10.2, 10.3, 10.4, 10.5, 10.5, 10.6, 10.7, 10.7, 10.8, 11.0, 11.1, 11.2, 11.3, 11.4, 11.5,
11.6, 11.7, 11.8, 12.0, 12.1, 12.2, 12.3, 12.5, 12.7, 13.0, 13.1, 13.5

Descriptive statistical

Looking for a similar assignment?

Let Us write for you! We offer custom paper writing services

Place your order

Step-by-step explanation

Mean: The mean is a measure of central tendency that represents the average weight of the burritos. We can calculate the mean by adding up all the weights and dividing by the total number of burritos.


Mean = (6.5 + 7.2 + … + 13.5) / 50 = 9.98 ounces

Standard deviation: The standard deviation is a measure of the spread of the data. We can calculate the standard deviation by finding the square root of the variance, which is the average of the squared differences from the mean.


Variance = [(6.5 – 9.98)^2 + (7.2 – 9.98)^2 + … + (13.5 – 9.98)^2] / 50 = 4.43

Standard deviation = sqrt(Variance) = 2.10 ounces


Frequency distribution: A frequency distribution is a table that shows how often each weight occurs in the data set. We can create a frequency distribution by grouping the weights into intervals and counting the number of burritos in each interval.


Weight Interval | Frequency
6.0 – 7.9 | 4
8.0 – 9.9 | 18
10.0 – 11.9 | 19
12.0 – 13.9 | 9

Histogram: A histogram is a graphical representation of the frequency distribution, where each interval is represented by a bar with a height equal to the frequency of the interval.

Download PDF