Linear Trendline based off existing series
Posted: Tue May 19, 2015 1:01 pm
Hi,
I am trying to create a series that contains the trendline values associated with another series. For example:
I have a quarterly series "z"; sample 1980 through 2015Q1. I would like to create series "z_trend" that contains the data that when graphed would display a linear trendline for series "z".
I want to program this so that each time I update "z" with new data and rerun the program it re-calculates the "z_trend".
How do I go about programming the calculation of the trendline?
Thanks in advance!
I am trying to create a series that contains the trendline values associated with another series. For example:
I have a quarterly series "z"; sample 1980 through 2015Q1. I would like to create series "z_trend" that contains the data that when graphed would display a linear trendline for series "z".
I want to program this so that each time I update "z" with new data and rerun the program it re-calculates the "z_trend".
How do I go about programming the calculation of the trendline?
Thanks in advance!