• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

T-Test in Excel

March 9, 2021 by Andrew Childress
T test in Microsoft Excel

A t-test is a statistical analysis that identifies the differences, if any, between the means of two data sets. Let's learn how to do a t-test.

A t-test is a statistical analysis designed to identify the differences, if any, between the means (averages) of two data sets. Need to perform one quickly? Let’s learn how to run a t-test in  Excel.

How to Run a T-Test in Microsoft Excel

Imagine you have two sets of data. For our purposes, let’s use the average scores of two sports teams. We want to find out the differences, if any, in their given average performance.

Data for t test Excel

T-tests may be one or two variables. Since these two data sets do not come from the same group, that makes this a two-variable test. (If you were comparing two data sets from the same team, it would be a one-variable test).

To start your analysis, begin by clicking into an empty cell on your worksheet. Type =, the standard way to begin any Microsoft Excel formula. Then, type ttest(.

As you can see, Excel is asking for four inputs:

array1,array2,tails,type.

T tests in Excel

 

Array1 is the data in column A, so begin by clicking and dragging to select the cell range, A2:A8. Type , and then repeat the click-and-drag step for your column B data.

Type , again. So far, your formula should read:

=ttest(A2:A8,B2:B8,

T test in Microsoft Excel

Tails will be either 1 or 2. If you believe there to be a significant difference between the two data sets, you’ll want to perform a 1-tail test. If you foresee no difference (or simply don’t know), run a 2-tail test. In our case, we’ll type 2, followed by , again.

Type refers to your number of variables. 1 would be a one-variable test. 2 is a two-variable test with equal variances. 3 is a two-variable test with unequal variances. (Hint: unless you know the variances are equal, use 3, unless you’re running a 1-variable test). Here, we’ll use 3. Close your ).

How to run T Tests in Excel

Your finished formula is:

=ttest(A2:A8,B2:B8,2,3)

Hit Enter, and Excel will return the value 0.98293835.

This number is what’s commonly called your p-value. Typically, the lower the value relative to 1, the more statistically significant it is. As you can see here, we’ve identified an insignificant difference between the two data sets.

This is how Microsoft Excel makes statistics a breeze.

Category: Excel TutorialsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Anova in Microsoft ExcelAnova in Excel
Next Post:Regression in ExcelExcel regression setup

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top