Using this information below you will create a graphic demon
Using this information below, you will create a graphic demonstration of the data, summarize any conclusions that can be made, and propose a list of additional data needed to find improvement opportunities. Be sure to address all three tasks that are listed below for W4A1.
The following information was extracted from the floor secretary logs from the past week:
A total of 3622 tests were done and 589 were over the standards for turnaround time
The breakdown by urgency is as follows:
Of 459 STATs, 77 were over standard
Of 1042 Urgents, 334 were over standard
Of 2121 Routines, 178 were over standard
NOTE: You might create an Excel table that looks something like this in order to make a chart that will be valuable:
Performance Data
URGENT
ROUTINE
STAT
TOTAL
Number > Standard
334
178
77
589
% of Total > Standard
57%
30%
13%
100%
Cumulative % of Total
57%
87%
100%
Arrange this performance data on turnaround times in a graphic format (create a graph).
Summarize what conclusions can be drawn from the data. Is there enough information to establish a baseline? Do you have enough data to determine any causes and effects?
Formulate a list of additional data that you would need to collect to analyze this situation. Create a plan using the “Check Sheet 4 W” questions from Chapter 4 to generate a list of data that would help your team to analyze this situation.
| URGENT | ROUTINE | STAT | TOTAL | |
| Number > Standard | 334 | 178 | 77 | 589 |
| % of Total > Standard | 57% | 30% | 13% | 100% |
| Cumulative % of Total | 57% | 87% | 100% |
Solution

