Resource Image

Spreadsheet Tutorial 4: t-Test

Author(s): HHMI BioInteractive

1004 total view(s), 290 download(s)

0 comment(s) (Post a comment)

Calculate t-values and perform t-tests using built-in functions.

Licensed under CC Attribution-NonCommercial-NoDerivatives 4.0 International according to these terms

Version 1.0 - published on 15 Jan 2018 doi:10.25334/Q49T0D - cite this


This tutorial covers the t-test, including how to calculate t-values manually, a table of critical values of t, and how to use the built-in TTEST function to perform a t-test. Also includes doing a t-test using Excel’s Analysis Toolpak.

Statistical concepts covered in this tutorial include the t-test.

Cite this work

Researchers should cite this work as follows: