Manuals/calci/NORMINV

NORMINV (Probability,Mean,StandardDeviation)

• $Probability$ is the probability corresponding to the Normal Distribution.
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Mean} is the Mean value.
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle StandardDeviation} 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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle NORMDIST (Number,Mean,StandardDeviation,Cumulative,accuracy)=Probability} , then Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle NORMINV (Probability,Mean,StandardDeviation)=Number} .
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle NORMINV (Probability,Mean,StandardDeviation)} , where Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Probability} is the corresponding probability of the Normal Distribution, Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Mean} is the Arithmetic Mean of the Normal Distribution and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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

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

Related Videos

NORMDIST AND NORMINV

See Also

• NORMDIST
• NORMSDIST
• NORMSINV

References

Normal distribution

• List of Main Z Functions

• Z3 home