QUBES will be intermittently unavailable due to scheduled maintenance the afternoon of Thursday, July 9, 2020. The maintenance work will end all tool sessions and there will be some downtime of other features during the maintenance period. Please plan accordingly and we do apologize for any inconvenience. close


Support Options

  • Knowledge Base

    Find information on common questions and issues.

  • Support Messages

    Check on the status of your correspondences with members of the QUBES team.

Contact Us

About you
About the problem

Spreadsheet Tutorial 4: t-Test

By HHMI BioInteractive

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

Listed in Teaching Materials | resource by group HHMI BioInteractive

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

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

tutorial 4.jpg


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:


HHMI BioInteractive

HHMI BioInteractive group image

When watching a resource, you will be notified when a new version is released.