Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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_M _ Linest_B _ Linest_R2
y= Value
x= TimeAxis
Apropos, in the chart b seems to be correct...
Any suggestions?
Thx in advance!
//chesterluck
Got it:
b=Linest_M*min(x_Axis)+Linest_B