[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
TTEST ( array-1 , array-2 , distribution-tails , test-type )
Description: Computes the probability associated with a Student's t-Test.
Arguments:
|
Name |
Type |
Description | ||||||||
|
array-1 |
array, reference |
The first numerical data set. | ||||||||
|
array-1 |
array, reference |
The first numerical data set. | ||||||||
|
distribution-tails |
number |
Specifies the number of distribution tails, truncated to an integer. If 1, TTEST uses the one-tailed distribution. If 2, TTEST uses the two-tailed distribution. | ||||||||
|
test-type |
number |
The truncated-to-integer kind of t-Test to perform, as follows:
|
Return Type and Value: number – The probability associated with a Student's t-Test.
However, if
• array-1 and array-2 have a different number of data points, and test-type is 1, the return value is unspecified.
• distribution-tails is any value other than 1 or 2, #NUM! is returned.
[Example: Given the following data:
|
|
A |
B |
|
1 |
Data 1 |
Data 2 |
|
2 |
3 |
6 |
|
3 |
4 |
19 |
|
4 |
5 |
3 |
|
5 |
8 |
2 |
|
6 |
9 |
14 |
|
7 |
1 |
4 |
|
8 |
2 |
5 |
|
9 |
4 |
17 |
|
10 |
5 |
1 |
TTEST(A2:A10,B2:B10,2,1) results in 0.196016
end example]