Select Overall Satisfaction, click
Numeric Data Variable (Y) >>, select Customer Type, click
Group Category (X1) >>, as shown:
Descriptive Statistics are given for
Customer Satisfaction grouped by Customer Type:
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.
Click Recall SigmaXL Dialog menu or press
F3 to recall last dialog. Change the format selected to
Column Format as shown:
Click OK. Descriptive Statistics are given for Customer Satisfaction broken out by Customer Type in Column Format: