CONFIDENCE Function
The CONFIDENCE function is one of the statistical functions. It is used to return the confidence interval.
Syntax
CONFIDENCE(alpha, standard_dev, size)
The CONFIDENCE 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 function.
Examples
The figure below displays the result returned by the CONFIDENCE function.
