## Friday, September 12, 2014

### How To... Calculate Student's t Statistic for Dependent (Paired) Samples in Excel 2010

In preparing a new set of notes and resources for the Business Data Analysis module (Statistics) on two upcoming undergraduate and one postgraduate course I am creating a new set of videos to support student learning. One of the statistical methods covered is Student's t-test. Learners can sometimes find it awkward as there are two types of t-Test with differing names. We have the t Statistic for Dependent (Paired) Samples, and the t Statistic for Independent (Unpaired) Samples.

In the video below I use scores from a pre and post test to test the difference between the means (Salkind, 2014). My Null and Alternate Hypotheses are:

H0: µpost-test =  µpre-test
H1post-test >  pre-test

The difference between the student's scores on the pre-test and on the post-test is the focus. Participants are being tested mor than once. There are two groups of scores. Therefore the appropriate test statistic is t-Test for dependent (paired) means (Salkind, 2014).

Salkind, N. (2014), Statistics for People Who (Think They) Hate Statistics (5th Edition). SAGE Publications,