/

TDistCdf

[this page | pdf]

Function Description

Returns the cumulative distribution function of the Student’s t distribution. Provided for compatibility with TDIST, T.DIST (with cumulative parameter set to true), T.DIST.2T and T.DIST.RT functions in Microsoft Excel 2010 and later.

 

Note:

 

(a)  TDIST is only defined if  and as the Student’s t distribution is symmetric this means that TDIST (1 tailed) is  and TDIST (2 tailed) is

(b)  T.DIST.RT = 1 - T.DIST(cumulative=true)  and T.DIST(cumulative=true) = MnTDistCdf

(c)   If if  then TDIST (1 tailed) = T.DIST.RT and TDIST(2 tailed) = 2 * TDIST (1 tailed)

(d)  T.DIST.2T = TDIST (2 tailed)

 

Please also bear in mind that this function accepts non-integral values of nu whereas the corresponding Excel functions are limited to integral values.

 

Equivalent to calling MnProbDistCdf using as the distribution parameter “student's t”.

 


NAVIGATION LINKS
Contents | Prev | Next


Output type / Parameter details

Output type: Double
Parameter NameVariable TypeDescription
xDoubleValue at which evaluate cdf
nuDoubledegrees of freedom

Links to:

-          Interactively run function

-          Interactive instructions

-          Example calculation

-          Output type / Parameter details

-          Illustrative spreadsheet

-          Other Statistical functions

-          Computation units used


Note: If you use any Nematrian web service either programmatically or interactively then you will be deemed to have agreed to the Nematrian website License Agreement


Desktop view | Switch to Mobile