This function returns the confidence interval for a population mean.

Syntax

CONFIDENCE.NORM(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

Remarks

The #VALUE! error value is returned if any argument is nonnumeric. The #NUM! error value is returned if size < 1.

Data Types

Accepts numeric data for all arguments. Returns numeric data.

Examples

CONFIDENCE.NORM(0.5,B4,D5)

CONFIDENCE.NORM(0.5,R4C2,R5C4)

CONFIDENCE.NORM(0.05,3.5,150) gives the result 0.5601063629983405

Version Available

This function is available in Spread for Windows Forms 11.0 or later.

See Also

CONFIDENCE