This function returns the confidence interval for a population mean.

Syntax

CONFIDENCE(alpha,stdev,size)

Arguments

This function has these arguments:

Argument	Description
alpha	Alpha, significance level used in calculating confidence level, where confidence level is 100 times (1-alpha)%
stdev	Population standard deviation for the range
size	Number representing the size of the sample; if not an integer, the number is truncated

Data Types

Accepts numeric data for all arguments. Returns numeric data.

Examples

CONFIDENCE(0.5,B4,D5)

CONFIDENCE(0.5,R4C2,R5C4)

CONFIDENCE(0.05,3.5,150) gives the result 0.560106363

Version Available

This function is available in product version 1.0 or later.

See Also

AVERAGE | CHITEST | Statistical Functions