# P-Chart Control Limit Calculation help

#### leaning

##### Involved In Discussions
How do you perform this P-chart calculation:
Here's the equation given:
P'+-3(sqrt (P'(100-P')/N)) where P' is historical value of percent defective and N is number of pieces inspected each week.

After 6 weeks, P'=12, Week 1-6 data is 11, 11, 14, 15, 10, 12. And 600 pieces were inspected each week.

I'm using :=B3+3*(SQRT((B3*(100-B3))/B4))
B3=P'=12
N=3600 (600 per week * 6 weeks)
UCL = 13.6
LCL = 10.4

With the right calculations, all of the values should fall within the control limits, but they aren't for me, so I'm doing something wrong.

(This is from the August 1978 Quality Progress, p. 22, Applications, #3.)

Regards,
leaning

#### Miner

##### Forum Moderator
Staff member

J What Control Chart should be used for Microbial Limit (NMT 100 cfu/m3) Statistical Analysis Tools, Techniques and SPC 12
J Xbar - R Control Chart taking into account the Probability Limit Using Minitab Software 8
2 What type of Control Chart? USL of 3 and a lower spec limit of 1 Statistical Analysis Tools, Techniques and SPC 1
Changing LCL (Lower Control Limit) on a Minitab Control Chart Using Minitab Software 13
A Point Outside of Control Limit for R Chart - This is not SPC...It's GR&R study Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
S Control chart limit calculation confusion concerning SPC control limit calculation Statistical Analysis Tools, Techniques and SPC 27
K Control limit - How is table for x-bar & R control chart derived? Statistical Analysis Tools, Techniques and SPC 7
Fabric roll inspection - What type of Control Chart to use? Inspection, Prints (Drawings), Testing, Sampling and Related Topics 2
Putting back excluded rows/data points in a control chart Using Minitab Software 0
Control chart and sample time Statistical Analysis Tools, Techniques and SPC 1
Control chart for huge sample size Statistical Analysis Tools, Techniques and SPC 9
What is "setup control chart"? Statistical Analysis Tools, Techniques and SPC 2
Redesigning our process flow chart, PFMEA and Control Plan Process Maps, Process Mapping and Turtle Diagrams 4
D Control chart applicable? Percentage of compliance with a standard Statistical Analysis Tools, Techniques and SPC 2
Link between FMEA, flow chart and control plan FMEA and Control Plans 10
How to do a control chart - Machining product that requires flatness control Capability, Accuracy and Stability - Processes, Machines, etc. 1
Understanding control chart and measurement capability Statistical Analysis Tools, Techniques and SPC 2
F Appropriate Control Chart Statistical Analysis Tools, Techniques and SPC 5
S used excel formula calculated the ARL's with Rule1&Rule2 for Shewhart control chart Statistical Analysis Tools, Techniques and SPC 0
How to define Root Cause when some points are out of control chart Statistical Analysis Tools, Techniques and SPC 6
The ARL for an X bar Control Chart (n = 5) Statistical Analysis Tools, Techniques and SPC 5
A Complete Control Chart Decision Tree Statistical Analysis Tools, Techniques and SPC 5
Variation Study on Mined Material - What do you call it (not a control chart) Statistical Analysis Tools, Techniques and SPC 7
G I-Chart and X bar Chart Control limits Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
S Regression Control Chart - Process Capability Statistical Analysis Tools, Techniques and SPC 18
J Control Chart Pattern Detection Statistical Analysis Tools, Techniques and SPC 3
R Control Chart Constants and Confidence Interval Statistical Analysis Tools, Techniques and SPC 7
P Specification and Tolerance in Stability Control Chart Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 9
What is an "X-Rs" Control Chart? Statistical Analysis Tools, Techniques and SPC 4
I What is an Ideal Control Chart for Hospital Surgery Infections? FMEA and Control Plans 2
M Shewhart Control Chart for SPC In Excel - Explain the yellow and red marked column Statistical Analysis Tools, Techniques and SPC 2
K Advice on Calculating Control Chart Control Limits Statistical Analysis Tools, Techniques and SPC 13
J Statistical Significance and SPC Control Chart Reports Statistical Analysis Tools, Techniques and SPC 9
P SPC Data Collection and Control Chart Type question Statistical Analysis Tools, Techniques and SPC 4
R XBar & R Chart Spreadsheet to apply a Control Process Statistical Analysis Tools, Techniques and SPC 1
Control Chart for Non-Manufacturing Process Indicators - Is it worth? Statistical Analysis Tools, Techniques and SPC 1
O Is it an Assignable Cause only if the Control Chart says so? Statistical Analysis Tools, Techniques and SPC 16
C Control Chart Roadmap Template Document Control Systems, Procedures, Forms and Templates 0
Shewhart Control Chart - ISO/TS 13530:2009(E), Page 22. General Measurement Device and Calibration Topics 3
MSA (Measurement System Analysis) - Do we have control of all states in the chart? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 5
H Control Chart applications in Cement Industries Statistical Analysis Tools, Techniques and SPC 2
T Implementing SPC - Control Chart for Individual Measurements Statistical Analysis Tools, Techniques and SPC 9
"Control" as used in 4.1 c) - Process Flow Charts (Process Sequence Chart) ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 12
I Control Chart for Mortality Rate on Broiler Farms Statistical Analysis Tools, Techniques and SPC 4
G Control Chart Selection for Crimping Operations for RJ 45 Plugs Statistical Analysis Tools, Techniques and SPC 5
K When to create a new Control Chart? Quick question Statistical Analysis Tools, Techniques and SPC 4
T Control Chart - Salt Spray Test Hours - Powder Coated Parts Statistical Analysis Tools, Techniques and SPC 3
S Calculation of Upper and Lower Control Limits for Control Chart? Statistical Analysis Tools, Techniques and SPC 7
Control Chart Metrics/KPI - Measuring Effectiveness of Control Charting System Statistical Analysis Tools, Techniques and SPC 4
L Measurement Uncertainty using Control Chart Measurement Uncertainty (MU) 2