Manuals/calci/NORMSINV
NORMSINV (Probability)
- 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 value of the Probability.
- NORMSINV(),returns the inverse of the standard normal cumulative distribution.
Description
- This function gives the inverse of the Standard Normal Cumulative Distribution.
- In Normal Distribution formula, when the Mean is zero and the Standard Deviation is 1 then it is called Standard Normal Distribution.
- If , 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 NORMSINV (Probability)=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 NORMSINV} using the iterating method to find the value of 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 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 NORMSINV (Probability)} , 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 probability value of the Standard Normal Cumulative Distribution.
- This function will return the result as error when
1.Probability is non-numeric. 2.Probability<0 or Probability>1.
Examples
- =NORMSINV(0.9999975333) = 4.567600
- =NORMSINV(0.00241) = -2.818823592
- =NORMSINV(1) = #N/A (PROBABILITY >0 (OR) PROBABILITY < 1)
- =NORMSINV(0.00001) = -4.264890794
Related Videos
See Also
References