NORMSINV function
From Apache OpenOffice Wiki
< Documentation | How Tos
Spreadsheet Lookup functions
Measures of dispersion / spread
Probability and statistics
Correlation and line fitting
See also (in the Arrays Functions category); GROWTH, LINEST, LOGEST, TREND
Ranking
NORMSINV
Calculates the inverse of the NORMSDIST function.
Syntax:
NORMSINV(p)
- NORMSINV returns the value x, such that NORMSDIST(x) is p.
- It is equivalent to NORMINV(p; 0; 1).
Example:
NORMSINV(0.5)
- returns 0. Half of the standard normal distribution is below 0.
NORMINV(0.5; 0; 1)
- also returns 0.
Issues:
- The international standard ODFF regards this as a legacy function, preferring NORMINV.
See Also