Histograms

img

How Do I Create Histograms with Descriptive Statistics?



  1. Click Sheet 1 Tab of Customer Data.xlsx

  2. 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 Overall Satisfaction, click Numeric Data Variables (Y) >>, select Customer Type, click Group Category (X1) >> as shown:

    img

  5. Click OK. Multiple Histograms and Descriptive Statistics of Customer Satisfaction By Customer Type are produced:


  6. img

    Clearly Customer Type 2 shows a higher level of overall satisfaction, with the data skewed left. Note that Customer Type 1 and 3 have data that is normally distributed, but this is not desirable when the response is a satisfaction score!

  7. Note that bin one is 1.72 to < 1.99, bin 2 is 1.99 to < 2.26, etc. The number of decimals displayed can be changed by double-clicking on the X axis, click Number tab, and adjust decimal places.

Define, Measure, Analyze, Improve, Control

img

Simulate, Optimize, Realize

img