Difference between revisions of "Manuals/calci/TTEST"
Jump to navigation
Jump to search
Line 48: | Line 48: | ||
#=TTEST(A1:G1,A2:G2,1,2)=0.3725946027453 | #=TTEST(A1:G1,A2:G2,1,2)=0.3725946027453 | ||
#=TTEST(A1:G1,A2:G2,2,2)=0.7451892054907 | #=TTEST(A1:G1,A2:G2,2,2)=0.7451892054907 | ||
− | #=TTEST(A1:G1,A2:G2,1,3) = 0. | + | #=TTEST(A1:G1,A2:G2,1,3) = 0.37285157760157517 |
− | #=TTEST(A1:G1,A2:G2,2,3) = 0. | + | #=TTEST(A1:G1,A2:G2,2,3) = 0.7457031552031503 |
#=TTEST(A1:G1,A2:G2,2.2,1.3) = NAN | #=TTEST(A1:G1,A2:G2,2.2,1.3) = NAN | ||
Revision as of 15:11, 5 March 2018
TTEST(ar1,ar2,ta,ty)
- and are the array of values.
- is the number of distribution tails.
- is the type of t-test.
Description
- This function gives the probability of the t-test.
- It is also called student's t-test.
- This function is used to find the probability of two samples having the same mean but equal or unequal variances.
- In TTEST(ar1,ar2,ta,ty), ar1 and ar2 are two set of array values.
- ta is indicating the number of distribution tails. ta value is either 1 or 2.
- If ta=1,then TTEST uses the one-tailed distrbution.If ta=2, then TTEST uses the two-tailed distrbution.ty is the type of t-Test. ty value is 1 or 2 or 3.
ty value | t-Test is performed |
1 | Paired |
2 | Two-sample equal variance |
3 | Two-sample unequal variance |
- Suppose we are giving ta and ty in decimals , then it will converted in to integers.
- TTEST uses the value of ar1 and ar2 to find non-negative t-statistic.
- If ta=1, then it gives the probability of a higher value of the t-statistic with consideration of two arrays of samples with the same mean.
- If ta=2, then TTEST is gives double that when ta=1 and corresponds to the probability of a higher absolute value of the t-statistic with the consideration of same mean.
This function will give the result as error when
1. ar1 and ar2 have a different number of data points and ty=1. 2. Any one of the argument is nonnumeric. 3. ta>2 and ty>3.
Examples
A | B | C | D | E | F | G | |
---|---|---|---|---|---|---|---|
1 | 3 | 5 | 14 | 10 | 8 | 2 | 15 |
2 | 11 | 19 | 5 | 4 | 15 | 7 | 3 |
- =TTEST(A1:G1,A2:G2,1,1)=0.399108571503
- =TTEST(A1:G1,A2:G2,2,1)=0.7982171430076
- =TTEST(A1:G1,A2:G2,1,2)=0.3725946027453
- =TTEST(A1:G1,A2:G2,2,2)=0.7451892054907
- =TTEST(A1:G1,A2:G2,1,3) = 0.37285157760157517
- =TTEST(A1:G1,A2:G2,2,3) = 0.7457031552031503
- =TTEST(A1:G1,A2:G2,2.2,1.3) = NAN
Related Videos
See Also
References