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)":
Next, 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:
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":
Once completed, a Between/Within Histogram is created:
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":
Next, select the "Histogram Between/Within" tab to open the template:
Lastly, input your data set in columns A through J, and enter your Upper and Lower Spec Limits in Q1 and Q2:
Why Choose QI Macros to Perform Capability Analysis and Draw Histograms?
Affordable
- Only $299 USD - less with quantity discounts
- No annual fees
- Free Technical Support
Easy to Use
- Works Right in Excel
- Calculates Cp Cpk Pp Ppk
- Accurate Results Without Worry
Proven and Trusted
- 100,000 Users in 80 Countries
- Celebrating 20th Anniversary
- Five Star CNET Rating - Virus Free