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

HCAD AMU Covid Case Study Analysis Nursing Assignment Help

Instructions At the onset of the COVID-19 pandemic, many healthcare organizations were unprepared for the chaos that would soon follow. For this assignment, read through the attached case study and provide an analysis of what you have read. Your analysis should include the following sections:  1) Introduction 2) Background 3)

The Transmission Control Protocol and Internet Protocol Layers refers to

  The  Transmission Control Protocol and Internet Protocol Layers refers to the  communication protocols that enable use to do anything over the  internet. There are four layers. In the Network Interface Layer things  like sending information between hosts on the same local network and  translating data from higher layers are

For this assignment, you should use the information found on

For this assignment, you should use the  information found on the official government website: www.bea.gov/index.htm Based on the information contained on the Web site above, answer the following questions: What does gross domestic product (GDP) tell us? How did GDP change from 2008? What caused these changes? What is real

Object-oriented programming has been adopted widely because of its capability

Object-oriented programming has been adopted widely because of its capability to reuse code. Most application development software provides class libraries and extensive support for complex data structures, including linked lists.  Investigate one of these libraries, such as the Microsoft Foundation Class (www.microsoft.com) or the Java 2 Platform (http://www .java.com) application

Evidence collection mistakes

 Using Word Documents and proper in text citations answer the following question and explain answer. Criminalist Pete Everett Is collecting fiber evidence from a murder scene. He notices fibers on the victim’s shirt and trousers, so he places both of these items of clothing in a plastic bag. He also

What does diversity mean? What can Google leadership learn from

What does diversity mean? What can Google leadership learn from their leaked memo on anti-diversity? Which elements should be in place for people to feel included and appreciated at work? From your reading which barriers prevent people from open to differences in others? What was your key learning from this

After completing the readings, videos, and the Guide on Developing

  After completing the readings, videos, and the Guide on Developing HRM Plan, you should have an understanding of the multifaceted processes behind the development and maintenance of quality healthcare environments. In this assignment, you will formulate a strategic approach to human resource management in response to an organization in trouble.

This assignment requires students to write a Research Problem statement

This assignment requires students to write a Research Problem statement on their approved research topic. This will be informed by their evaluation of previous research that was started in Unit 2 with the Annotated Bibliography Assignment.  See the attached assignment sheet for details. (The assignment must be double spaced, in

In what ways does looking through the history lens enhance

In what ways does looking through the history lens enhance your understanding of popular culture? Consider a current event in the news that portrays a historical element. How does looking through the history lens influence how you perceive both the current and historical cultures referenced? Please share a news link

Historical Conversations Project

Description This is a list of required elements of the 1700-word (6-7 pages of text) HCP essay: Clear argument identifying a significant and precisely defined contemporary cultural, political, and/or social problem related to the themes of our core text. Vivid description and analysis of TWO artifacts (court cases, historical documents,

Hello. Please I need to do a PowerPoint project. Should

Hello. Please I need to do a PowerPoint project. Should be no less than 20 slides without counting the presentation and references, with illustrations and with the specifications required by the institution. It should be on Thursday. Topic: Pigmentary Disorders, Disorders of hair and nails, Emergency Dermatology Be emphatic on

At some point in every construction project, efforts turn from design

At some point in every construction project, efforts turn from design and the focus moves to actual construction. With the vision in place and the tools secured, the blueprint can be finalized and approved. Then it is time to put on hardhats and begin work. Throughout the course you have

Instructions Remember to be clear about what action you are

  Instructions Remember to be clear about what action you are recommending. Executive management will want to understand not only what you discovered, but also what you propose as a solution. The company’s leaders will want to know what decisions they need to make based on your findings. Give them

PART 3: PERFORMANCE ANALYSIS (Entertainment and Gaming Software)

Description: Four companies that we will look into are Ubisoft, Activision/Blizzard, EA, and Square Enix, which are in the top ten highest grossing gaming developers that focus mainly on game development. The top markets for developing video games is China, Japan, and the U.S. The competitive landscape is movies, shows,

Think about the following questions and complete a SWOT analysis.

  Think about the following questions and complete a SWOT analysis. Use the information in 3.2 – Sally’s Case Study. (Any direct information not available can be completed using fictitious information consistent with the case study.) As you complete the SWOT analysis think about: What are your strengths and weaknesses?

Create a two-page digital newsletter for families that highlights how

Create a two-page digital newsletter for families that highlights how special education   assessments and their results help with planning special education services within the classroom. Within your newsletter, include the following:   Identify and describe one current technology-based special education assessment tool that can be used to evaluate students’ needs. Outline