" Include Top

Home | Login | Live Help is Live Help

Included Menu

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

Click here to download a Free 30-Day Trial.