Documentation/Calc Functions/T.DIST.RT

From The Document Foundation Wiki
Jump to navigation Jump to search


Function name:

T.DIST.RT

Category:

Statistical Analysis

Summary:

Calculates right-tailed test values for the Student's t-distribution (often known more simply as just the t-distribution). The Student's t-distribution is often used to test a hypothesis about a population’s mean when the population’s standard deviation is not known. The Student’s t-distribution can be used with any statistic whose distribution is approximately normal.

Syntax:

T.DIST.RT(Number; DegreesFreedom)

Returns:

Returns a positive real number in the range 0 to 1 (exclusive) representing the total area under the right tail of the probability distribution function of the specified Student’s t-distribution, lying above the given Number.

Arguments:

Number is a real number or a reference to a cell containing that number which is the value for which the right-tailed test value for the Student's t-distribution is to be calculated.

DegreesFreedom is a positive integer value or a reference to the cell containing that number which is the number of degrees of freedom for the Student's t-distribution.

  • If DegreesFreedom is less than 1 then the function returns an error value.
  • If DegreesFreedom is a non-integer value then the function uses its floor value, i.e. it is truncated to an integer.

Additional details:

  • The formula for T.DIST.RT is:
Tdist.png

where

T.dist.png

Here, x is the Number, df is DegreesFreedom and tails is equal to 1.

  • It is such that T.DIST.RT(x ,y) = 0.5*T.DIST.2T(x, y) and that T.DIST.RT(x, y) = TDIST(x, y, 1) and that T.DIST.RT(x, y) = 1 – T.DIST(x, y, 1).
  • For more details about the Student's t-distribution, visit Wikipedia.

Examples:

Formula Description Returns
=T.DIST.RT(7;3) The function calculates the right-tailed Student's t-distribution for the given data. 0.002993127848854
=T.DIST.RT(5.8;1.5) The function calculates the right-tailed Student's t-distribution for the given data. Here DegreesFreedom is non-integer value 1.5 so the function truncates it to integer 1. 0.054346705732263
=T.DIST.RT(5.8;0.9) The function returns an error value since the DegreesFreedom is less than 1. Err:502
=T.DIST.RT(-5.8;1.5) The function calculates the right-tailed Student's t-distribution for the given data. Here DegreesFreedom is non-integer value 1.5 so the function truncates it to integer 1. 0.945653294267737

Related LibreOffice functions:

T.DIST

TDIST

T.DIST.2T

T.INV

T.INV.2T

T.TEST

TINV

TTEST

ODF standard:

None

Equivalent Excel functions:

T.DIST.RT