writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 12:
Line 12: − + − + − + − + − + + + + + + +
no edit summary
*ta is indicating the number of distribution tails. ta value is either 1 or 2.
*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.
*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.
{| class="wikitable"
ty value t-Test is performed
|+Spreadsheet
1 - Paired
|-
2 - Two-sample equal variance
|ty value || t-Test is performed
3 - Two-sample unequal variance
|-
|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.
*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.
*TTEST uses the value of ar1 and ar2 to find non-negative t-statistic.