Activity: TQM Charting Practice This activity consists of two problems.

 

 

  1. Activity: TQM Charting Practice
    This activity consists of two problems.
    Problem One
    Dr. Raymond Hill, Director of Surgery, for Forest Medical Center in Lake Park, Illinois, received some recent statistics concerning data on the surgeries performed in his center during 2019. He was somewhat surprised to see the high number of what is classified as “late surgeries.” He has asked you, a quality analyst, to examine this data.
    He requests the following items from you:

    1. Create a scatter plot in Excel of the number of late surgeries versus the overall number of surgeries.
    2. Create a run chart in Excel for the number of late surgeries and a run chart for the overall number of surgeries for 2019.
    3. Create separate control charts in Excel for the number of late surgeries and the overall number of surgeries with a 95% confidence level.  Show all calculations that you use to arrive at these control charts.
    4. In a Word document, draw two conclusions regarding these three analyses regarding the late surgeries at Forest Medical Center.
    5. Late Surgeries versus Overall SurgeriesMonthNumber of SurgeriesNumber of Late SurgeriesJanuary435112February401129March572186April409103May57789June329156July467156August30194September23589October325127November378156December444124Total48731432Problem Two
      Dr. Amanda Guzik, head of infectious diseases for Forest Medical Center in Lake Park Illinois, asks you to analyze the following influenza data that she has collected over five years from cases that were treated at this medical center.
    6. Use Excel to create a run chart for the data.
    7. Use Excel to create a control chart with a 95% confidence level for this data. Include the mean, the LCL, and the UCL. Show all calculations that you use to arrive at these control charts.
    8. In a Word document, draw two conclusions from these charts regarding the influenza cases that the Forest Medical Center had treated.
    9. Submit Word document(s) and Excel file(s) showing your responses and calculations.
      Influenza Data by QuarterYearQuarter# of Cases of Influenza Observed11345212346134831439842141202237623429243583314219323853339234361441356842439433264441035142095239653411544008
  2. By submitting this paper, you agree: (1) that you are submitting your paper to be used and stored as part of the SafeAssign™ services in accordance with the Blackboard Privacy Policy; (2) that your institution may use your paper in accordance with your institution’s policies; and (3) that your use of SafeAssign will be without recourse against Blackboard Inc. and its affiliates.
  3. Institution Release Statement

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Discussion 1 – Sport Organizations Merger

 Explain the fundamental accounting differences between using the pooling of interests method versus the purchase of assets methods when dealing with the merger of two sport organizations. Please post what you view as the appropriate responses to the above prompts. You must justify your answer. Your post must have a

Amy Hill posted Jul 21, 2022 7:07 PM In your

Amy Hill posted Jul 21, 2022 7:07 PM In your overviews of each article, focus on how the information in the article informs the implementation of IGR initiatives. Include what you believe is the most significant takeaway from the article and why. Do this for both articles. Post your summary

APA format 1) Minimum 4 pages (No word count per

  APA format 1) Minimum 4 pages  (No word count per page)- Follow the 3 x 3 rule: minimum of three paragraphs per page You must strictly comply with the number of paragraphs requested per page. 2)¨******APA norms          All paragraphs must be narrative and cited in the text- each paragraph

Summary of assignment: Prevention of shoplifters

Summary of assignment • Task: You will complete the following: o Select a topic for writing assignment #4 o Research that topic in OneSearch o Locate at least seven articles from scholarly or credible trade journals on the topic o Write a synthesis of the articles. • Length: 1000-1400 words.

Describe one type of interpersonal interaction at which you’d like

Describe one type of interpersonal interaction at which you’d like to be more effective. Why is this important to you? Please respond in 200 words or more to this week’s question. Two substantive responses to two different peers are required within three days of the start of the discussion forum

Assignment #4: Roots of Organizational Policy (20 points) IMPORTANT: No

Assignment #4: Roots of Organizational Policy (20 points) IMPORTANT:  No late submissions after the final day of class will be allowed for the final assignment, as final course grades are due within 72 hours of the due date. Students who fail to submit will earn a 0%.   The Comprehensive Final Project (Assignment

Using E-Books in the Teaching and Learn

 Description Develop a template (e.g., a book report guide) for students to use to evaluate an e-book. Develop a lesson based on an e-book. Develop a template of how to evaluate an online reading program. You should keep this in your personal “toolbox” of resources for use later in the

GTR has asked you to advise them on resources available

  GTR has asked you to advise them on resources available to users. Write a 1- to 2-page reference table that lists at least 4 resources available on the AWS website, such as FAQs, videos, whitepapers, tutorials, case studies, etc. The audience for your table will be business users engaged

Use COVID-19 to compare three health care systems: the US,

Use COVID-19 to compare three health care systems: the US, the UK and Costa Rica. What is the scope of the problem globally? In each of the countries listed above? What systems are in place to address it? Who are the actors? How does this problem affect the Common Good? 

Evaluation of the BSN program

The end of program evaluation of the BSN program outcomes will be comprehensively analyzed in a synthesis paper. The paper should be no more than 5 pages and will include the elements below. The student will identify the element below, identify in which course the element was achieved, and provide

In this unit, you will take on the role of

 In this unit, you will take on the role  of marketing manager of a major corporation. Your internal market  research team needs assistance with market research report writing.  Prepare a PowerPoint Presentation instructing how to compile a written  market research report. The PowerPoint Presentation should include the  following:  Explain the

The United Nations (UN) has hired you as a consultant,

  The United Nations (UN) has hired you as a consultant, your task is to assess the impact that global warming is expected to have on population growth and the ability of societies in the developing world to ensure the adequate security of their food supplies. Case Assessment Summary (see

Observation 4th Nursing Assignment Help

For the video below, please compare what you have learned in class and what you saw in the video. Expert Solution Preview Introduction: In this medical college course, we focus on the practical application of theoretical knowledge to real-life scenarios. Our goal is to ensure students are well-equipped to handle

GCU Change and Conflict Analysis Nursing Assignment Help

You are the site manager for a health care center caring for an urban population experiencing homelessness. After the identification of patient safety concerns, you have realized the need to institute a new quality initiative regarding how patients’ home medications are stored when they are admitted. This new initiative involves

CHP 425 Case Study Palliative Care Nursing Assignment Help

Palliative Care (aka End of Life Care).  Please complete the Pre-test prior to beginning Case#5. Please see the attached case – read and complete the questions – in paragraph form.  Please use the APA sample paper for Title Page, include citations/references where appropriate.    Expert Solution Preview Introduction: Palliative Care,

4- Disrritmias. Es importante que puedas identificar el tipo de

4- Disrritmias. Es importante que puedas identificar el tipo de disrritmia con el trazado y gaprecies los cambios en el electrocardiograma. Por lo tanto, busca un trazado según el tipo de disrritmia y pégalo en el espacio correspondiente. Luego llena el resto de la tabla.  Tipo, Trazado, Fisiopatología, Manifestaciones   clínicas,