The T.DIST function returns the right tailed Student distribution for a value x. Along with T.DIST.2T, this function replaces TDIST and is equivalent to calling TDIST with the tails argument set to 1.
Parts of a T.DIST function
T.DIST(x, degrees_freedom, cumulative)
| Part | Description |
|---|---|
x | Required. The x value to evaluate the distribution at. |
degrees_freedom | Required. The degrees of freedom. |
cumulative | Required. True/false value field. If true, returns the cumulative probability for x. If false, returns the probability density function for x. |
Sample formulas
Example 1: A1 has T.DIST(1.96, 60, false)Example 2: A1 has T.DIST(-1.98, 2, false)Example 3: A1 has T.DIST(1.96, 60, true)Example 4: A1 has T.DIST(-1.98, 2, true)
Notes
If deg_freedom is less than 1, returns as #NUM error.
Examples
Result for A1=T.DIST(1.96, 60, false)
| A | B |
|---|---|
| 1 | 0.059847906211419 |
| 2 |
Result for A1=T.DIST(-1.98, 2, false)
| A | B |
|---|---|
| 1 | 0.06941821226899947 |
| 2 |
Result for A1=T.DIST(1.96, 60, true)
| A | B |
|---|---|
| 1 | 0.972677535131736 |
| 2 |
Result for A1=T.DIST(-1.98, 2, true)
| A | B |
|---|---|
| 1 | 0.09312625192178947 |
| 2 |