Please click on the link above to submit this week’s assignment.

Answer the following questions using the information provided.

Question 1: We have received a set of comments over time on the web. Check if we have improved? Please note that there are no pre- and post-intervention periods and therefore control limits must be calculated from the entire period. You can find the data here

• You can find the solution here .

Question 2: The following data show the speed with which Alabama Medical Center’s Emergency Room provides a patient who has fractured long bone with pain medication. Examine if the organization has been able to reduce the response time to less than 73 minutes? You can find the data here

• Please use the following peer video as a reference for this question. You can find the solution here .
• Peer video question 2 https://www.youtube.com/watch?v=uq49WOuZwEU&feature=youtu.be

Question 3: In Hospital Administration Programs, time to adverse events is typically taught in courses on quality. It also may be referred to in courses on strategy, if the hospital is focused on competing based on quality. Hospital Compare reports the measure OP_21. The Score field provides time (in minutes) from emergency department arrival to initial oral, intranasal or parenteral pain medication administration for the patients with a diagnosis of a long bone fracture. The field Sample provides the number of patients used to calculate the time to pain medication. In this assignment, we ask you to track the performance of “Inova Fairfax Medical Center” over two years. Focus on the Score variable.

Download Hospital Compare data; these years include data from 2013 to 2015. Merge the file ” HQI_HOSP_TimelyEffectiveCare” across all the databases that you have downloaded. Select measure ID: “OP_21”. Construct a control chart showing time between pain medications. The data are reported for a range of time; assume that the data are reported for the midpoint of the range. Download data using the following files, additionally include other data (directly from Hospital Compare) for files after 2016:

2016-11-10

2016-08-10
2016-05-04
2015-12-10
2015-10-08
2015-07-16
2015-05-06
2015-04-16
2015-01-22

Construct both a Tukey and a time-between control chart for the data. For the time-between control chart assume that data points above median exceed and observations below median are less than the national average.

• You can find the solution here .

Question 4: Analyze the following data using Tukey and Time-In-Between (more than 30 minutes of exercise considered a successful day) charts. Produce 3 charts and discuss if the findings from the 3 charts are similar. To decide if the exercise time has changed, rely on the control chart with the smallest difference between upper and control limit. Download the data here

• You can find the solution here .

Instructions

In order to complete this assignment you must submit an Excel file with each question answered in a separate sheet. Copy both the question prompts and your answers to the file. All calculations should be done by formulas and not as fixed values.