ANOVA with missing values

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Bob Franks (anonymous_at_discussions.microsoft.com)
Date: 04/26/04 

Date: Mon, 26 Apr 2004 10:51:05 -0700

Can I run a single or multiple factor ANOVA with replication in Excel when i am missing one or more data points? If so, what do I put into the cell where the missing data point would otherwise go?

Please help - I cannot figure out how to run an ANOVA when I do not have equally sized groups, or when I have to exclude a sample from one of the groups.

Thanks,
Bob

Relevant Pages

  • Re: ANOVA, GLM and missing values
    ... To analyse ANOVA-type data with missing values I have to use GLM, which ANOVA reduces to under certain circumstances. ... As far as I can see, the generalization from ANOVA lies in the conceot of a link function, and allowing this to be something other than the identity function ushers in a new dimension of modelling possibilities. ...
    (sci.stat.math)
  • ANOVA, GLM and missing values
    ... In the software implementations of ANOVA that I have seen, missing ... I have to use GLM, which ANOVA reduces to under certain circumstances. ... However, when the link function is the identity function, GLM is ...
    (sci.stat.math)
  • ANOVA effect size
    ... I'm currently running a 3-way ANOVA and my sample size is very large ... accounted for X% of our explainable variance". ... Is it as simple as adding up the MStreatments associated with ... like that should be a meaningful measure, but perhaps I'm missing ...
    (sci.stat.consult)