CONFIDENCE
Definition:
This function returns confidence interval for a population mean.
Syntax:
CONFIDENCE(alpha,stdev,size)
Notes
Arguments
This function has these arguments:
| Argument | Description |
|---|---|
| alpha | Alpha, significance level used in calculating confidence level, where confidence level is 100 times (1-alpha)% |
| stdev | Population standard deviation for the range |
| size | Number representing the size of the sample; if not an integer, the number is truncated |
Data Types
Accepts numeric data for all arguments. Returns numeric data.
Step 1. To begin to use CONFIDENCE formula, start with the Excellentable you would like to edit..
Step 2. Then type the CONFIDENCE formula into the cell you have chosen to display the outcome:
Step 3. Excellentable will generate the outcome when hitting enter.
Live Excellentable Example
A
|
B
|
C
|
|
|---|---|---|---|
1
|
|||
2
|
|||
3
|
|||
4
|
|||
5
|
|||
6
|
|||
7
|
|||
8
|
|||
9
|
|||
10
|
