CONFIDENCE.NORM Function (DAX)

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

The CONFIDENCE.NORM function (DAX) returns the confidence interval for a population mean, using a normal distribution.

CONFIDENCE.NORM Formula Syntax

CONFIDENCE.NORM(
     alpha,standard_dev,size
)

How do you use the CONFIDENCE.NORM function?

CONFIDENCE.NORM function used the normal distribution to calculate and return the confidence interval for a population mean.

Related Blog Posts

Related Support Forum Posts

Understanding DAX Formula
Developing Complex Dax functions

Considerations when using the CONFIDENCE.NORM function

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

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

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

If size is not an integer, it is rounded.

If size < 1, CONFIDENCE.NORM returns the #NUM! error value.

If we assume alpha equals 0.05, we need to calculate the area under the standard normal curve that equals (1 – alpha), or 95 percent. This value is ± 1.96. The confidence interval is therefore:

Formula

Related Video Tutorials

Formula examples using the CONFIDENCE.NORM function

=CONFIDENCE.NORM(A2,A3,A4)

CONFIDENCE.NORM(0.5,B4,D5)

=CONFIDENCE.NORM(C3,C4,C5)

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.