CONFIDENCE

Name

CONFIDENCE —
CONFIDENCE(x,stddev,size)

Description

The CONFIDENCE function returns the confidence interval for a mean. @x is the significance level, @stddev is the standard deviation, and @size is the size of the sample.

If @size is non-integer it is truncated. If @size < 0 CONFIDENCE returns #NUM! error. If @size is 0 CONFIDENCE returns #DIV/0! error.

See also

AVERAGE