Difference between revisions of "Documentation/How Tos/Calc: FINV function"
From Apache OpenOffice Wiki
< Documentation | How Tos
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
m |
||
Line 15: | Line 15: | ||
<tt>'''FINV(0.485657; 4; 5)'''</tt> | <tt>'''FINV(0.485657; 4; 5)'''</tt> | ||
: returns approximately 1. | : returns approximately 1. | ||
+ | |||
+ | === Issues: === | ||
+ | * The forthcoming international standard ODFF calls this function <tt>'''LEGACY.FINV'''</tt>, and defines a new <tt>'''FINV'''</tt> function. | ||
{{Documentation/SeeAlso| | {{Documentation/SeeAlso| | ||
Line 23: | Line 26: | ||
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | ||
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} | ||
− | |||
− | |||
− |
Revision as of 10:24, 2 March 2009
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 forthcoming international standard ODFF calls this function LEGACY.FINV, and defines a new FINV function.