Excel Function : CONFIDENCE.NORM

Excel Function : CONFIDENCE.NORM

Category

Statistical

Description

Returns the confidence interval for a population mean

Microsoft Excel Reference Page

https://support.office.com/en-us/article/CONFIDENCENORM-function-7cec58a6-85bb-488d-91c3-63828d4fbfd4

Syntax and Description of the CONFIDENCE.NORM Excel Function

not working in excel 2016 I am trying to use the CONFIDENCE.NORM function in Excel 2016 but I am getting the error:

The get syntax for CONFIDENCE.NORM is =CONFIDENCE.NORM(alpha,sigma,x)

I am using the formula as follows: =CONFIDENCE.NORM(1.96,0.7,10.6,TRUE) The above formula should return 0.7373518 but I am getting the error. Why am

About CONFIDENCE.NORM Excel Function

=CONFIDENCE.NORM(alpha, sigma) Returns the confidence interval for a population mean, using a normal distribution, given a population standard deviation.