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

Explain how the lack of autonomy for APRNs impact patients in rural populations? As a health care professional in an advocacy role, what resources could you utilize to guide you in changing policies t Nursing Assignment Help

Explain how the lack of autonomy for APRNs impact patients in rural populations? As a health care professional in an advocacy role, what resources could you utilize to guide you in changing policies that impact APRNS in your state? Include in your discussion the type of stakeholders and collaborative partners

Types of nutrition – Premium Paper Help

Premium Paper Help is a professional writing service that provides original papers. Our products include academic papers of varying complexity and other personalized services, along with research materials for assistance purposes only. All the materials from our website should be used with proper references.

Instructions: You are to write a 4-5 page pape’r (not

 Instructions: You are to write a 4-5 page pape’r (not including the reference page) reflecting on learning points from your time in Communication 8: Group Discussion.  I have posed some questions below to help guide your thinking as you start your process.  You do not have to answer all or

Please write an paper of 2/3 pages (excluding cover, title,

 Please write an paper of 2/3 pages (excluding cover, title, abstract, references …etc) on any topic of your choice which relates or is discussed in chapter one of our course text. Your paper must relate DIRECTLY to the subject of this class and to chapter one.  * The four purposes

Diagnostic Process

This is a critical thinking essay exam Q1: Explain the diagnostic process from beginning to end in either a medical setting or a school. Explain how you would collect information, what information you would want to collect, who you would collect information from and why, what tests you would choose,

Discuss the different states of consciousness that you have experienced

Discuss the different states of consciousness that you have experienced in the past 24 hours, including any periods when you were asleep, alert, or “daydreaming.” Be sure to describe both the brain and bodily activity you experienced during each state of consciousness. Include information from class materials, readings, and research

Read and summarize chapter 17 of Biz Law Text in

  Read and summarize chapter 17 of Biz Law Text in at least 400 words. *Can Ebooks be considered “Goods?” Why or Why Not? CHAPTER 17  7.1 Sale of Goods LegislationThe  Sales  of  Goods  legislation  applies  to  all  contracts  involving  the  sale  of  goods  commercially  or  for  everyday use. A contract

Nightingale Theory. Discuss the theoretical assumptions, and/or propositions, present and explain theory,( analysis of the theory.) Nursing Assignment Help

Nightingale Theory. Discuss the theoretical assumptions, and/or propositions, present and explain theory,( analysis of the theory.) Expert Solution Preview Introduction: The Nightingale Theory, also known as the Environmental Theory of Nursing, was developed by Florence Nightingale, a renowned nurse and social reformer. This theory has had a significant impact on

Overview Using the recommendation that you provided in Milestone One,

Overview Using the recommendation that you provided in Milestone One, you will develop a strategy to implement the innovation and get ahead in the marketplace. Scenario You work as a middle manager for one of the top U.S. producers of luxury and mass-market automobiles and trucks. You are now leading

Virtue Ethics Essay Respond to one of the following three “news clippings” related to virtue ethics. Write a 2 page essay addressing the discussion questions posed for the one you selected. Be sure Nursing Assignment Help

Virtue Ethics EssayRespond to one of the following three “news clippings” related to virtue ethics.  Write a 2 page essay addressing the discussion questions posed for the one you selected.  Be sure to clearly identify the news clipping you selected.#1 Wrong Operation Doctor (ethics and integrity) Hospitals find it hard to protect patients

you will pick any career the easiest one you can

you will pick any career the easiest one you can do, I prefer Technology Carrer. As part of the course, there is a required final project. This project is for you to begin/continue researching potential career fields you are interested in pursuing. This final project is an opportunity to explore

Laparotomy – Premium Paper Help

Premium Paper Help is a professional writing service that provides original papers. Our products include academic papers of varying complexity and other personalized services, along with research materials for assistance purposes only. All the materials from our website should be used with proper references.

Task analysis is used mainly to investigate an existing situation.

Task analysis is used mainly to investigate an existing situation. Hierarchical task analysis (HTA) is used to break down a task into subtasks. Consider one of your daily routine tasks, such as filling your car with gas or getting money from the automated teller machine (ATM). Now, break your chosen

Ricardian Model:

1:         (10 points) Consider the 2×2 Ricardian Model.  Let the following hold:   MANUFACTURE PRODUCTIVITY (output per worker) AGRICULTURE PRODUCTIVITY (output per worker) LABOUR ENDOWMENT HOME 20 10 100 FOREIGN 15 5 100 a)      Draw the PPF for each country.  Note:  the data above is in terms of output per

Opinion paper: Mental illnesses in Jail/prisons

 800 words; A hook drawing the readers attention; thesis statement that clearly states my opinion (my opinion: Unfortunately, our current Criminal Justice system undermines the complexity and severity of the amount of inmates with a mental illness. Inmates will not be able to successfully be rehabilitated into society without appropriate

How Global Warming effects Zoologists Research on animals

1) Research an ethical issue in your intended career field. Argue for what members of the profession should do related to this issue. (For instance, an ethical issue in English college teaching is how to deal with literary works that are significant in the field but which might be offensive

500 words minimum for each and 2 references for each

 500 words minimum for each and 2 references for each 1. You discover tire tracks and footwear impressions at a crime scene. What method is used to document and collect the impressions? What class and individual characteristics are found in tire and footwear impressions? 2. What are some of the

SWOT Analysis and Competitor Analysis

Part 1: For this assignment you will be conducting a SWOT analysis on Monster Beverage Corporation. This SWOT analysis should be related to the sustainable initiative of using recycled, unmodified materials to make the company’s products. What are the strengths of this new initiative? What are the weaknesses? What opportunities