Ask Your Question
0

F.INV and FINV functions

asked 2018-01-15 00:51:25 +0100

updated 2018-01-15 00:51:54 +0100

I use Libre Office Calc Version: 5.1.6.2 and I have two seemingly equal functions in the list of statistical functions: F.INV and FINV (yet can't add screenshot). F.INV works as expected while FINV works as F.INV.RT. Function descriptions for FINV and F.INV at the online documentation are identical, except of Example section --- it is common for FINV and F.INV.RT. Why are there two functions doing (seemingly) the same thing and why are their names so obscured?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2018-01-15 03:21:05 +0100

Regina gravatar image

FDIST, F.DIST, FINV and F.INV are defined in OpenDocument format, F.INV.RT and F.DIST.RT are defined by Microsoft for Excel. The "INV"-functions are the inverse of the "DIST" functions. You need to look at the "DIST" functions for to get the definitions.

It is
FINV = LEGACY.FINV http://docs.oasis-open.org/office/v1....
F.INV = FINV http://docs.oasis-open.org/office/v1....
FDIST = LEGACY.FDIST http://docs.oasis-open.org/office/v1....
F.DIST = FDIST http://docs.oasis-open.org/office/v1....

F.DIST.RT https://support.office.com/en-us/arti...
F.INV.RT https://support.office.com/en-us/arti...

For using the f-distribution see a statistic textbook.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-01-15 00:51:25 +0100

Seen: 193 times

Last updated: Jan 15 '18