Documentation/How Tos/Calc: NORMSINV function
From Apache OpenOffice Wiki
Calculates the inverse of the NORMSDIST function.
- NORMSINV returns the value x, such that NORMSDIST(x) is p.
- It is equivalent to NORMINV(p; 0; 1).
- returns 0. Half of the standard normal distribution is below 0.
NORMINV(0.5; 0; 1)
- also returns 0.
- The forthcoming international standard ODFF regards this as a legacy function, preferring NORMINV.