Syntax :

=TTEST( array1, array2, tails, type )

Parameters :

• array1 – The initial data collection.
  array2 – the next data set (must have the same length as array1).
  tails – The distribution’s number of tails. This must be either:
  1 – Employs the one-tailed distribution
  2 – Makes use of the two-tailed distribution –

• type – An integer indicating the kind of t-test. This might be either:

  1 – Paired T-Test
  2 – Two-sample equivalence T-Test
  3 – Two-sample uneven variance T-Test