Want to understand Binomial Capability Analysis?

QI Macros will calculate it for you!

Binomial Process Capabiility Analysis Excel

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":

cp cpk template on QI Macros menu

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?

easy to use

Fast and Easy to Use

  • Works Right in Excel
  • Calculates Cp Cpk Pp Ppk
  • Accurate No-Worry Results
  • Free Training Anytime

proven and trusted

Proven and Trusted

  • 100,000 Users in 80 Countries
  • Celebrating 20+ Years
  • Five Star CNET Rating - Virus Free



  • Only $349 USD
    Quantity Discounts Available
  • No annual fees
  • Free Technical Support