Instructions : Construct the control charts in Excel, each problem takes ONE tab. Submit a SINGLE…

Instructions:

  1. Construct the control charts in Excel, each problem takes ONE tab. Submit a SINGLE Excel file (with TWO tabs).
  2. To minimize the possibility of typos during data transfer, please copy and paste the data table from this document to a new Excel worksheet.
  3. Start interpreting a chart ONLY AFTER the chart has been found to be in statistical control (or stable). If the first iteration of the chart is not stable, remove those data points which are out of control and reconstruct the chart in the second iteration (to confirm it is now stable).
  4. After constructing the charts, there are a few questions you need to provide brief answers to. These answers should be just a few sentences in length. You can type them in a blank spot right on the same Excel tab (by the charts).

**Please show calculations in excel with the formulas**

Case 1:

Detroit Central Hospital is trying to improve its image by providing a positive experience for its patients and their relatives. Part of the “image” program involves providing tasty, inviting and healthy patient meals. A questionnaire accompanies each meal served, asking the patient, among other things, whether he or she is satisfied or unsatisfied with the meal. A 100-patient sample was drawn everyday over the past 31 days and yielded the data in the table below. Construct a control chart in Excel that plots the percentage of unsatisfied patients. Set the control limits to include 99.7% of the random variation in meal dissatisfaction rate.

Based on the information from the control charts you constructed, answer the following questions:

Is the process in statistical control? If not, what are the days that should be investigated? What are other possible recommendations you want to give to the management for continuous improvement on patient satisfaction (as demonstrated in the survey results)?

Day

No. of Unsatisfied Patients

1

20

2

18

3

8

4

15

5

10

6

27

7

28

8

10

9

15

10

19

11

16

12

11

13

18

14

23

15

16

16

22

17

23

18

18

19

21

20

13

21

9

22

18

23

15

24

20

25

23

26

14

27

17

28

19

29

14

30

22

31

18

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with My Study Writers
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Management
It's the second time I use this service and it does not let me down. Work quality is so good for its price!
Customer 452985, December 3rd, 2021
Business and administrative studies
excellent
Customer 453201, December 4th, 2022
Business and administrative studies
excellent
Customer 453201, November 8th, 2022
Business and administrative studies
excellent
Customer 453201, October 22nd, 2022
Business and administrative studies
excellent
Customer 453201, November 21st, 2022
Business Management
Awesome job, Thank you
Customer 453201, June 12th, 2022
Psychology
quick and before due date/time.
Customer 453027, January 29th, 2022
Other
Thank you , Excellent work
Customer 453201, June 2nd, 2022
Business and administrative studies
awesome job
Customer 453201, June 24th, 2022
Sociology
THANK YOUUUUU
Customer 452591, March 18th, 2021
Nursing
The writer was timely and proficient. I had to ask for a revision, but I got it back quickly with no other issues. Would use this essay writing service again
Customer 452441, November 14th, 2021
Health Care
The writer did not follow my choice of topic (Food/Water Insecurity, Hunger, & Poverty), the paper was instead written about Climate Change in Africa. However, the paper was still great and informative. Thank you!
Customer 452777, January 28th, 2022
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend
OUR GIFT TO YOU
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat
Live ChatWhatsApp