CONFIDENCE.T Function (DAX)

How does the CONFIDENCE.T function (DAX) work?

The CONFIDENCE.T function (DAX) returns the confidence interval for a population mean, using a Student’s t distribution.

CONFIDENCE.T Formula Syntax

CONFIDENCE.T(
     alpha,standard_dev,size
)

How do you use the CONFIDENCE.T function?

CONFIDENCE.T function used a Student’s T-Distribution to calculate a confidence value that can be used to construct the confidence interval for a population mean, for a supplied probability and supplied sample size. It is assumed that the standard deviation of the population is known.

Related Blog Posts

Related Support Forum Posts

Understanding DAX Formula
Developing Complex Dax functions

Considerations when using the CONFIDENCE.T function

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.

Related Video Tutorials

Formula examples using the CONFIDENCE.T function

=CONFIDENCE.T(0.05,1,50)

=CONFIDENCE.T( 0.05, 0.07, 100 )

=CONFIDENCE.T(0.05,STDEV(A2:A10),9)

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI

DOWNLOAD

To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.