QUANTITATIVE MATH FOR HLTH SRV MAT543002VA016-1226-001WEEK 8UPLOAD ASSIGNMENT: WEEK 8

 QUANTITATIVE MATH FOR HLTH SRV MAT543002VA016-1226-001WEEK 8UPLOAD ASSIGNMENT: WEEK 8 ACTIVITY – TQM CHARTING PRACTICE

Quantitative Math for Hlth Srv (MAT543002VA016-1226-001)

Getting Started

Course Info

My Professor

Announcements

XanEdu

Gradebook

zyBooks

Strayer Writing Standards

Your Course

Week 1

Week 2

Week 3

Week 4

Week 5

Week 6

Week 7

Week 8

Week 9

Week 10

Week 11

Help/Resources

Media Gallery

Course Tool Help

Email

   ASSIGNMENT INFORMATION

Due Date

Monday, August 29, 2022

9:00 AM

Points Possible

30

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:

Create a scatter plot in Excel of the number of late surgeries versus the overall number of surgeries.

Create a run chart in Excel for the number of late surgeries and a run chart for the overall number of surgeries for 2019.

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.

In a Word document, draw two conclusions regarding these three analyses regarding the late surgeries at Forest Medical Center.

Late Surgeries versus Overall Surgeries

Month Number of Surgeries Number of Late Surgeries

January 435 112

February 401 129

March 572 186

April 409 103

May 577 89

June 329 156

July 467 156

August 301 94

September 235 89

October 325 127

November 378 156

December 444 124

Total 4873 1432

Problem 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.

Use Excel to create a run chart for the data.

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.

In a Word document, draw two conclusions from these charts regarding the influenza cases that the Forest Medical Center had treated.

Submit Word document(s) and Excel file(s) showing your responses and calculations.

Influenza Data by Quarter

Year Quarter # of Cases of Influenza Observed

1 1 3452

1 2 346

1 3 483

1 4 3984

2 1 4120

2 2 376

2 3 429

2 4 3583

3 1 4219

3 2 385

3 3 392

3 4 3614

4 1 3568

4 2 439

4 3 326

4 4 4103

5 1 4209

5 2 396

5 3 411

5 4 4008

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

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

Related Questions

1. Review the Profile of a Graduate Download Profile of

 1. Review the Profile of a Graduate Download Profile of a Graduatedocument. 2. Choose two characteristics to focus your research on. 3. Download the Research Log form to use as you begin your research. 4. Using library resources and research techniques and complete rows on page 1/Week 6 of the

QEP Assignment 2: Death Penalty

Answer the following: Do you support or oppose the death penalty? Why or why not? Please use academic sources to support your position. Requirements: o Your paper must be at least 1000 words. o Please double space your paper and use Times New Roman 12 point font. o Make sure

The assignment for individual reading #4 is as follows and

The assignment for individual reading #4 is as follows and in keeping with the Syllabus, class discussions, instructions and the Rubric (attached): Each student will research and select a relevant paper on the subject matter of ‘sustainability’ as it applies to  some industry or business The source of finding such

For this assignment, you will revisit the Ethos Statement you

  For this assignment, you will revisit the Ethos Statement you wrote in Lesson 1.  As you did then, you will write two paragraphs for this assignment. In the first paragraph, revisit the first paragraph of your initial Ethos statement.  Address the following in this paragraph: Have you upheld your

issues of the Articles of Confederation and describe the main

  issues of the Articles of Confederation and describe the main problems that the United States was faced with under the Federation government. Analyze two major debates by which the Constitution was created in the summer of 1787   Discuss the ratification process of the Constitution of 1787. How did

Coursework Overview Literature review: The purpose of this assessment is

 Coursework Overview  Literature review: The purpose of this assessment is to for students to engage with peer-reviewed  quality academic literature in order to produce an argument critically analysing collaborative working and  the design management process on BIM enabled projects.  3.3 Coursework Tasks to be Completed by Students  The submission should

As we finish NR351, think about all the competencies you

As we finish NR351, think about all the competencies you have explored in these eight weeks. Using reflective practice, address the following in your answer: Select two Massachusetts Nurse of the Future Nursing Core Competencies that you believe will have the most impact on your future professional nursing practice. Why

You are reading Augustine, Anselm, Aquinas, et al. this week.

You are reading Augustine, Anselm, Aquinas, et al. this week. There is no bigger journey outside of ourselves than the search for something to believe in. Do some inward contemplation and questioning of what you believe (I won’t tell your grandma!). The purpose of this discussion is to share and not

You are preparing for an interview in which you will

You are preparing for an interview in which you will have the responsibility for managing projects for an organization.  To help you prepare, the organization provides you with serval questions, one of which is, “summarize a current event and then explain and evaluate the event in terms of two concepts

This is a Collaborative Learning Community (CLC) assignment. Because this

This is a Collaborative Learning Community (CLC) assignment. Because this is a group project, I only need questions 2 & 3 in 4 slides  Chose a processed product (lithium-ion batteries) and create a 15-slide PowerPoint to answer the following questions: PLEASE NOTE THE PRODUCT CHOSEN IS – “lithium-ion batteries” 1.

Legacies of Colonialism

 This essay has to be base on the book of “Americas: The Changing Face of Latin America and the Caribbean, University of California Press; 3rd Edition”. and at the end of the essay I need to answer this 3 question. The essay has to be Two pages and then the

For this week’s written assignment you are a manager at,

  For this week’s written assignment you are a manager at, Ad It Up, a mid-size marketing firm. Over the last five years you notice that issues relating to unethical practices seem to be on the rise. From minor issues, such as employees calling in sick when they should have

Respond to at least two other student posts Cory :

 Respond to at least two other student posts  Cory :  The topic I have chosen is a quote from Bali Padda chief operating officer of the LEGO Group, who said, “Strategy is only as good as the execution behind it.” I think formulation and execution are related I also think

Data Management Plan The data management plan is a vitally

Data Management Plan             The data management plan is a vitally important component of the DNP project implementation and allows for the dissemination of accurate project outcomes. The DNP student consulted a statistician for the following practice question that will serve as the basis for the proposed “For adolescents diagnosed

Develop the skills and approach that you employed in the Document Analysis

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.

Adolescence is a time of trials and tribulations. Teens are

Adolescence is a time of trials and tribulations. Teens are dealing with the formation of self and identifying who they are in the world. They are also experiencing biological changes that create mood swings and at times emotional outbursts. Interventions for this group can be challenging, as adolescents often avoid

Debate Analysis Annotated Bibliography

Annotated Bibliography Structure: Visual Organizer (first page) Rhetorical Précis Paragraph (about 4-5 sentences MAXIMUM): The Who (Where, When, What): State the title of the article and the author’s full name and title. (Who is this person? What is their field? What is the article about?) The How: Paraphrase the author’s