Difference between revisions of "Manuals/calci/NORMSINV"
Jump to navigation
Jump to search
| Line 6: | Line 6: | ||
*In Normal Distribution formula, when the Mean is zero and the Standard Deviation is 1 then it is called Standard Normal Distribution. | *In Normal Distribution formula, when the Mean is zero and the Standard Deviation is 1 then it is called Standard Normal Distribution. | ||
*If <math> NORMSDIST(x)=prob</math>, then <math>NORMSINV(prob)=x</math>. | *If <math> NORMSDIST(x)=prob</math>, then <math>NORMSINV(prob)=x</math>. | ||
| − | *<math>NORMSINV</math> using the iterating method to find the value of x. | + | *<math>NORMSINV</math> using the iterating method to find the value of <math>x</math>. |
*Suppose the iteration has not converged after 100 searches, then the function gives the error result. | *Suppose the iteration has not converged after 100 searches, then the function gives the error result. | ||
*In <math>NORMSINV(prob)</math>, where prob is the probability value of the standard normal cumulative distribution. | *In <math>NORMSINV(prob)</math>, where prob is the probability value of the standard normal cumulative distribution. | ||
Revision as of 01:43, 7 January 2014
NORMSINV(prob)
- prob is the probability value.
prob is the probability value.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} 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 x} .
- 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(prob)} , where prob is the probability value of the standard normal cumulative distribution.
- This function will return the result as error when
, then 
.1.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 prob}
is non-numeric.
2.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 prob<0}
or 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 prob>1}
.
Examples
- =NORMSINV(0.9999975333) = 4.567600
- =NORMSINV(0.00241) = -2.818823592
- =NORMSINV(1) = Null
- =NORMSINV(0.00001) = -4.264890794