Trend Line

[tracycrown]

Dear all

Can someone help to explain how QV compute the b and m in trend line ?.

b : linest_b(Sales,t)

m : linest_m(Sales,t)

Thank you

Tracy

[Gysbert_Wassenaar · Accepted solution]

See attached qvw.

The linest_b differs a bit, because linest_b uses 0 as start of the x-axis, while the chart doesn't include 0 on the x-axis. If you set the x-axis of the chart to Continuous you get the same values.

[tracycrown]

Dear Mr Gysbert_Wassenaar

Thank you very much for your kind advice, I have learned something new from you.

Wishing you and your family a Happy, Healthy and Prosperous New Year 2019.

Best Wishes

Tracy 

[Gysbert_Wassenaar]

Thanks! Best wishes to you too, Tracy.