Problem One Dr. Raymond Hill, Director of Surgery, for Forest

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.

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.

  1. Use Excel to create a run chart for the data.
  2. 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.
  3. 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.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

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

Related Questions

Compare common LAN network cables and connectors. Describe the pros

Compare common LAN network cables and connectors. Describe the pros and cons of each as well as their likely applications. Describe two commonly used native Linux troubleshooting commands. For example, the “ls” command can be used by itself or with additional options such as “ls -I” that will list directories

Instructions Read the scenario below and answer the following questions.

Instructions Read the scenario below and answer the following questions. You work as a financial analyst at a large automobile corporation that occasionally makes acquisitions of smaller companies that specialize in the production and assembly of small component parts. In order to achieve vertical integration of its newest sports sedan

PLEASE UPLOAD EACH DISCUSSION SEPARATELY!!!!! NUMBER 1 Question A What

PLEASE UPLOAD EACH DISCUSSION SEPARATELY!!!!!  NUMBER 1 Question A What are the common elements of the TCP three-way handshake to begin communication? What are the additional elements that can be sent when the handshake fails? Question B What are the differences between centralized and distributed network routing? Which method is

In order to have a successful IG (Information Governance) program,

In order to have a successful IG (Information Governance) program, one of the eight (8) Information Risk Planning and Management step is to develop metrics and measure results. From your required readings, discuss the value that metrics brings to the organization, and identify critical measures of success that should be

The Final Word” Give a brief summary evaluation of your

  The Final Word” Give a brief summary evaluation of your community’s health, the major strengths of your community, and the hopes for your community in the future.  Also, discuss what has resonated with you in this course. Submission Instructions: Your initial post should be at least 500 words, formatted and

How could you use milestones and/or Earned Value Management as

How could you use milestones and/or Earned Value Management as a measure of success in a project? What limitation does just offering milestones provide as a means of project reporting? Define some best practices with monitoring project quality. Choose at least one quality tool and explain how it may be

500 WORDS You are expected to submit a summary of

 500 WORDS You are expected to submit a summary of a current climate / environmental-related article from the mainstream press, along with your personal evaluation/reflection. Using a recent news article from a reliable source, please feel encouraged to explore topics that include extreme weather (e.g. winter storms, drought), climate change, energy

Using the Internet or Strayer Library, research the articles about

  Using the Internet or Strayer Library, research the articles about Fraud Prevention and Detection Technology. Evaluate the various tools / techniques available to auditors to prevent or detect fraud. Based on your analysis, propose the most effective audit tools / techniques that would have prevented or detected the fraud. Support your

Chapter 9 Exercise. There continues to be a disparity between

  Chapter 9 Exercise. There continues to be a disparity between the advertising dollars spent on reaching TV viewers and Internet users versus the amount of time that is spent interacting with each medium. A large degree of Google’s success is attributable to taking advantage of this large gap. Research

Instructions For this assignment you will: find a law review

Instructions For this assignment you will: find a law review article in the library concerning ethics, privacy law, and cybersecurity; use the IRAC method (Issue, Rule, Analysis and Conclusion) to analyze your selected law review article, especially with regard to how the public may be adversely affected by your topic.

Creating organizational mission, vision, and culture statements is a highly

  Creating organizational mission, vision, and culture statements is a highly collaborative activity. Stakeholders from various teams and departments bring their expertise and perspectives to help create organizational elements that reflect the collective experiences, knowledge, and values across an organization. This results in a final product that reflects diverse experiences

As a consultant or researcher, you might be hired to

As a consultant or researcher, you might be hired to conduct a literature review to inform the court or other legal personnel about a topic that is relevant to a legal case. This literature review might include the following features: An historical summary of case law, legislation, and policies pertaining

You are assigned to a walking beat downtown, and every

 You are assigned to a walking beat downtown, and every morning you stop into a breakfast shop and have a cup of coffee only. The owner does not charge you. After some citizen complaints about the parking situation in the area, the station has directed you to ticket all illegally

Case Study Questions: In 1918 almost 675,000 people in the

Case Study Questions:  In 1918 almost 675,000 people in the US died from that flu, as of this writing the US has 485,000 deaths from Covid-19. Considering that before this pandemic has past the United States will have lost at least 500,00 people to this virus, even with the advancement