Linest_M brings different results when loaded Inline or with qvd

[Anonymous]

After trying to find the source of this error for some hours now i decided to ask you guys.

Im trying to calc b1 and b0 (through y=0) for a regression (slr).

After calculating the values I compared them to the output of a statistical software and they where different.

Then I loaded the table Inline and the results where correct.

I tried both to calc the b1 ; b0 in the script and in a diagramm. There was no difference.

I really dont know why it is like this.

Pls find attached the qvw and qvd. just change the path to qvd in the script to test it.

Cheers & thx in advance

//chesterluck

[Gysbert_Wassenaar · Accepted solution]

It has to do with the load order of the values. If you sort the data from the qvd by Menge you get the same results as from the inline load. This is related to the third parameter you used in the linest_m function.

[Anonymous]

super - that the mistake. It tried to order by before but failed due to trying order by on a qvd which is impossible.

thank you ver much

greetings chesterluck