CONFIDENCE

CONFIDENCE(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 is only available for backwards compatibility and should not be used.
* CONFIDENCE.NORM was added in Excel 2010 to replace this function.
* The confidence level equals 100*(1 - alpha)%.
* An alpha of 0.05 indicates a 95 percent confidence level.
* An alpha of 0.1 indicates a 90 percent confidence level.
* If any of the arguments are not numeric, then #VALUE! is returned.
* If "alpha" = 0, then #NUM! is returned.
* If "alpha" = 1, then #NUM! is returned.
* If "standard_dev" = 0, then #NUM! is returned.
* If "size" is not an integer, it is truncated.
* If "size" < 1, then #NUM! is returned.
* For the Microsoft documentation refer to support.microsoft.com

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