Appropriate Control Chart

#1
Dear experts,

I have been trying to create a control chart in excel but I am not certain if I have chosen the correct control chart. Can someone review my working out and advise if I am doing things correctly?

My data looks at harm caused from an incident to patients during their occupied bed days. I have decided to go for a u chart on the basis that the occupied bed days can vary significantly and the incidents could happen multiple times to a single patient.

I have attempted to plot this out in excel however I am confused as to the numbers I am getting for the u bar, UCL and LCL. They are all small numbers 0.01 etc. Can anyone explain why there are small numbers? Also is it possible to show the data per 1000 occupied bed days?

I have attached the excel spread sheet if anyone would like to view it.

Your help/guidance is much appreciated!

Saif
 

Attachments

Elsmar Forum Sponsor

Miner

Forum Moderator
Staff member
Admin
#2
The u chart is appropriate to your scenario. Your UCL and ubar appear to be correct, but the LCL should be zero. LCLs of u charts cannot be negative.

The reason the numbers are small is because the chart is not plotting the number of incidences, but the number of incidences divided by the opportunities (beds).
 
#3
Many thanks for the clarification Miner

If I wanted to see it displayed as per 1000 occupied bed days, is that possible? I have attempted to multiply the defects / unit by 1000 but then then graphs UCL LCL and u bar stopped working. Will I need to calculate them separately and then use those figures in the u charts as opposed to what's currently in them?

Regards,

Saif
 

Miner

Forum Moderator
Staff member
Admin
#4
You would have to create the chart using the raw data then add a multiplier on you r scale to show defects per 1000.
 
#5
That's the part I am struggling on. Every time I try to add a multiplier the control limits don't work anymore, as in they become very small/close together. and the graph becomes huge. Any advice would be great
 
Last edited:
Thread starter Similar threads Forum Replies Date
P Attribute Control Chart in my Process - Black Belt says Not Appropriate Quality Tools, Improvement and Analysis 11
D What would be the appropriate control chart for the attached data? Statistical Analysis Tools, Techniques and SPC 5
C What Particular Control Chart is Appropriate for Flour (food) Production? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 5
S When is ISO 13485:2016 6.4.2 Contamination Control appropriate? ISO 13485:2016 - Medical Device Quality Management Systems 11
N Which is more appropriate Regular or Short Run control charting? Statistical Analysis Tools, Techniques and SPC 8
R Outsourcing Processes - What is appropriate control over the outsourced operations? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 4
J On-the-floor work instructions - Appropriate control of Document Control Systems, Procedures, Forms and Templates 1
A ISO 13485 - Clause 8.3.3 appropriate actions in response to nonconforming product ISO 13485:2016 - Medical Device Quality Management Systems 2
E What are appropriate deviations for a LHR/DHR? (Medical Device Company) Manufacturing and Related Processes 3
C ICP versus AA: How to determine appropriate specification for assay method verification Qualification and Validation (including 21 CFR Part 11) 1
K Please help identify appropriate statistical treatment Statistical Analysis Tools, Techniques and SPC 13
A Electric terminal crimping machines - Is SPC appropriate for this process? Manufacturing and Related Processes 4
Le Chiffre Is ISO/IEC 27001 appropriate for most small businesses? IEC 27001 - Information Security Management Systems (ISMS) 2
W EU GMP Annex XI - What is an "appropriate QMS"? Other Medical Device Related Standards 2
N Taking exception to REACH Requirement - Appropriate Language REACH and RoHS Conversations 4
Q When does the FDA deem something "where appropriate"? 21CFR820.30(g) 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 11
Y "As appropriate" in ISO 13485:2016 ISO 13485:2016 - Medical Device Quality Management Systems 20
S What is appropriate PPM level for a Plastic Injection Moulding Supplier Quality Tools, Improvement and Analysis 4
D What is the appropriate way to write a conclusion from a % contribution result? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 4
R Why customer satisfaction is not appropriate regulatory objective in medical device? ISO 13485:2016 - Medical Device Quality Management Systems 8
C What is the most appropriate Bioburden Test Method for Surgical Gloves ISO 13485:2016 - Medical Device Quality Management Systems 10
Q Writing appropriate ISO 13485 Audit Report Findings Internal Auditing 15
J Lean Appropriate KPIs for a Distribution Centre Lean in Manufacturing and Service Industries 1
I Is ARIMA (Time Series Analysis) Model appropriate for this Dental Research? Using Minitab Software 4
L Most appropriate Auditor to check the FMEA & PCP of a Manufacturing Process IATF 16949 - Automotive Quality Systems Standard 5
J Appropriate In-Process Monitoring Frequency for 2X per day Change Set-Up. Statistical Analysis Tools, Techniques and SPC 3
C Appropriate ways to address Competency? Generic vs Specific ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 2
M Appropriate use of the REF symbol in IVD kits and kit components Other Medical Device Related Standards 2
somashekar What is D&D Output for appropriate information for Production? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 1
M 8.2.4.2 Appearance Items - When Masters for Colour, Grain, etc are not appropriate? IATF 16949 - Automotive Quality Systems Standard 6
D General Guideline for an appropriate Sample Size for measuring Cp and Cpk Capability, Accuracy and Stability - Processes, Machines, etc. 11
D Appropriate Statistical Methods to set up an Alert/Warning Limit Quality Assurance and Compliance Software Tools and Solutions 15
B What is the Appropriate Sample Size for a Customer Survey? Customer Complaints 5
J The appropriate Attribute MSA for Automatic Visual Inspection Machine Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
J Appropriate Test Environments for In-Glass Liquid Thermometer Calibrations General Measurement Device and Calibration Topics 2
R How to select appropriate standards for Multi-Functional Physical Therapy Equipment IEC 60601 - Medical Electrical Equipment Safety Standards Series 4
T Appropriate Lean Six Sigma Green Belt Project Proposal? Six Sigma 10
I ASQ CQT Exam - Appropriate study time and best resources recommendations Professional Certifications and Degrees 8
T Determining the appropriate Sample Size using an AQL Table Inspection, Prints (Drawings), Testing, Sampling and Related Topics 29
B Appropriate Standards for Food Packaging Adhesive Manufacture Food Safety - ISO 22000, HACCP (21 CFR 120) 7
O Can anyone recommend appropriate standard for Reliability Testing of Cables Other Medical Device Related Standards 3
C What is the most appropriate MSA (Measurement System Analysis) Study Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 4
C What is the appropriate DPPM for to be used In-Process Inspection Other Medical Device Related Standards 2
S Pp/Ppk & Cp/Cpk - Which is appropriate for Long/Short Term Study? Statistical Analysis Tools, Techniques and SPC 20
J Ethics Training and Policy appropriate for an ISO 17025 Testing Laboratory ISO 17025 related Discussions 4
K Recommendations for an appropriate Recorder used at low temperature (Below 500?F) AS9100, IAQG 9100, Nadcap and related Aerospace Standards and Requirements 3
M z Test vs. F Test - The most appropriate for comparing the Variances Statistical Analysis Tools, Techniques and SPC 3
B Appropriate ISO Clauses reference in Procedure Manual ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 9
C Starting an MSA study - How to decide which is appropriate or required Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
somashekar Hazardous Waste: Is this an appropriate interpretation Miscellaneous Environmental Standards and EMS Related Discussions 1
Similar threads


















































Top Bottom