The contract for cafeteria services at your company is under review. As part of the review, a survey was conducted with 50 randomly selected employees. They responded to each question on a scale from 1 (Very Dissatisfied) to 5 (Very Satisfied). [Excel file Cafeteria Survey]

Based on the data provided in the "Cafeteria Survey", you are to calculate the mean, mode, standard deviation, and five-number summary for each area of interest (grill, deli, vegetarian, and overall experience). Additionally, you will provide a box plot graph for each variable. Provide a brief interpretation of the results for each question. Summarize your findings and answer the following question. Should the company renew the contract for cafeteria services? In your Excel workbook, include the following: The analysis for each area of cafeteria service. ? a descriptive analysis (mean, mode, standard deviation and fivenumber summary) for ? grill (quality and variety) ? deli (quality and variety) ? vegetarian (quality and variety) ? overall experience (satisfaction)

In your summary report (document file), include the following:

In your report you will provide the descriptive data with box plots for each variable and your interpretation of the results. Your descriptive statistics will include the mean, mode, and standard deviation. In addition, you will provide a five-number summary of the data. The numbers chosen for the five-number summary help us know the center of our data, as well as how spread out the data points are. The five-number summary consists of the following:

? The minimum - this is the smallest value in our data set. ? The first quartile - this number is denoted Q1 and 25% of our data falls below the first quartile. ? The median - this is the midway point of the data. 50% of all data falls below the median. ? The third quartile - this number is denoted Q3 and 75% of our data falls below the third quartile. ? The maximum - this is the largest value in our data set. The mean, mode, standard deviation, and five-number summary are used to convey the center and the spread of a set of data.

As a summary, answer the following question and support your answer with statistics from your analysis: Should the company renew the contract for cafeteria services?

Excel Data Cafeteria Survey:

Response scales: 1 Very Dissatisfied 2 Dissatisfied 3 Not Sure 4 Satisfied 5 Very Satisfied

BELOW IS THE EXCEL DATA AS AN IMAGE (EXCEL FILE CANNOT BE ADDED HERE. PLEASE USE THIS IMAGE TO DO THE WORK IN EXCEL)

Vegatarian_ Vegatarian_ RespondentID Grill_Quality Deli Quality Quality / Deli_Variety Grill_Variety Variety Cafe_Overall