OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

 


Help: OASIS Mailing Lists Help | MarkMail Help

office-comment message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]


Subject: [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


[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]