CONFIDENCE

CONFIDENCE margin of error of a confidence interval for the population mean

Synopsis

CONFIDENCE(alpha,stddev,size)

Arguments

alpha: significance level

stddev: population standard deviation

size: sample size

Note

This function requires the usually unknown population standard deviation. If size is non-integer it is truncated. If size < 0 this function returns a #NUM! error. If size is 0 this function returns a #DIV/0! error.

Microsoft Excel Compatibility

This function is Excel compatible.

See also

AVERAGE.