[OFFICE-3948] index wrong in formulas for LINEST - OASIS Technical Committees Issue Tracker

XML

Word

Printable

Proposal:
Hide

Set in case of const=TRUE()

// SS_{resid} = sum from i=1 to k ((a+ sum from j=1 to n b_j x_{i j})-y_i)^2

// SS_{reg} = sum from i=1 to k ((a+ sum from j=1 to n b_j x_{i j})-overline y)^2

// R^2 = SS_reg over {sum from i=1 to k (y_i- overline y)^2}

and in case of const=FALSE()

// SS_{resid} = sum from i=1 to k ((sum from j=1 to n b_j x_{i j})-y_i)^2

// SS_{reg} = sum from i=1 to k (sum from j=1 to n b_j x_{i j})^2

// R^2 = SS_reg over {sum from i=1 to k y_i^2}
Show
Set in case of const=TRUE() // SS_{resid} = sum from i=1 to k ((a+ sum from j=1 to n b_j x_{i j})-y_i)^2 // SS_{reg} = sum from i=1 to k ((a+ sum from j=1 to n b_j x_{i j})-overline y)^2 // R^2 = SS_reg over {sum from i=1 to k (y_i- overline y)^2} and in case of const=FALSE() // SS_{resid} = sum from i=1 to k ((sum from j=1 to n b_j x_{i j})-y_i)^2 // SS_{reg} = sum from i=1 to k (sum from j=1 to n b_j x_{i j})^2 // R^2 = SS_reg over {sum from i=1 to k y_i^2}

The formulas for SS~resid~ and SS~reg~ and R2 have wrong index.

For example for case const=TRUE() it is

// SS_{resid} = sum from j=1 to k ((a+ sum from i=1 to n b_j x_{i j})-y_i)^2

but it should be

// SS_{resid} = sum from i=1 to k ((a+ sum from j=1 to n b_j x_{i j})-y_i)^2

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.