Question

In: Statistics and Probability

Using Excel, calculate the median delay time per week and construct a run chart using the...

Using Excel, calculate the median delay time per week and construct a run chart using the data below. Compare the delay times per week to the median. Display your chart. Question: Does this process show common or special cause variation? Is this something that the medical director should be concerned with? Would it be productive to investigate and eliminate the cause (whether it is common or special)? Why or why not?

Week

Average Delay Time (in days)

1

34

2

30

3

35

4

32

5

28

6

26

7

29

8

28

9

35

10

26

11

34

12

31

13

28

14

40

15

26

16

32

17

31

18

30

19

33

20

35

Solutions

Expert Solution

By using excel, median of the delay time is 31. (MEDIAN is the function used to calculate median)

Run chart -

Now, we have to count number of runs. run is a sequence of consecutive points which all on the same side of the median line. A run can be a single point if both the previous & subsequent points are on the opposite side of the median line. Ignore points that lie exactly on the line.

If the number of runs are more or fewer than expected indicates that there is special cause(assignable cause) in the process otherwise common cause (Non-assignable cause or random effects).

Table provided below for the expected number of runs -

We have total 20 data points, so the number of runs should between 6 & 15.

To find out runs, we will take 1 for score above median & 0 for score below median.

So, run becomes -

101100001010101011

So, there are 13 number of runs.

So, Runs is between 6 & 15, hence there is commom cause variation.

There are common cause variation in delay time which can be reduced by process improvement activities but not eliminated. So, medical director should be concerned with common causes such as poor design, measurement error, quality control error, poor working conditions e.g. lighting, noise, dirt, temperature.

Common causes are constantly active within the system & random error in system. It is not easy to identify cammon causes as they are natural & random. So, one may be able to identify the cause & can reduce it by process improvement activities. But, common causes can't be elimnated from the process. So, in case of common cause, it may or may not be productive to investigate & improve the process.


Related Solutions

The following program is to have a time delay. Calculate and tell how much the time...
The following program is to have a time delay. Calculate and tell how much the time delay is. The CPU frequency is 24-MHZ.      org $1000 ; starting address of the program      ldx #80000     ; 2 E cycles loop psha             ; 2 E cycles      pula       ; 3 E cycles      psha       ;      pula       ;      psha       ;      pula       ;      psha       ;      pula       ;      psha       ;      pula       ;      psha       ;     ...
The median rental for a three bedroom bungalow is 2400 per week. A random sample or...
The median rental for a three bedroom bungalow is 2400 per week. A random sample or 300 units showed 10 for exactly 2400 per week and 170 rented for more than 2400. Can we conclude that the median rental is more than 2400 (at a 0.05 level) a. State Ho and H1 b. Give a decision rule c. Arrive at a decision
The median rental for a three bedroom bungalow is 2400 per week. A random sample or...
The median rental for a three bedroom bungalow is 2400 per week. A random sample or 300 units showed 10 for exactly 2400 per week and 170 rented for more than 2400.   Can we conclude that the median rental is more than 2400 (at a 0.05 level) State Ho and H1 Give a decision rule Arrive at a decision
The median rental for a three bedroom bungalow is 2400 per week. A random sample or...
The median rental for a three bedroom bungalow is 2400 per week. A random sample or 300 units showed 10 for exactly 2400 per week and 170 rented for more than 2400.   Can we conclude that the median rental is more than 2400 (at a 0.05 level) State Ho and H1 Give a decision rule Arrive at a decision
the median rental for a three bedroom bungalow is 2400 per week. A random sample or...
the median rental for a three bedroom bungalow is 2400 per week. A random sample or 300 units showed 10 for exactly 2400 per week and 170 rented for more than 2400.   Can we conclude that the median rental is more than 2400 (at a 0.05 level) State Ho and H1 Give a decision rule Arrive at a decision
The median rental for a three bedroom bungalow is 2400 per week. A random sample or...
The median rental for a three bedroom bungalow is 2400 per week. A random sample or 300 units showed 10 for exactly 2400 per week and 170 rented for more than 2400.   Can we conclude that the median rental is more than 2400 (at a 0.05 level) State Ho and H1 Give a decision rule Arrive at a decision
Need to know the Excel tasks needed to calculate the mean, median, mode, range and standard...
Need to know the Excel tasks needed to calculate the mean, median, mode, range and standard deviation for 5 years of daily adjusted stock price data downloaded and opened in Excel. How to produce a histogram for the adjusted daily closing price? Produce a time plot (scatter plot) of closing data versus stock plot.
Calculate the weekly return for BIT and construct a histogram in Excel. Does the data on...
Calculate the weekly return for BIT and construct a histogram in Excel. Does the data on return rates appear normally distributed? On the basis of z-scores do you find evidence of outliers? Hint: the formula for a return is (Current Price – Previous price)/Previous price multiplied by 100. Date Weekly Return BIT 11/3/13 -46.16 18/3/13 -0.01 25/3/13 39.23 1/4/13 13.07 8/4/13 23.93 15/4/13 41.36 22/4/13 26.5 29/4/13 20.39 6/5/13 25.5 13/5/13 42.52 20/5/13 37.88001 27/5/13 15.66 3/6/13 20.98 10/6/13 25.28...
Calculate the weekly return for BIT and construct a histogram in Excel. Does the data on...
Calculate the weekly return for BIT and construct a histogram in Excel. Does the data on return rates appear normally distributed? On the basis of z-scores do you find evidence of outliers? Hint: the formula for a return is (Current Price – Previous price)/Previous price multiplied by 100. Date BIT 11/3/13 52.06 18/3/13 53.84 25/3/13 99.99 1/4/13 139.23 8/4/13 113.07 15/4/13 123.93 22/4/13 141.36 29/4/13 126.5 6/5/13 120.39 13/5/13 125.5 20/5/13 142.52 27/5/13 137.88 3/6/13 115.66 10/6/13 120.98 17/6/13 125.28...
Q1) Construct IPO chart that calculate grade of someone. Working backwards by beginning with deciding the...
Q1) Construct IPO chart that calculate grade of someone. Working backwards by beginning with deciding the output should the grade be.  
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT