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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!