In Excel, the TDIST function is the function that returns the probability of the Student distribution, which helps in the work a lot, helping the work to be solved more quickly and accurately when writing the correct syntax. Below is the TDIST function syntax, you refer back to it.
The Excel TDIST function is a function that returns the probability of the Student distribution (distribution t), x is the calculated value of t and is used to calculate probabilities. The t-distribution is used in hypothetical tests of small sample datasets. The function is used instead of the table of standard values of the Student distribution.
TDIST function and examples
How to Use the TDIST Function in Excel – Illustrative Example
Syntax: TDIST(x, degrees_freedom, tails)
– x : Value for calculating the Student distribution.
– Degrees_freedom: integers indicate degrees of freedom, required values.
– Tails: determines how the remainder of the distribution is returned.
+ If tails = 1, TDIST() returns a one-tailed distribution;
+ If tails = 2, TDIST() returns a two-tailed distribution. Required value.
Consider for example:
Calculate the Student distribution value with a value x = 2.67 and a number of degrees of freedom of 60?
We do the following:
– Tails case = 1: In cell E9 we enter the formula, the result returned as shown below.
– Tails=2 case: In cell E15 we enter the formula. The result is returned as shown below
Through the above examples, you must have a better understanding of the syntax as well as how to use the TDIST function in Excel, so that it can be applied to calculations on spreadsheets efficiently and quickly.