writer
5,435
edits
Changes
Jump to navigation
Jump to search
Line 9:
Line 9: − + − + − + − +
→Description
*In <math>NORMINV(prob,m,sd)</math>, where <math>prob</math> is the corresponding probability of the normal distribution, <math>m</math> is the arithmetic mean of the normal distribution and <math>sd</math> is the standard deviation of the normal distribution.
*In <math>NORMINV(prob,m,sd)</math>, where <math>prob</math> is the corresponding probability of the normal distribution, <math>m</math> is the arithmetic mean of the normal distribution and <math>sd</math> is the standard deviation of the normal distribution.
*This function will return the result as error when
*This function will return the result as error when
1. any one of the argument is nonnumeric
1.any one of the argument is non-numeric
2.Suppose prob<0 or prob>1
2.Suppose <math>prob<0</math> or <math>prob>1</math>
3.sd<=0.
3.<math>sd<=0</math>.
*If m=0 and sd=1,NORMINV uses the standard normal distribution.
*If <math>m=0</math> and <math>sd=1</math>, NORMINV uses the standard normal distribution.
==Examples==
==Examples==