Bug 116576 - UI, HELP: Wrong description of Function PHI: distribution function instead of density function
Summary: UI, HELP: Wrong description of Function PHI: distribution function instead of...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
Version:
(earliest affected)
6.0.2.1 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Help-Changes-Features
  Show dependency treegraph
 
Reported: 2018-03-23 01:51 UTC by Gilward Kukel
Modified: 2018-09-29 19:47 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Gilward Kukel 2018-03-23 01:51:52 UTC
Description:
The description of the function PHI in the function wizard and in the help is wrong. It says that it returns the values of the distribution function for a standard normal distribution. But it is the density function.

https://helponline.libreoffice.org/latest/en-US/text/scalc/01/04060184.html?DbPAR=CALC#bm_id3152806

Actual Results:  
 

Expected Results:
 


Reproducible: Always


User Profile Reset: No



Additional Info:
See also:
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1018744_715980110

https://support.office.com/en-us/article/phi-function-23e49bc6-a8e8-402d-98d3-9ded87f6295c?omkt=en-US&ui=en-US&rs=en-US&ad=US


User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:59.0) Gecko/20100101 Firefox/59.0
Comment 1 Mike Kaganski 2018-03-23 02:43:14 UTC
Confirming.

According to OASIS OpenDocument Version 1.2,

> PHI(N) is a synonym for NORMDIST(N,0,1,FALSE()).

> NORMDIST ... returns the value of the probability density function or the cumulative distribution function ...
>
> Syntax: NORMDIST( Number x ; Number Mean ; Number StandardDeviation [ ; Logical Cumulative = TRUE() ] )

When the Cumulative is FALSE() - as in PHI(N), - it returns the PDF; when TRUE(), it returns its integral (=CDF) - see https://en.wikipedia.org/wiki/Cumulative_distribution_function.

Gilward Kukel, thank you for the report; and you are welcome to submit a patch to correct this issue. This could be done online (in web UI) after you created an account at https://gerrit.libreoffice.org, and submitted a license statement according to https://wiki.documentfoundation.org/Development/Developers#License_Statements. This way, you can continue making corrections in the future as soon as you find an issue in documentation, have the corrections done immediately, and further contribute to benefit of all LibreOffice users.