Difference between revisions of "Manuals/calci/NORMINV"

Latest revision as of 16:21, 10 August 2018

NORMINV (Probability,Mean,StandardDeviation)

$Probability$ is the probability corresponding to the Normal Distribution.
$Mean$ is the Mean value.
is the Standard Deviation.
- NORMINV(),returns the inverse of the normal cumulative distribution.

Description

This function gives the inverse of the Normal Cumulative Distribution for the particular Mean and Standard Deviation.
If $NORMDIST(Number,Mean,StandardDeviation,Cumulative,accuracy)=Probability$ , then $NORMINV(Probability,Mean,StandardDeviation)=Number$ .
$NORMINV$ using the iterating method to find the value of a Number.
Suppose the iteration has not converged after 100 searches, then the function gives the error result.
In $NORMINV(Probability,Mean,StandardDeviation)$ , where $Probability$ is the corresponding probability of the Normal Distribution, $Mean$ is the Arithmetic Mean of the Normal Distribution and $StandardDeviation$ is the Standard Deviation of the Normal Distribution.
This function will return the result as error when

1.any one of the argument is non-numeric
2.Suppose Probability<0 or Probability>1
3. StandardDeviation<=0.

If Mean=0 and StandardDeviation=1, NORMINV uses the Standard Normal Distribution.

Examples

=NORMINV(0.01884908749,17.4,3.2) = 10.750011
=NORMINV(0.998742,5.4,2.3) = 12.349244172
=NORMINV(1,7.2,2.3) = NULL

References

Normal distribution

List of Main Z Functions

Z3 home

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''NORMINV(prob,m,sd)'''</div><br/>
+<div style="font-size:30px">'''NORMINV (Probability,Mean,StandardDeviation)'''</div><br/>
-*<math>prob</math>  is the probability  corresponding to the Normal Distribution, <math>m</math> is the Mean,  and <math>sd</math> is the Standard Deviation.
+*<math>Probability</math>  is the probability  corresponding to the Normal Distribution.
+*<math>Mean</math> is the Mean value.
+*<math>StandardDeviation</math> is the Standard Deviation.
+**NORMINV(),returns the inverse of the normal cumulative distribution.
 ==Description==
 *This function gives the inverse of the Normal Cumulative Distribution for the particular Mean and Standard Deviation.
-*If <math>NORMDIST(x,m,sd,TRUE)=prob</math>, then <math>NORMINV(prob,m,sd)=x</math>.
+*If <math>NORMDIST (Number,Mean,StandardDeviation,Cumulative,accuracy)=Probability</math>, then <math>NORMINV (Probability,Mean,StandardDeviation)=Number</math>.
-*<math>NORMINV</math> using the iterating method to find the value of x.
+*<math>NORMINV</math> using the iterating method to find the value of a Number.
 *Suppose the iteration has not converged after 100 searches, then the function gives the error result.
-*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 (Probability,Mean,StandardDeviation)</math>, where <math>Probability</math> is the corresponding probability of the Normal Distribution, <math>Mean</math> is the Arithmetic Mean of the Normal Distribution and <math>StandardDeviation</math> is the Standard Deviation of the Normal Distribution.
 *This function will return the result as error when
 .any one of the argument is non-numeric
-.Suppose <math>prob<0</math> or <math>prob>1</math>
+.Suppose Probability<0 or Probability>1
-.<math>sd<=0</math>.
+. StandardDeviation<=0.
-*If <math>m=0</math> and <math>sd=1</math>, NORMINV uses the Standard Normal Distribution.
+*If Mean=0 and StandardDeviation=1, NORMINV uses the Standard Normal Distribution.
 ==Examples==

Difference between revisions of "Manuals/calci/NORMINV"

Latest revision as of 16:21, 10 August 2018

Contents

Description

Examples

Related Videos

See Also

References

Navigation menu

Search