OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

office message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

Subject: [OASIS Issue Tracker] Commented: (OFFICE-3509) Public Comment:[FORMULA] Multiple regression in GROWTH

    [ http://tools.oasis-open.org/issues/browse/OFFICE-3509?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=22815#action_22815 ] 

Andreas Guelzow  commented on OFFICE-3509:

If we would want to discuss GROWTH with respect to ODF1.2 there is an additional issue with this function:

The description indicates that it performs an "exponential least squares fit". Neither OOo nor Gnumeric Does that. (I don't think Excel does it either.) The former appear to linearize an exponential regression equation for the data and then perform a (least squares) linear regression. Usually that yields results that are not the least square fit to an exponential function.

If this function were supposed to do what the function of the same name apparently does in OOo, one could refer to LOGEST as TREND refers to LINEST.

> Public Comment: [FORMULA] Multiple regression in GROWTH
> -------------------------------------------------------
>                 Key: OFFICE-3509
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-3509
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula
>    Affects Versions: ODF 1.2 CD 05
>            Reporter: Robert Weir 
> Copied from office-comment list
> Original author: Regina Henschel <rb.henschel@t-online.de> 
> Original date: 29 Oct 2010 13:15:27 -0000
> Original URL: http://lists.oasis-open.org/archives/office-comment/201010/msg00004.html

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]