O'Reilly logo

Microsoft® Excel® 2010 Formulas & Functions Inside Out by Helmut Reinke Egbert Jeschke Sara Unverhau, Eckehard Pfeifer, Bodo Fienitz, and Jens Bock

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CONFIDENCE.NORM()/CONFIDENCE()

Note

In Excel 2010, the CONFIDENCE() function was replaced with the CONFIDENCE.NORM() function, and the CONFIDENCE.T() function was added to increase the accuracy of the results. To ensure the backward compatibility of CONFIDENCE.NORM() and CONFIDENCE.T(), the CONFIDENCE() function is still available.

Syntax. CONFIDENCE(alpha,standard_dev,size)

Definition. This function returns a value used to create a confidence interval for the expected value of a random variable. The confidence interval is a range of values. The sample mean x is at the center of this range, and the range is x ± CONFIDENCE.NORM().

For example, if x is the sample mean of delivery times for products ordered through the mail, x ± CONFIDENCE.NORM() is ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required