DEV Community

Andrews
Andrews

Posted on • Originally published at geekexcel.com on

How To Use Excel T TEST Function in Excel office 365?

#touseexcelttestfunct #excel #excelfunctions

In this article, you will learn how to use Excel T TEST Function in Excel 365 using its basic syntax, explanation, and examples. Let’s see them below!! Get the official version of MS Excel from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

T TEST Function

The T TEST or Student’s test is used to determine the confidence of an analysis. In mathematical terms, it is used to know if the mean of the two samples is equal. T.TEST is used to accept or reject the null hypothesis.

T TEST Function Syntax 

=T.TEST(group1, group2, tails, type)
Enter fullscreen mode Exit fullscreen mode

Syntax Explanation:

  • group1: the first group of experiments.
  • group2: the second group of experiments. It can have the same subject as of group1, different subjects with the same variance and different subjects with different variance.
  • tails: it has two options, 1 tailed, and 2 tailed. 1 tailed T TEST is used when we know that the effect of the experiment is one-directional. 2 tailed T TEST, it is used when we don’t know the direction of the effect of the experiment
  • type: There are three options available (1,2,3).
    • 1 (Paired): we use it when group1 and group2 have same subjects.
    • 2 (Two sample equal variance): When the subjects of these groups are different, but variance is same.
    • 3 (two sample unequal variances): When subjects of two groups are different and variance is also different.

Example

  • Firstly, you need to create a sample data with Group 1 studied while chewing gum and group 2 studied normally.

Sample data

  • Then, you have to collect the data and calculated the mean in Excel.

Mean value

  • Now, you need to calculate the T TEST function in the Excel.
  • Null Hypothesis (H0): There is no difference in score due to studying while chewing gum.
  • After that, you have to calculate the 1 tailed T-TEST function with the paired group. 
=T.TEST(B3:B10,C3:C10,1,1)
Enter fullscreen mode Exit fullscreen mode

One-tailed

  • Finally, you need to calculate the 2 tailed T TEST function. 
=T.TEST(B3:B10,C3:C10,2,1)
Enter fullscreen mode Exit fullscreen mode

two-tailed

Sum-Up

In the above short tutorial, we have illustrated how to use the Excel T TEST Function In Excel Office 365. Hope you like this article. Please feel free to state your query or feedback for the above article. Thank you so much for Reading!! To learn more, check out Geek Excel!! *and Excel Formulas *!!

Read Ahead:

Oldest comments (0)