CONFIDENCE

Description Computes the confidence interval, assuming a normal distribution. The confidence interval is the portion of a value that appears after the +/-, for example, 10 +/- 2.1.

Syntax CONFIDENCE( , , n)

Argument Description

A number between zero and one indicating confidence level. For example, 0.05 represents a 95% confidence level. The relation of confidence level to is: Confidence level (as a percent) = 100 * (1 - ).

A number representing the population standard deviation for the range. It must be larger than zero.

n An integer larger than 1 indicating the sample size.

Argument	Description
	A number between zero and one indicating confidence level. For example, 0.05 represents a 95% confidence level. The relation of confidence level to is: Confidence level (as a percent) = 100 * (1 - ).
	A number representing the population standard deviation for the range. It must be larger than zero.
n	An integer larger than 1 indicating the sample size.

Equation where

Examples This function returns 0.69295089:

CONFIDENCE(0.05, 2.5, 50)

See Also NORMDIST, NORMINV, NORMSDIST, NORMSINV, STANDARDIZE