[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 (v7.7.2#77003)
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]