Skip to main content

TDIST

Definition

Calculates the probability for Student's t-distribution with a given input (x).

Sample Usage

TDIST(A2, 30, 1)

TDIST(0.5, 1, 2)

Syntax

TDIST(x, degrees_freedom, tails)

  • x - The input to the t-distribution function.
  • degrees_freedom - The number of degrees of freedom.
  • tails - Specifies whether the calculated distribution will be one- or two-sided. (1 for one-tailed distributions, 2 for two-tailed distributions).

See Also

NOMDIST: Returns the value of the normal distribution function (or normal cumulative distribution function) for a specified value, mean, and standard deviation.

BINOMDIST: Calculates the probability of drawing a certain number of successes (or a maximum number of successes) in a certain number of tries given a population of a certain size containing a certain number of successes, with replacement of draws.

EXPONDIST: Returns the value of the exponential distribution function with a specified lambda at a specified value.

NEGBINOMDIST: Calculates the probability of drawing a certain number of failures before a certain number of successes given a probability of success in independent trials.

PROB: Given a set of values and corresponding probabilities, calculates the probability that a value chosen at random falls between two limits.

In order to use the TDIST formula, start with your edited Excellentable:

Then type in the TDIST Formula in the area you would like to display the outcome

By adding the values you would like to calculate the TDIST formula for, Excellentable will generate the outcome:

 

A
B
1
Student
Value at which to evaluate the t-distribution
2
Tom
1
3
Bob
1.959999998
4
Peter
1.54
5
John
1.63
6
Steve
1.87
7
Dan
1.5
8
Brendon
2
9
10

One-tailed distribution:
0.027322465
11
12

Two-tailed distribution:
0.05464493
C
1
The number of degrees of freedom with which to characterize the distribution.
2
30
3
60
4
40
5
50
6
20
7
10
8
50
9
10
11
12

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.