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

* The confidence interval is a range of values.
* Your sample mean, x, is at the center of this range and the range is x +- confidence interval
* If "alpha" <= 0 or "alpha" >= 1, then #NUM! is returned.
* If "standard_dev" <=, then #NUM! is returned.
* If "size" is not an integer, it is truncated.
* If "size" < 1, then #NUM! is returned.
* If any arguments are non-numeric, then #VALUE! is returned.
* You can use the CONFIDENCE.T function to return the confidence interval for a population mean using a t distribution.
* 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("text", 2.5, 50) = #VALUE!