Statistic tests provide useful methods to decide whether observed data reflects real differences, or whether it is something that might have occurred by chance.

Statistical methods can become really complicated, but there are some very useful statistical methods that can be carried out without undue complication. It is often useful to be able to provide some simple statistical tests to support a case you may be arguing for in a report.

So, without any complicated explanations or procedures, this video will show you how to carry out some simple statistical procedures using Excel.

And even if you are not envisaging undertaking these tests for yourself, it is still important to have some idea about how other people may have used these tests in any reports you have read.

The tests illustrated will include calculating means, standard deviations, comparing means using t-tests, comparing frequencies using chi squared.