CONFIDENCE
Returns the confidence interval for a population mean. Replaced by CONFIDENCE.NORM.
Syntax
CONFIDENCE(alpha, standard_dev, size)
Parameters
- alpha: Required. The significance level used to compute the confidence level
- standard_dev: Required. The population standard deviation
- size: Required. The sample size
Example
=CONFIDENCE(0.05, 2.5, 50)