CONFIDENCE.NORM

Syntax

CONFIDENCE.NORM(alpha,standard_dev,size)

Tutorial with example

In today’s video I will explain how to calculate confidence intervals in power bi and why they are useful.

Download example files:

Download the pbix and excel file here.

Remarks

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: