[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: [OASIS Issue Tracker] Updated: (OFFICE-2019) 6.17.32 GAUSS does notmake sense
[ http://tools.oasis-open.org/issues/browse/OFFICE-2019?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Andreas Guelzow updated OFFICE-2019: ------------------------------------- Proposal: 6.17.32 GAUSS Summary: Returns 0.5 less than the standard normal cumulative distribution Syntax: GAUSS( Number x ) Returns: Number Semantics: Returns NORMDIST(x;0;1;TRUE())-0.5 > 6.17.32 GAUSS does not make sense > --------------------------------- > > Key: OFFICE-2019 > URL: http://tools.oasis-open.org/issues/browse/OFFICE-2019 > Project: OASIS Open Document Format for Office Applications (OpenDocument) TC > Issue Type: Bug > Components: OpenFormula > Affects Versions: ODF 1.2 > Reporter: Andreas Guelzow > Assignee: Andreas Guelzow > Fix For: ODF 1.2 > > > Currently it says that: > ------------------------------------------------------------------------- > 6.17.32 GAUSS > Summary: Returns the standard normal cumulative distribution > Syntax: GAUSS( Number x ) > Returns: Number > Semantics: Returns NORMDIST(x;0;1;TRUE())-0.5 > ------------------------------------------------------------------------- > THis does not make sense: NORMDIST(x;0;1;TRUE()) is the standard normal cumulative distribution function. So GAUSS cannot be both that function and differ by 0.5! -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]