The Speedway Clinical Laboratory
Problem 6-7: Speedway Clinical Laboratory
The Speedway Clinical Laboratory is a scientific blood-testing facility that receives samples from local hospitals and clinics. The blood samples are passed through several automated tests, and the results are printed through a central computer that reads and stores the information about each sample that is tested.
Management is concerned about the quality of the service it provides and wants to establish quality-control limits as a measure for the quality of its tests. Such managerial practice is viewed as significant, because incorrect analysis of a sample can lead to a wrong diagnosis by the physician, which in turn might cost the life of a patient. For this reason, 100 blood samples were collected at random each day after they had gone through testing. After retesting was performed manually on this sample, the results were:
Day | Incorrect Analysis | Day | Incorrect Analysis |
1 | 8 | 11 | 4 |
2 | 3 | 12 | 6 |
3 | 1 | 13 | 5 |
4 | 0 | 14 | 10 |
5 | 4 | 15 | 2 |
6 | 2 | 16 | 1 |
7 | 9 | 17 | 0 |
8 | 6 | 18 | 6 |
9 | 3 | 19 | 3 |
10 | 1 | 20 | 2 |
Copy and paste the data from the table above into Excel. Do the calculations in Excel and develop the p chart with the LCL and UCL. Copy and paste the spreadsheet calculations and the p chart below.