How Do I Run Histograms with Descriptive Statistics?

Multiple Histograms

1. Click Sheet 1 Tab of Customer Data.xls (or press F4 to activate last worksheet).

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:

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

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!

6. 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.

Click here to download a Free 30-Day Trial.