[OASIS Issue Tracker] Commented: (OFFICE-3437) Should TRENDfunction really only perform a simple regression?

From
OASIS Issues Tracker <>
Date
2010-09-19T18:29:23+00:00
ID
2102089543.67591284920955029.JavaMail.tomcat55@mw00
Thread
[OASIS Issue Tracker] Commented: (OFFICE-3437) Should TRENDfunction really only perform a simple regression?
[ http://tools.oasis-open.org/issues/browse/OFFICE-3437?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=21294#action_21294 ] 

Patrick Durusau commented on OFFICE-3437:
-----------------------------------------

Andreas, yes, something should be. 

I suspect the "new X" in the equation just above it goes away. It probably (speaking with no personal knowledge) represents the offset. 

I am going to suggest that as a resolution. 

Do you think this needs discussion? 

> Should TREND function really only perform a simple regression?
> --------------------------------------------------------------
>
>                 Key: OFFICE-3437
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-3437
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula
>    Affects Versions: ODF 1.2 CD 05
>            Reporter: Andreas Guelzow 
>            Assignee: Andreas Guelzow 
>             Fix For: ODF 1.2 CD 06
>
>
> TREND as currently described in ODF1.2CD5 only performs a simple linear regression. This matches what Gnumeric's version currently does. Both Excel and OOo appear to permit a multiple linear regression. 
> Do we really want to restrict TREND to a simple linear regression? 

-- 
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