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

Regina Henschel created OFFICE-3948:
---------------------------------------

             Summary: 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
             Fix For: ODF 1.2 Errata 01, 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)