Skip to main content
Mail a PDF copy of this page to:
(Your email address will not be added to a mailing list)
Show menu Show menu

Comparison of means (t-test)


Performs a t-test for the comparison of the means of two independent samples.

This test is not performed on data in the spreadsheet, but on statistics you enter in a dialog box.

Required input

Comparison of means (t-test)

The program displays the difference between the two means, and a 95% confidence interval for this difference. Next, the P value is displayed: when this P value is less than 0.05, the conclusion is that the two means are significantly different.

In the example, the mean 256 (standard deviation 22 and sample size 50) of the first sample, is compared with the mean 232 (standard deviation 32 and sample size 50) of the second sample. The difference between the two means is 24. The 95% confidence interval for this difference ranges from 13.1 to 34.9 (note that this interval excludes the value 0). The hypothesis test results in a P-value less than 0.0001, and the conclusion therefore is that, statistically, there is a significant difference between the two means.

In the Comment input field you can enter a comment or conclusion that will be included on the printed report.


  • Bland M (2000) An introduction to medical statistics, 3rd ed. Oxford: Oxford University Press.