TTEST

Function Type: Compatibility

Description:

Returns the probability associated with a Student’s t-test. In Excel 2007, this is a Statistical function.

Function Structure:

=TTEST(array1, array2, tails, type).

Argument Breakdown:

array1 – The first data set.

array2 – The second data set (must have the same length as array1).

tails – The number of tails for the distribution. This must be either: 1 – Uses the one-tailed distribution; 2 – Uses the two-tailed distribution.

type – An integer that represents the type of t-test. This can be either: 1 – Paired T-Test; 2 -Two-sample equal variance T-Test; 3 – Two-sample unequal variance T-Test.

Example:

Still need help with Excel and Google Sheets? Get Instant Expert Help in Fiverr or PeoplePerHour platforms. Click one icon below.

We can also accept LEO, HIVE, HBD tokens as payment if we transact directly here in HIVE network.

or you can help me through https://www.buymeacoffee.com/cashheaven 😉

---

Back to Learn Excel->