Manuals/calci/CONFIDENCE
Jump to navigation
Jump to search
CONFIDENCE (alpha, SD, n)
Where alpha is the significance level, SD is the population standard deviation for the data range and N is the sample size.
This function returns a value that can be use to construct a confidence interval for a population mean.
· CONFIDENCE returns the error value, when any argument is nonnumeric or alpha is less than or equal to 0 or grater than equal to 1.
· CONFIDENCE returns the error value when SD is less than or equal to 0 or n is less than 1.
CONFIDENCE
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 0.05 | 0.993883 | ||
| Row2 | 3 | |||
| Row3 | 35 | |||
| Row4 | ||||
| Row5 | 0 | |||
| Row6 | ||||
| Row7 |
AVEDEV (N1, N2...) Where N1, N 2 ... are positive integers.
Let’s see an example
CONFIDENCE (alpha, SD, n)
i.e. =CONFIDENCE (B2, B3, B4) is 0.9939