Difference between revisions of "Documentation/How Tos/Calc: NORMSINV function"

Revision as of 23:53, 1 June 2013

CALC FUNCTIONS

FUNCTIONS

Measures of Central Tendency

Measures of dispersion / spread

Probability and statistics

Correlation and line fitting

See also (in the Array Function category); GROWTH, LINEST, LOGEST, TREND

Ranking

Calculates the inverse of the NORMSDIST function.

NORMSINV(p)

NORMSINV returns the value x, such that NORMSDIST(x) is p.

It is equivalent to NORMINV(p; 0; 1).

NORMSINV(0.5)

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.

@@ Line 4: / Line 4: @@
 |ShowParttitle=block|parttitle=[[Documentation/How_Tos/Calc:_Statistical_functions|<div style="font-size: 140%;">Statistical Functions]]
 |ShowNextPage=block|NextPage=Documentation/How_Tos/Calc:_NORMSDIST_function
-|ShowPrevPage=block|PrevPage=Documentation/How_Tos/Calc:_MORMDIST_function
+|ShowPrevPage=block|PrevPage=Documentation/How_Tos/Calc:_NORMDIST_function
 |ShowPrevPart=block|PrevPart=Documentation/How_Tos/Calc:_Spreadsheet_functions
 |ShowNextPart=block|NextPart=Documentation/How_Tos/Calc:_Text_functions