Include Top

How Do I Perform ANOM Normal One-Way in Excel Using SigmaXL?

  1. Open Customer Data.xlsx, click on Sheet 1 tab.

  2. Click SigmaXL > Graphical Tools > Analysis of Means (ANOM) > ANOM Normal One-Way.
    Ensure that the entire data table is selected. If not, check Use Entire Data Table.

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


  4. Click OK. The ANOM Normal One-Way chart is shown below:


  5. Here we see that Customer Type 1 mean satisfaction score is significantly below the overall
    mean and Customer Type 2 is significantly higher. This is consistent with the results that were
    observed in the ANOVA analysis, but is easier to interpret.

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

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)