Manuals/calci/TDIST

TDIST(x,df,t),

• $x$ is the numeric value to find the distribution.
• $df$ is the degrees of freedom.
• $t$ is the number of tails.

Description

• This function gives the value of the T-Distribution.
• It is the continuous probability distributions.
• The T-Distribution is also called Students T-Distribution.
• This is the symmetric distribution like the Normal Distribution.
• It is used when making inferences about a population mean when the population standard deviation is not known.
• In $TDIST(x,df,t)$, $x$ is the numeric value to find the value of the distribution.
• $df$ is the integer which is indicating the number of degrees of freedom and $t$ is indicating the number of distribution tails.
• Suppose t=1, then this distribution is One-Tailed Distribution and t=2, then this is Two-Tailed Distribution.
• Also t=1, then it is calculated as $TDIST=P(X>x)$, where $X$ is a random variable that follows the T-Distribution.
• And t=2, then it is calculated as $TDIST=P(X>xorX<-x)$.
• This function will return the result as error

     1. Any one of the argument is non-numeric. 
     2. df<1 and x<0. When we are giving $df$ and $t$ as a decimals, then it is changing in to integers.

Examples

1. =TDIST(1.82,55,1) = 0.037101192599
2. =TDIST(1.82,55,2) = 0.074202385199
3. =TDIST(5.9812,75,1)= 3.50350792266e-8
4. =TDIST(5.9812,75,2) = 7.007015845328e-8
5. =TDIST(2.4579,20.4,1) = 0.011612360861779858
6. =TDIST(2.4579,20.4,1.2) = 0.011612360861779858

See Also

• TTEST
• TINV

References

• Student's t-distribution