TTEST Excel Formula

Author Zaheer    Category Formulas     Tags ,

Excel application helps you in the trickiest files that you have to work in office or in school. It aids you put data in numerals or alphabets so easily. However, for you to do this you have to be familiar with the excel functions, when and how you can use it. One of the functions that you need to learn is the TTest function.

TTest Function Basics

TTest function computes the probability linked with student T Test, which’s normally used in identifying whether 2 data sets are possibly need to come from similar 2 underlying populations with similar mean.

The syntax for this function is:

= TTest (array1, array2, tails, type)

Wherein the functions arguments are:

Array1 – first data set

Array2 – second data set (should have similar length as Array1)

Tails – number of tails for distribution. This should be either:

1-      use one tailed distribution

2-      use two tailed distribution

Type – integer that represent kind of TTest. It can be either:

1 – Paired Ttest

2 – 2 sample equal variance of Ttest

3 – A3 2 sample unequal variance Ttest

Ttest uses data in array1 and array2 to calculate the non negative t stat. when tails equals to one, Ttest return to the probability of higher value of T stat under assumptions that the array1 and array2 are just sample from population with similar mean. Value returned by the Ttest if tails equals to two is doubled which returns if tails equals to one and correspond to probability higher than the absolute value of T stat under similar population mean.

How to Use Ttest Function in Excel?

To use the function in excel, here are some of the steps that you can follow:

  • First, you have to learn the syntax for the function, which is Ttest (array1, array2, tails, and type)
  • Then, give the array1 and the array2 as data sets. Ttest would use the data to calculate the non negative t stat. Ttest would return to #N/A when the data sets has unlike size and the type is one paired Ttest.
  • After that, use the tails showing the desired numbers of distribution tail. Ttest would return to #NUM! When the tails are number other than one or two, Ttest would return to #VALUE! When tails are non numeric
  • Input the value of one for tails as one tailed distribution. Ttest would return the probability of higher stat, assuming that populations represented by array1 and array2 have with the same mean. The value of two would use the tailed distributions which returns the value as high as one returned for one tailed distributions. The values are probability that absolute value of T stat is higher with the use of same population means assumption.
  • Identify type as the kind of Ttest to perform. The type of one indicate the paired Ttest, the type of two is two sample equal or homoscedastic variance and the type of three indicate the two sample unequal or heteroscedastic variance. The Ttest will return to #VALUE! When the type is non numeric.

Post comment