Include Top

How Do I Create Histograms & Process Capability Reports in Excel Using SigmaXL?

Histograms & Process Capability

  1. Open the file Delivery Times.xls. This contains continuous data of hotel breakfast delivery times. Deviation Time is the deviation around targeted delivery time in minutes. The Critical Customer Requirements (CCR’s) are as follows: USL = 10 minutes late, LSL = -10 minutes (early).
  2. Let’s begin with a view of the data using Histograms and Descriptive Statistics. Click SigmaXL > Graphical Tools > Histograms & Descriptive Statistics.
  3. Ensure that entire data table is selected. If not, check Use Entire Data Table. Click Next.
  4. Select Delivery Time Deviation, click Numeric Data Variable (Y) >>. Click OK.

  5. Histogram and Descriptive Statistics

    Note that the data has an average of 6, so on average the breakfast delivery is 6 minutes late. Also note the wide variation in delivery times (Stdev = 7.2 minutes). With the AD p-value > .05, this data can be assumed to have a normal distribution.

  6. Click Sheet 1 Tab. Click SigmaXL > Process Capability > Histograms & Process Capability (or SigmaXL > Graphical Tools > Histograms & Process Capability).
  7. Select Delivery Time Deviation, click Numeric Data Variable (Y) >>. Enter USL = 10, Target = 0, LSL = -10, check Normal Curve as shown below:

    Histograms and Process Capability
  8. Click OK. Resulting Histogram & Process Capability report is shown below:

    Histograms and Process Capability
  9. With the Process Performance indices Pp and Ppk < 1, this process is clearly in need of improvement. Note that the difference between Pp and Ppk is due to the off-center process mean. (Cp and Cpk indices are provided in the Capability Combination Report or optionally when creating Control Charts).
Click here to download a Free 30-Day Trial.

Define, Measure, Analyse, Improve, Control

Lean Six Sigma Software Excel Add-in

Simulate, Optimize,
Realize

Lean Six Sigma Software Excel Add-in

Web Demos

Our CTO and Co-Founder, John Noguera, regularly hosts free Web Demos featuring SigmaXL and DiscoverSim
Click here to view some now!

Contact Us

Ph: 1.888.SigmaXL ( 1.888.744.6295 )

Support: Support@SigmaXL.com

Sales: Sales@SigmaXL.com

Information: Information@SigmaXL.com