CONFIDENCE ( alpha , standard-dev , size )

Description: Computes a value that can be used to construct a confidence interval for a population mean.

Arguments:

Name	Type	Description
alpha	number	The significance level used to compute the confidence level.
standard-dev	number	The population standard deviation for the data range.
size	number	The sample size, truncated to an integer.

Return Type and Value: number – A value that can be used to construct a confidence interval for a population mean.

However, if

• alpha ≤ 0 or alpha ≥ 1, #NUM! is returned.

• standard-dev ≤ 0, #NUM! is returned.

• size < 1, #NUM! is returned.

[Example:

CONFIDENCE(0.4,5,12) results in 1.214775614
CONFIDENCE(0.75,9,7) results in 1.083909234

end example]