Between/Within Histogram in Excel

How do you create a Between/Within Histogram using QI Macros?

Used to represent the Potential Process Tolerance, you can create a Histogram Cp Cpk (Between/Within) chart within Excel by selecting your data set and clicking on the "Histograms & Capability" drop-down menu > "Histogram Cp Cpk (Between/Within)":

between/within histogram menu

If you have a single-column set of data, you will receive the following prompt - enter "2", as it is required to have a minimum of 2 subgroups of data to perform a Between/Within Histogram:

between-within-subgroup-size-prompt

If you have multiple columns of data and receive the following prompt, select "Values" if your first column of data is NOT a label:

labels-values-prompt

Then, input your Upper and Lower Specification Limits when prompted. If you do not have one, USL/LSL will be calculated for you - select "OK" for each prompt:

histogram usl prompt histogram lsl prompt

You will also be asked for the "Approximate Number of Bars." If you do not know the approximate number of bars you would like on your Histogram, press "OK":

histogram number of bars prompt

Once completed, a Between/Within Histogram is created:

between within histogram output

NOTE: The Between/Within Histogram uses between/within-subgroup standard deviation, instead of overall standard deviation.


Between/Within Histogram Template

Or you can use our Histogram template to create a Between/Within Histogram! To do so, click on the "Capability Templates" drop-down menu > "Histogram with Cp Cpk":

Histogram Template Menu

Next, select the "Histogram Between/Within" tab to open the template:

Histogram Template Tabs

Lastly, input your data set in columns A through J, and enter your Upper and Lower Spec Limits in Q1 and Q2 (It is required to have a minimum of 2 columns of data to perform a Between/Within Histogram):

Between/Within Histogram Template

NOTE: The Estimator is defaulted to Pooled Standard Deviation (1) in cell S2, however you can change the Estimator to Sbar (2) or Rbar (3).


Why Choose QI Macros to Perform Capability Analysis and Draw Histograms?

affordable

Affordable

  • Only $329 USD - less with quantity discounts
  • No annual fees
  • Free Technical Support

easy to use

Easy to Use

  • Works Right in Excel
  • Calculates Cp Cpk Pp Ppk
  • Accurate Results Without Worry

proven and trusted

Proven and Trusted

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