CONFIDENCE.NORM

CONFIDENCE.NORM(alpha, standard_dev, size)

Returns the confidence interval for a population mean.

alpha	The significance level used.
standard_dev	The population standard deviation for the data range.
size	The size of the sample.

REMARKS

* This function was added in Excel 2010 to replace the CONFIDENCE function.
* For the Microsoft documentation refer to support.microsoft.com

	A
1	=CONFIDENCE.NORM(0.05, 2.5, 50) = 0.693
2	=CONFIDENCE.NORM(0.05, 2.5, 50.25) = 0.693
3	=CONFIDENCE.NORM(-1, 2.5, 50) = #NUM!
4	=CONFIDENCE.NORM(0.05, 0, 50) = #NUM!
5	=CONFIDENCE.NORM(1, 2.5, 50) = #NUM!
6	=CONFIDENCE.NORM("some text", 2.5, 50) = #VALUE!