Question: how do you write a paper and excel workbook with solutions and box plot graphs based on the scenario below. Scenario: The contract for cafeteria
how do you write a paper and excel workbook with solutions and box plot graphs based on the scenario below.
Scenario: The contract for cafeteria services at your company is under review. As part of the review,Cafeteria Survey.XLSXwas conducted with 50 randomly selected employees. They responded to each question on a scale from 1 (Very Dissatisfied) to 5 (Very Satisfied).
Response scales:
- 1 Very Dissatisfied
- 2 Dissatisfied
- 3 Not Sure
- 4 Satisfied
- 5 Very Satisfied
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, includea descriptive analysis (mean, mode, standard deviation and five-number 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:
- 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.
- Provide a five-number summary of the data (useMTH 2010 Five Number Summary.pdfif you need help with your five-number summary)
- As a summary, answer the following question and support your answer with descriptive statistics from your analysis: should the company renew the contract for cafeteria services? + Excel Worksheet (4 worksheets)
References:Include a minimum of 2 scholarly resources
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
