Nonparametric ANOVA on Excel

Home > Statistics Every Writer Should Know > The Stats Board > Discusssion

Nonparametric ANOVA on Excel
Message posted by Grad Student (via 208.191.234.201) on June 29, 2001 at 3:55 PM (ET)

Can anyone help? How do you conduct a nonparametric ANOVA (i.e., Kruskal-Wallis ANOVA by ranks) for 6 groups on Excel?

READERS RESPOND:
(In chronological order. Most recent at the bottom.)

Re: Nonparametric ANOVA on Excel
Message posted by JG (via 128.8.22.71) on June 29, 2001 at 9:15 PM (ET)

If you are doing nonparametric then you are probably working with medians instead of means and the obvious measure of variability is the inter-quartile range or a box-and-whiskers plot for each quantity of interest.
In any case, I don't see how you can do anything that can be called ANOVA. There is no variance to work with and the usual theorems associated with ANOVA are not relavent.

Your $5 contribution helps cover part the $500 annual cost of keeping this site online.