[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]