Description Computes the complementary student's T-distribution, one of the methods of determining whether two samples (often the experimental sample and a control group) are statistically different.
This function assumes the value you are testing is part of a normal distribution. You may choose to compute a one-tailed or two-tailed distribution.
Syntax TDIST (x, df, tails)
| Argument | Description |
|---|---|
| x | The value at which you want to evaluate the distribution. It must be a positive number. |
| df | A positive integer indicating the number of degrees of freedom. Decimal values will be truncated to integers. |
| tails | Enter 1 for a one-tailed distribution, 2 for two-tailed. |
Remarks This function returns a probability value between zero and one. Values closer to one indicate a high probability that the samples are similar. Lower values indicate a lower probability that the samples are similar.
Equation
...where k is the degrees of freedom.
Examples This function returns 0.089213:
This function returns 0.178425:
See Also BETADIST, BINOMDIST, CHIDIST, COMBIN, CRITBINOM, FDIST, GAMMADIST, NORMSDIST, TINV
