How Do I Perform ANOM Nonparametric Transformed Rank Test in Excel Using
SigmaXL?
Open Customer Data.xlsx, click on Sheet 1 tab.
Click SigmaXL > Graphical Tools > Analysis of Means (ANOM) >
ANOM Nonparametric
Transformed Ranks. Ensure that the entire data table is
selected. If not, check Use Entire Data
Table.
Click Next. Ensure that Stacked Column Format is
checked.
Select Overall Satisfaction, click Numeric Data Variable (Y)
>>; select
Customer Type, click Group
Category (X) >>. Set Alpha
Level = 0.05.
Click OK. The ANOM Nonparametric Transformed Ranks
chart is shown below:
Here we see that Customer Type 1 mean
transformed rank satisfaction score is significantly
below the grand mean and Customer Type 2 is significantly
higher. This is consistent with the
results that were observed in the Kruskal-Wallis analysis
The varying decision limits are due to
the varying sample sizes for each Customer Type, with
smaller sample size giving wider limits in a manner similar to a
control chart. If the data are
balanced, the decision limit lines will be constant.
Open ANOM Examples.xlsx, click on the
Exponential Data TR tab. This is exponential data,
Example 9.16 from the ANOM book with alpha level = 0.01 (used
with author permission).
Click SigmaXL > Graphical Tools >
Analysis of Means (ANOM) > ANOM Nonparametric
Transformed Ranks. Ensure that the entire data table is
selected. If not, check Use Entire Data
Table.
Click Next. Ensure that
Stacked Column
Format is checked. Select Y, click Numeric Data
Variable (Y) >>; select X, click Group Category (X)
>>. Set
Alpha Level = 0.01.
Click OK. The ANOM Nonparametric
Transformed Ranks chart is shown below:
X = 1 shows as significantly higher than
the grand mean transformed rank and X = 3 is
significantly lower (at alpha = 0.01). These results match those
given in the ANOM book.
By way of comparison, rerun the
analysis using ANOM One-Way Normal (with alpha = 0.01).
The results are:
ANOM Normal fails to detect the significant differences in mean
noted above.
