How to Make a T-Test on Excel

Written by brian valle
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Make a T-Test on Excel
Analyse data and predict results with Excel's statistical functions. (John Foxx/Stockbyte/Getty Images)

In inferential statistics, the t-test assesses whether two sets of data are different from each other, and compares their means. The t-test is commonly used for studying the results of experiments and A/B tests, and for quantifying improvement or change. For example, you can do a t-test to measure how drinking 10 cups of brewed coffee a day can affect a person's heart rate, or to find out if introducing a new textbook has improved students' communication skills. To do t-tests in Microsoft Excel, use its built-in "T.TEST" function.

Skill level:


  1. 1

    Start Microsoft Excel. Press "CTRL+N" to create a new workbook.

  2. 2

    Type "Data1" and "Data2" in cells "A1" and "B1," respectively. You may replace these with your preferred variable names.

  3. 3

    Enter your first set of data in column "A," starting from cell "A2."

  4. 4

    Enter your second set of data in column "B," starting from cell "B2." Make sure that both columns have the same number of cells. For instance, if column "A" contains five entries, column "B" should also have five entries.

  5. 5

    Highlight all non-empty cells (including the variables) and then press "CTRL+SHIFT+F3."

  6. 6

    Select the cell below the last number in column "A." Type "=T.TEST" and then press "CTRL+A." This opens a dialogue box where you can enter parameters for the function.

  7. 7

    Enter "Data1" and "Data2" into the "Array1" and "Array2" boxes, respectively.

  8. 8

    Enter 1 into the "Tail" box if you'd like to use one-tailed distribution. Otherwise, enter 2.

  9. 9

    Enter the kind of test you'd like to perform in the "Type" box. Use any of the values below.

    1 - Paired t-test

    2 - Two-sample equal variance

    3 - Two-sample unequal variance

  10. 10

    Click on "OK" to view the result of your formula.

Tips and warnings

  • If you are using Microsoft 2007 or earlier, use "TTEST" instead of "T.TEST." Both functions work the same way, and have the same parameters. Although "TTEST" still works in Excel 2010, using "T.TEST" is highly recommended.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.