Need to do Binomial Capability Analysis But Don't Know How?

QI Macros will do the calculations and analysis for you right in Excel!

A Binomial test only has two outcomes: defective or non-defective.

Binomial Process Capabiility Analysis Excel

p chart of fraction defective to determine if the process is stable or not.
chart of cumulative % defective
the defective rate chart to determine if your data is binomial.
the percent defective chart
Process Z measures the capability of your process. The desired level is 2 or greater. For any value less than 2, cell AB12 will <strong> turn orange</strong> to indicate lack of capability.

Tip: If your data is unstable and/or does not follow the Binomial Distribution, the calculated results may not be reliable.

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 Process Z score is 1.352. Since it is less than 2, the template flags it with orange to indicate the lack of capability.
If the Upper Confidence Interval (UCI) for percent defective (cell AB:3 of 10.35%) is greater than the target percent defective (cell AB:6 9.57) , then you cannot be 95% confident that the process is capable.