Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there a way to tell what the values are for a Linear Trend Line at the 2 extremes? (at start point and at end point as they are graphed on the chart)
One can easily tell the "trend" by looking st the line, but can it be given numericaly?
Thanks
Josh
HI,
What I understood from your requirement is that you need to show the values on the Trend line..?
Correct me if I am wrong and give us more clarification on what you want. If possible give example
Regards,
Kaushik Solanki
Hi
I don't think it is possible to get the linear values from the chart, but you can calculate the values using QV's statistical functions
linest_m() gives the slope of the linear fit (m in y = mx + b)
linest_b() gives the y intercept (b in y = mx + b)
Hope that helps
Jonathan
Or if you just want to display the fit equation, you can check the "Show Equation" box on the chart Properties | Expressions tab.
Thank you Jonathan, This helps as all I am trying to achieve is identifying winners v losers over time.
If slope is positive then it is a winner else if it is negative then it is a loser.
That definitely helps.
Kaushik, thank you for your reply. You can see the resolution to the question in my reply to Jonathan,
Jonathan,
Is it possible to find the formula the trendline is using.. i wanted to create an expression in the chart that mimics the trend line..
Is it possible...
Swarup