Want to understand Binomial Capability Analysis?
QI Macros will calculate it for you!
Using p Chart data in columns B and C, the QI Macros Binomial Capability Template will create the charts and calculations for you!
NOTE: Make sure that not only is your data stable, but that it follows a Binomial Distribution, prior to inputting your data into this test. If your data is unstable and/or does not follow the Binomial Distribution, the calculated results may not be reliable.
Analysis (Based on Output Shown Above)
- The p chart is in control so capability analysis is possible. (Out of control data, as mentioned above, is not recommended)
- The Cumulative % Defective chart is also pretty stable.
- The Defective Rate chart shows points evenly distributed on either side of the average, so distribution is Binomial.
- The Percent Defective is too low (1.352). The desired level for capability is when your Process Z is greater than 2. If less than 2, cell AB12 will turn orange to indicate lack of capability.
- If the upper Upper Confidence Interval (UCI) for percent defect is greater than the target percent defective, then you cannot be 95% confident that the process is capable.
This template can be opened by selecting the "Capability Templates" drop-down menu and choosing "Binomial Capability":
Stop Struggling with !
Start creating your in just minutes.
Download a free 30-day trial. Get now!
Why Choose QI Macros to Perform Capability Analysis and Draw Histograms?
Fast and Easy to Use
- Works Right in Excel
- Calculates Cp Cpk Pp Ppk
- Accurate No-Worry Results
- Free Training Anytime
Proven and Trusted
- 100,000 Users in 80 Countries
- Celebrating 20+ Years
- Five Star CNET Rating - Virus Free
Affordable
- Only $349 USD
Quantity Discounts Available - No annual fees
- Free Technical Support