T-test with Excel - how it works

You can use the T-Test function to visualize the statistics in Excel. In this practical tip, we will show you how you can use the function.

Use T-Test in Excel - so it'll work

With this function you can check in Excel whether two samples come from two populations with the same mean:

• The basic formula is: "TTEST (Matrix1; Matrix2; Pages; Type)". Copy this into any field of your Excel document.
• The first dataset is referred to as “Matrix1”, and “Matrix2” accordingly designates the second dataset. In the example (see picture), Matrix1 is approximately "A2: A10".
• The "Pages" variable determines the number of end faces. If there is a "1" in the cell, the one-sided distribution is used, if "2" is used, the two-sided distribution.
• The "type" indicates which test type should be used. If the value "1" is in the respective cell, the "Paired" test is used.
• However, if a "2" is used, the test "Two samples, same variance (homoscedastic)" is used.
• You can also enter a "3". In this case the test "Two samples, unequal variance (heteroscedastic)" is used.
• Always enter the name of the cell in which the content is located, for example A1 for Matrix1.
• In our picture (see right) you will find an example for better understanding.