Table of contents
TOC
Collapse the table of content
Expand the table of content

CONFIDENCE.T Function (DAX)

Owen Duncan|Last Updated: 10/5/2018
|
1 Contributor

Returns the confidence interval for a population mean, using a Student's t distribution.

Syntax

CONFIDENCE.T(alpha,standard_dev,size)  

Parameters

TermDefinition
alphaThe significance level used to compute the confidence level. The confidence level equals 100*(1 - alpha)%, or in other words, an alpha of 0.05 indicates a 95 percent confidence level.
standard_devThe population standard deviation for the data range and is assumed to be known.
sizeThe sample size.

Return Value

Returns the confidence interval for a population mean, using a Student's t distribution.

Remarks

If any argument is nonnumeric, CONFIDENCE.T returns the #VALUE! error value.

If alpha ≤ 0 or alpha ≥ 1, CONFIDENCE.T returns the #NUM! error value.

If standard_dev ≤ 0, CONFIDENCE.T returns the #NUM! error value.

If size is not an integer, it is rounded.

If size equals 1, CONFIDENCE.T returns #DIV/0! error value.

Example

FormulaDescriptionResult
=CONFIDENCE.T(0.05,1,50)Confidence interval for the mean of a population based on a sample size of 50, with a 5% significance level and a standard deviation of 1. This is based on a Student's t-distribution.0.284196855
© 2018 Microsoft