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] (OFFICE-3948) index wrong in formulas for LINEST

    [ https://issues.oasis-open.org/browse/OFFICE-3948?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=70411#comment-70411 ] 

Patrick Durusau commented on OFFICE-3948:

Clone at https://issues.oasis-open.org/browse/OFFICE-3965 for ODF 1.2 Errata 01

> index wrong in formulas for LINEST
> ----------------------------------
>                 Key: OFFICE-3948
>                 URL: https://issues.oasis-open.org/browse/OFFICE-3948
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula
>    Affects Versions: ODF 1.2
>            Reporter: Regina Henschel
>            Priority: Major
>             Fix For: ODF 1.3
> The formulas for SS~resid~ and SS~reg~ and R2 have wrong index. 
> For example for case const=TRUE() it is
> {code:java}
> // SS_{resid} = sum from j=1 to k ((a+ sum from i=1 to n b_j x_{i j})-y_i)^2
> {code}
> but it should be
> {code:java}
> // SS_{resid} = sum from i=1 to k ((a+ sum from j=1 to n b_j x_{i j})-y_i)^2
> {code}
> The current version makes no sense because currently the index of b refers to the outer sum and the index of y refers to the inner sum.
> For the other cases see the proposal.
> Please Andreas, have a look.
> Â

This message was sent by Atlassian JIRA

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