Trend lines question

[jduenyas]

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

[kaushiknsolanki]

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

[jonathandienst]

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    

[jonathandienst]

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

[jduenyas]

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.

[jduenyas]

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

[swarup_malli]

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