Documentation/Calc Functions/CONFIDENCE.T

Function name:
CONFIDENCE.T

Category:
Statistical Analysis

Summary:
Returns the (1-alpha) confidence interval for a Student's t-distribution.

Syntax:
CONFIDENCE.T(Alpha; StDev; Size)

Returns:
Returns a non-negative real number which is the confidence interval for a population mean with significance level as Alpha, standard deviation of population as StDev and size of population as Size,calculated using a Student's t distribution.

Arguments:
Alpha is a real number in range 0 to 1 or a reference to the cell containing that number which is the level of the confidence interval.

StDev is a positive real number or a reference to the cell containing that number which is the standard deviation for the total population.

Size is an integer value greater than equal to 1 or a reference to the cell containing that number which is the size of the total population.


 * If Alpha is less than equal to 0 or greater than equal to 1, then the function returns an error value.
 * If StDev is less than or equal to 0, then the function returns an error value.
 * If Size is not an integer than the function uses its floor value, i.e. it is truncated to an integer.
 * IF Size is less than or equal to 1, then the function returns an error value.

Additional details:
For more details on the CONFIDENCE.T function, check the confidence level, and Student's t-distribution by visiting [https://en.wikipedia.org/wiki/Confidence_interval Wikipedia] and Wikipedia2.

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/CONFIDENCE.NORM CONFIDENCE.NORM]

[[Special:MyLanguage/Documentation/Calc_Functions/CONFIDENCE.T CONFIDENCE.T]

ODF standard:
None

Equivalent Excel functions:
CONFIDENCE.T