← Prev in month ← Prev in thread
Next in thread → Next in month →

[office-formula] Error in description of CONFIDENCE

From
Regina Henschel <>
Date
2009-05-02T13:53:40+00:00
ID
Thread
[office-formula] Error in description of CONFIDENCE
Hi members,

The description of CONFIDENCE contains an error.
Wrong:
Semantics: Calling this function is equivalent to calling NORMINV(1 - 
alpha / 2; 1; 0) * stddev / SQRT (size)

Correct:
Semantics: Calling this function is equivalent to calling NORMINV(1 - 
alpha / 2; 0; 1) * stddev / SQRT (size)

The second parameter of NORMINV is the mean, the third parameter is 
standard deviation. So for the inverse of a standard normal distribution 
the second parameter has to be 0, the third has to be 1.

kind regards
Regina
← Prev in month ← Prev in thread
Next in thread → Next in month →