TTEST
Definition
Returns the probability associated with t-test. Determines whether two samples are likely to have come from the same two underlying populations that have the same mean.
Sample Usage
TTEST(A1:A4, B1:B4, 2, 1)
Syntax
TTEST(range1, range2, tails, type)
range1
- The first sample of data or group of cells to consider for the t-test.range2
- The second sample of data or group of cells to consider for the t-test.tails
- Specifies the number of distribution tails.If
1
: uses a one-tailed distribution.If
2
: uses a two-tailed distribution.
type
- Specifies the type of t-Test.If
1
: a paired test is performed.If
2
: a two-sample equal variance (homoscedastic) test is performed.If
3
: a two-sample unequal variance (heteroscedastic) test is performed.
Notes
tails
andtype
must be numeric.range1
andrange2
must have the same number of data points.TTEST
uses the data inrange1
andrange2
to compute a non-negative test. Iftails
is set to1
,TTEST
returns the probability of a higher value of the t-statistic under the assumption thatrange1
andrange2
are samples from populations with the same mean. The value returned byTTEST
whentails
is set to2
is double that returned whentails
is set to1
and corresponds to the probability of a higher absolute value of the t-statistic under the "same population means" assumption.
In order to use the TTEST formula, start with your edited Excellentable:
Then type in the TTEST formula in the area you would like to display the outcome:
By adding the values you would like to calculate the TTEST formula for, Excellentable will generate the outcome: