You are Here: Home >< Maths

# Statisitics excel

Announcements Posted on
Last day to win £100 of Amazon vouchers - don't miss out! Take our quick survey to enter 24-10-2016
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?)

## Register

Thanks for posting! You just need to create an account in order to submit the post
1. this can't be left blank
2. this can't be left blank
3. this can't be left blank

6 characters or longer with both numbers and letters is safer

4. this can't be left empty
1. Oops, you need to agree to our Ts&Cs to register

Updated: May 3, 2016
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:
Today on TSR

### How does exam reform affect you?

From GCSE to A level, it's all changing

Poll
Useful resources

### Maths Forum posting guidelines

Not sure where to post? Read here first

### How to use LaTex

Writing equations the easy way

### Study habits of A* students

Top tips from students who have already aced their exams