CONFIDENCE
Syntax:
CONFIDENCE ( alpha , standard-dev , size )
Description: Computes a value that can be used to construct a confidence interval for a population mean.
Arguments:
Name |
Type |
Description |
|---|---|---|
alpha |
number |
The significance level used to compute the confidence level. |
standard-dev |
number |
The population standard deviation for the data range. |
size |
number |
The sample size, truncated to an integer. |
Return Type and Value: number – A value that can be used to construct a confidence interval for a population mean.
However, if
alpha ≤ 0 or alpha ≥ 1,
#NUM!is returned.standard-dev ≤ 0,
#NUM!is returned.size < 1,
#NUM!is returned.
example: