Manuals/calci/TTEST
Jump to navigation
Jump to search
TTEST(ar1,ar2,t,type)
Where ar1, ar2 are the first and second data sets,'t' the number of distribution tails,and 'type' is the kind of t-Test to perform.
This function returns the probability associated with a Student's t-Test.
- TTEST returns the error value when array1 and array2 have a different number of data points or 't' or type is nonnumeric.
- In this test 't' value must be 1 or 2.
TTEST
Lets see an example,
B C
4 5
5 15
6 6
7 4
1 5
2 5
5 19
4 2
=TTEST(B2:B9,C2:C9,2,1) is 0.1499
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 4 | 5 | 0.149852 | |
| Row2 | 5 | 15 | ||
| Row3 | 6 | 6 | ||
| Row4 | 7 | 4 | ||
| Row5 | 1 | 5 | ||
| Row6 | 2 | 5 | ||
| Row7 | 5 | 19 | ||
| Row8 | 4 | 2 |
