Difference between revisions of "Manuals/calci/TDIST"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| − | <div style="font-size:30px">'''TDIST( | + | <div style="font-size:30px">'''TDIST(Number,DegreeOfFreedom,Tail), '''</div><br/> |
| − | *<math> | + | *<math>Number </math> is the numeric value to find the distribution. |
| − | *<math> | + | *<math> DegreeOfFreedom </math> is the degrees of freedom. |
| − | *<math> | + | *<math> Tail </math> is the number of tails. |
==Description== | ==Description== | ||
| Line 10: | Line 10: | ||
*This is the symmetric distribution like the Normal 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. | *It is used when making inferences about a population mean when the population standard deviation is not known. | ||
| − | *In <math> TDIST( | + | *In <math> TDIST(Number,DegreeOfFreedom,Tail)</math>, <math>Number </math> is the numeric value to find the value of the distribution. |
| − | *<math> | + | *<math> DegreeOfFreedom </math> is the integer which is indicating the number of degrees of freedom and <math> Tail </math> is indicating the number of distribution tails. |
| − | *Suppose | + | *Suppose Tail=1, then this distribution is One-Tailed Distribution and Tail=2, then this is Two-Tailed Distribution. |
| − | *Also | + | *Also Tail=1, then it is calculated as <math> TDIST=P(X>x) </math>, where <math> X </math> is a random variable that follows the T-Distribution. |
| − | *And | + | *And Tail=2, then it is calculated as <math> TDIST =P(X>x or X<-x) </math>. |
*This function will return the result as error | *This function will return the result as error | ||
1. Any one of the argument is non-numeric. | 1. Any one of the argument is non-numeric. | ||
| − | 2. | + | 2. DegreeOfFreedom<1 and Number<0. When we are giving <math>DegreeOfFreedom</math> and <math>Tail</math> as a decimals, then it is changing in to integers. |
==Examples== | ==Examples== | ||
Revision as of 15:29, 12 June 2018
TDIST(Number,DegreeOfFreedom,Tail),
- is the numeric value to find the distribution.
- is the degrees of freedom.
- is the number of tails.
is the numeric value to find the distribution.
is the degrees of freedom.
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 , is the numeric value to find the value of the distribution.
- is the integer which is indicating the number of degrees of freedom and is indicating the number of distribution tails.
- Suppose Tail=1, then this distribution is One-Tailed Distribution and Tail=2, then this is Two-Tailed Distribution.
- Also Tail=1, then it is calculated as , where is a random variable that follows the T-Distribution.
- And Tail=2, then it is calculated as .
- This function will return the result as error
, 
, where 
is a random variable that follows the T-Distribution.
. 1. Any one of the argument is non-numeric.
2. DegreeOfFreedom<1 and Number<0. When we are giving and as a decimals, then it is changing in to integers.
Examples
- =TDIST(1.82,55,1) = 0.037101192599
- =TDIST(1.82,55,2) = 0.074202385199
- =TDIST(5.9812,75,1)= 3.50350792266e-8
- =TDIST(5.9812,75,2) = 7.007015845328e-8
- =TDIST(2.4579,20.4,1) = 0.011612360861779858
- =TDIST(2.4579,20.4,1.2) = 0.011612360861779858
Related Videos
See Also
References