• Type: Bug
    • Resolution: Unresolved
    • Priority: Major
    • ODF 1.2 Errata 01
    • Affects Version/s: ODF 1.2
    • Component/s: OpenFormula
    • None
    • 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.

       

            Assignee:
            Unassigned
            Reporter:
            Regina Henschel
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated: