FINV function
From Apache OpenOffice Wiki
< Documentation | How Tos
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
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
FINV
Calculates the inverse of the FDIST function.
Syntax:
FINV(p; r1; r2)
- returns the value x, such that FDIST(x; r1; r2) is p.
- Parameters r1 and r2 (degrees of freedom) are positive integers.
- p must be greater than 0 and less than or equal to 1.
Example:
FINV(0.485657; 4; 5)
- returns approximately 1.
Issues:
- The international standard ODFF calls this function LEGACY.FINV, and defines a new FINV function.
See Also
