Manuals/calci/CONFIDENCE

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

File:Calci1.gif

---

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

---