Microsoft Excel: Student's t-toets

The Student's t test determines if the two groups' means are significantly different.

Consider the dataset organized in the Microsoft Excel worksheet.

Now, select the function T.TEST to conduct a two-sample test.

In the function argument, first, add the selected data ranges in Array1 and Array2.

In the section Tails, write 1 for the one-tailed or 2 for the two-tailed test.

Lastly, in Type, write 1 to conduct a paired t test that requires groups to have identical sample sizes. Select 2 when the data are homoscedastic, that is, have equal variances. Use 3 for heteroscedastic groups having unequal variances or sample sizes.

One sample t test requires data to be arranged as follows.

First, arrange the population mean in a cell. Then, calculate the arithmetic mean, sample standard deviation, count, and degrees of freedom.

Now calculate the t statistic as follows.

Finally, use the function T.DIST.2T to conduct a two-tailed test or T.DIST to conduct a one-tailed test.