Navigation:  Formula Reference > Spreadsheet Formula Functions >

CONFIDENCE.NORM

Previous pageReturn to chapter overviewNext page

 

This function returns 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