CONFIDENCE.NORM function
The CONFIDENCE.NORM function is one of the statistical functions. It is used to return the confidence interval for a population mean, using a normal distribution.
Syntax
CONFIDENCE.NORM(alpha, standard_dev, size)
The CONFIDENCE.NORM function has the following arguments:
| Argument | Description |
|---|---|
| alpha | The significance level used to compute the confidence level, a numeric value greater than 0 but less than 1. |
| standard_dev | The population standard deviation, a numeric value greater than 0. |
| size | The sample size, a numeric value greater than or equal to 1. |
Notes
How to apply the CONFIDENCE.NORM function.
Examples
The figure below displays the result returned by the CONFIDENCE.NORM function.
