Include Top

How Do I Display Descriptive Statistics in Excel Using SigmaXL?

Descriptive/Summary Statistics

  1. Open Customer Data.xls (to access, click SigmaXL > Help > Open Help Data Set Folder or Start > Programs > SigmaXL > Sample Data). Click Sheet 1 Tab.
  2. Click SigmaXL > Statistical Tools > Descriptive Statistics.
  3. Check Use Entire Data Table, click Next.
  4. Select Overall Satisfaction, click Numeric Data Variable (Y) >>, select Customer Type, click Group Category (X1) >>, as shown:
  5. Descriptive Statistics

  6. Click OK.
  7. Descriptive Statistics are given for Customer Satisfaction grouped by Customer Type:

  8. Descriptive Statistics Result

    Which Customer Type has the highest mean satisfaction score? Clearly Type 2. However, we have to be careful concluding that there is a significant difference in satisfaction solely by looking at the Means. In the Analyze Phase, we will run tests of hypothesis to validate that Type 2 Customers are, in fact, significantly more satisfied.

    Tip: Click on Column B, click Window > Split, Window > Freeze Panes (Excel 2007/2010: View | Window | Split, Freeze Panes). This freezes Column A and allows you to scroll across the Descriptive Statistics for each level of the Group Category. This is particularly beneficial when there are a large number of columns.

  9. Click Recall SigmaXL Dialog menu or press F3 to recall last dialog. Change the format selected to Column Format as shown:

    Descriptive Statistics

  10. Click OK. Descriptive Statistics are given for Customer Satisfaction broken out by Customer Type in Column Format:

    Descriptive Statistics Column Format

Define, Measure, Analyze, Improve, Control

Lean Six Sigma Software Excel Add-in

Simulate, Optimize,

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 (744.6295)