6 Replies Latest reply: Oct 9, 2012 11:25 AM by Swarup Malli

# Trend lines question

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

• ###### Trend lines question

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

• ###### Re: Trend lines question

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

• ###### Re: Trend lines question

Or if you just want to display the fit equation, you can check the "Show Equation" box on the chart Properties | Expressions tab.

• ###### Trend lines question

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.

• ###### Re: Trend lines question

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

• ###### Trend lines question

Kaushik, thank you for your reply. You can see the resolution to the question in my reply to Jonathan,