Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
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