[OASIS Issue Tracker] (OFFICE-3948) index wrong in formulas for LINEST

[OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>]

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

Michael Stahl updated OFFICE-3948:
----------------------------------
    Component/s: Part 2 (Formulas)

> 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, Part 2 (Formulas)
>    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
(v7.7.2#77003)