1 Reply Latest reply: Nov 28, 2013 2:50 AM by Michael Ionkin RSS

    Problems calculating Linest_b (way to high)

    Michael Ionkin



      I'm calculating a regression function for a chart. Im not using the integrated Forecast-Line as it is not calculated correctly due to a bug.

      Linest_M = -0.039 and it seems correct. But Linest_B where x and y are chosen exactly the same way as in Linest_M is way to high = 1640 (and should be 7)


      Am I doing sth terribly wrong?




      = Linest_M _ Linest_B _ Linest_R2


      y= Value

      x= TimeAxis


      Apropos, in the chart b seems to be correct...


      Any suggestions?

      Thx in advance!