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 - DATA COULD ALSO NOT BE ADDED AS TEXT AS OTHERWISE THE SYSTEM DECLARES THE QUESTION AS TOO LONG)

Vegatarian Quality Deli_Variety Grill_Variety Deli_Quality 4 Vegatarian Variety Cafe_Overall 4 4 4 4 4 4 4 4 4 4 2 4 2 3 4 3 4 Respondenti Grill_Quality 5564156580 4 5564387690 2 5564388530 3 5564388640 4 5564389220 4 5564390490 5 5564414440 2 556441 7740 2 5 3 4 4 3 4 2 3 4 2 4 4 3 3 5 3 3 4 4 4 3 2 2 3 2 4 4 3 3 3 2 2 2 2 3 5564422240 1 2 1 2 3 1 1 2 2 2 2 3 1 2 5564427580 5564457420 5564463910 4 4 3 2 4 3 3 4 2 4 4 3 2 2 4 4 3 1 2 3 2 2 4 4 2 2 4 4 4 5 3 4 2 5 4 4 3 2 4 3 4 5564481210 5564481230 5564481240 5564481380 5564481450 5564481460 4 3 1 1 3 4 4 4 3 3 3 3 3 4 4 3 3 2 2 3 3 4 4 3 4 5564481740 4 4 3 3 3 3 4 4 2 2 3 2 55644824 70 4 5 3 4 5 4 4 4 5 3 4 5 3 4 5564482700 5564482940 1 1 1 1 1 1 1 4 4 3 4 4 3 2 4 4 2 4 4 2 5564483440 5564484600 5564485620 5564489350 5 3 2 4 3 3 3 4 2 4 4 3 2 2 3 3 4 4 5 2 3 5 3 3 5564489640 5564489690 2 1 2 1 1 3 2 5564489730 2 3 3 2 3 3 3 3 4 4 3 4 4 2 4 5564489740 5564490340 4 4 2 2 4 2 2 2 2 4 5 4 4 5 3 4 5564490350 5564490480 5564490560 4 4 5 4 5 4 4 2 2 5 1 4 3 5 5 5564490640 2 2 2 2 4 2 4 5564490810 2 4 2 1 1 3 1 4 3 2 4 2 2 2 2 5564491630 5564492830 5564494480 1 1 1 1 1 1 1 1 2 2 1 1 1 2 5564499140 2 4 4 2 3 4 2 2 4 4 2 4 4 3 2 2 2 2 2 1 2 1 5564501350 5564509830 5564567940 5564570140 5564576750 4 3 4 2 4 2 2 5 4 4 4 2 3 4 3 2 4 4 1 3 5 2 4 4 4 4 4 4 4 3 5564592520 5564598800 1 1 1 1 1 1 1 4 5 3 4 5 4 3 5564612400 5564638350 5564721620 2 3 3 2 4 3 3 2 2 2 2 2 2 2 Vegatarian Quality Deli_Variety Grill_Variety Deli_Quality 4 Vegatarian Variety Cafe_Overall 4 4 4 4 4 4 4 4 4 4 2 4 2 3 4 3 4 Respondenti Grill_Quality 5564156580 4 5564387690 2 5564388530 3 5564388640 4 5564389220 4 5564390490 5 5564414440 2 556441 7740 2 5 3 4 4 3 4 2 3 4 2 4 4 3 3 5 3 3 4 4 4 3 2 2 3 2 4 4 3 3 3 2 2 2 2 3 5564422240 1 2 1 2 3 1 1 2 2 2 2 3 1 2 5564427580 5564457420 5564463910 4 4 3 2 4 3 3 4 2 4 4 3 2 2 4 4 3 1 2 3 2 2 4 4 2 2 4 4 4 5 3 4 2 5 4 4 3 2 4 3 4 5564481210 5564481230 5564481240 5564481380 5564481450 5564481460 4 3 1 1 3 4 4 4 3 3 3 3 3 4 4 3 3 2 2 3 3 4 4 3 4 5564481740 4 4 3 3 3 3 4 4 2 2 3 2 55644824 70 4 5 3 4 5 4 4 4 5 3 4 5 3 4 5564482700 5564482940 1 1 1 1 1 1 1 4 4 3 4 4 3 2 4 4 2 4 4 2 5564483440 5564484600 5564485620 5564489350 5 3 2 4 3 3 3 4 2 4 4 3 2 2 3 3 4 4 5 2 3 5 3 3 5564489640 5564489690 2 1 2 1 1 3 2 5564489730 2 3 3 2 3 3 3 3 4 4 3 4 4 2 4 5564489740 5564490340 4 4 2 2 4 2 2 2 2 4 5 4 4 5 3 4 5564490350 5564490480 5564490560 4 4 5 4 5 4 4 2 2 5 1 4 3 5 5 5564490640 2 2 2 2 4 2 4 5564490810 2 4 2 1 1 3 1 4 3 2 4 2 2 2 2 5564491630 5564492830 5564494480 1 1 1 1 1 1 1 1 2 2 1 1 1 2 5564499140 2 4 4 2 3 4 2 2 4 4 2 4 4 3 2 2 2 2 2 1 2 1 5564501350 5564509830 5564567940 5564570140 5564576750 4 3 4 2 4 2 2 5 4 4 4 2 3 4 3 2 4 4 1 3 5 2 4 4 4 4 4 4 4 3 5564592520 5564598800 1 1 1 1 1 1 1 4 5 3 4 5 4 3 5564612400 5564638350 5564721620 2 3 3 2 4 3 3 2 2 2 2 2 2 2