Include Top

How Do I Perform ANOM Poisson Rate Two-Way in Excel Using SigmaXL?

  1. Open ANOM Examples.xlsx, click on the ER Visits – Poisson Rate tab. This is Emergency Room
    Visits Data. It is a factorial design study to investigate the effect of nurse intervention (1 = home
    nurse assigned, 2 = home nurse not assigned) and payor groups (1, 2, 3) on the ER utilization
    rates for patients with COPD (a serious lung disease) with an alpha level = 0.01 (Example 5.16
    from the ANOM book – used with author permission).


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

  3. Click Next. Select ER Visits, click Numeric Data Variable (Y) >>; select Sample Size, click
    Subgroup Column or Size >>; select Intervention, click Group Category Factor (X1) >>; select
    Payor, click Group Category Factor (X2) >>. Alpha Level = 0.01, Adjust chart alpha for familywise
    error rate
    is unchecked:


  4. Click OK. The ANOM Poisson Rates Two-Way Main Effects, Slice charts and Interaction plots are
    shown below:



  5. Since the Interaction is not significant (P-Value >= 0.1, automatically determined from Poisson
    regression), the Main Effects charts are highlighted. Both factors Intervention and Payor are
    significant at alpha = 0.01. “Home nurse assigned” results in a significantly lower rate of ER
    visits versus “no home nurse assigned.” Payor Type 1 has a significantly lower rate of ER visits
    and Type 2 has a significantly higher rate.

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)