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

    Problems calculating Linest_b (way to high)

    Michael Ionkin

      Hello

       

      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_B_1.png

      Linest_B_2.png

      = Linest_M _ Linest_B _ Linest_R2

       

      y= Value

      x= TimeAxis

       

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

       

      Any suggestions?

      Thx in advance!

       

      //chesterluck