x Turn on thread page Beta
 You are Here: Home >< Maths

# Statisitics excel watch

1. How would I do this in excel?

I have four age groups all measuring different heights: How would I test for difference between the groups at 0.01 level of significance? Would I use ANOVA?

Also - how could I establish which group is different from the others at the 0.01 level of significance?

Thanks xx
2. (Original post by kategeo)
How would I do this in excel?

I have four age groups all measuring different heights: How would I test for difference between the groups at 0.01 level of significance? Would I use ANOVA?

Also - how could I establish which group is different from the others at the 0.01 level of significance?

Thanks xx
If you are going to do this in Excel (something that I would not recommend) then you need the Data Analysis ToolPak add-in installed. The you can follow one of the many online tutorials such as this one.

Note that doing the second test (identifying the group that is different) will mess up the nominal significance levels, and strictly speaking, you should adjust for the multiple testing. Whether you should do this depends upon the context of the question (is this a "real" question or an exercise?)

TSR Support Team

We have a brilliant team of more than 60 Support Team members looking after discussions on The Student Room, helping to make it a fun, safe and useful place to hang out.

This forum is supported by:
Updated: May 3, 2016
Today on TSR

### Loughborough better than Cambridge

Loughborough at number one

Poll
Useful resources

### Maths Forum posting guidelines

Not sure where to post? Read the updated guidelines here

### How to use LaTex

Writing equations the easy way

### Study habits of A* students

Top tips from students who have already aced their exams