Difference between revisions of "Manuals/calci/TDIST"

From ZCubes Wiki
Jump to navigation Jump to search
Line 26: Line 26:
 
#=TDIST(2.4579,20.4,1) = 0.011612360861779858
 
#=TDIST(2.4579,20.4,1) = 0.011612360861779858
 
#=TDIST(2.4579,20.4,1.2) = 0.011612360861779858
 
#=TDIST(2.4579,20.4,1.2) = 0.011612360861779858
 +
 +
==Related Videos==
 +
 +
{{#ev:youtube|DTiegJgxvlQ|280|center|TDIST}}
  
 
==See Also==
 
==See Also==

Revision as of 15:15, 26 June 2015

TDIST(x,df,t),


  • 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 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 , where is a random variable that follows the T-Distribution.
  • And t=2, then it is calculated as .
  • 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  and  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

Related Videos

TDIST

See Also

References