Include Top

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


  1. Open ANOM Examples.xlsx, click on the Test Scores – Binomial Prop tab. This is standardized
    math test score data from 10 elementary schools (Example 3.4 from the ANOM book – used
    with author permission). We are testing to see if there is a difference between schools at an
    alpha = 0.01 level.

    images/Binom1.png

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

  3. Click Next. Select Proficient, click Numeric Data Variable (Y) >>; select Enrollment, click
    Subgroup Column or Size >>; select School, click Optional Group Category (X) >>. Set Alpha
    Level
    = 0.01:

    images/Binom2.png


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

    images/Binom3.png

  5. The resulting ANOM decision chart shows that three schools are performing at significantly low
    levels and two schools are performing at significantly high levels.

  6. SigmaXL automatically checks to see if the sample sizes are large enough for the normal
    approximation to the Binomial to be valid, i.e., np and n(p-1) are > 5. Here we see: Warning:
    Sample sizes are too small to use the normal approximation to the binomial distribution.
    Sample #1 has minimum n(1-p) = 2.0. Note that the warning does not show all occurrences,
    just the sample(s) with smallest failed np or n(1-p).

  7. This does not mean that the chart results are invalid, an obvious “out” or “in” will not likely be
    affected, but the results should be used with caution, and if possible, more data collected.


Define, Measure, Analyze, Improve, Control

Lean Six Sigma Software Excel Add-in

Simulate, Optimize,
Realize

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)

Support: Support@SigmaXL.com

Sales: Sales@SigmaXL.com

Information: Information@SigmaXL.com