Hello -
I have seen a ton of posts on this topic but have yet to find a solution that actually works.
I plotted time series data on a graph and the trend line equation is showing as "y=1E+08x+1E+09"
Therefore I tried to get the actual value of the trend line by using this equation against my data but its not working.
For example based on this formula i got the following for the first 4 values in my time series
<tbody>
</tbody>
But according to the trend line on the graph by time series 3 i should have already hit 1,500,000,000 and the formula only returns 1,300,000,000
What am i doing wrong?
Thank you so much for your help. I have been trying to find a solution for this for hours already
I have seen a ton of posts on this topic but have yet to find a solution that actually works.
I plotted time series data on a graph and the trend line equation is showing as "y=1E+08x+1E+09"
Therefore I tried to get the actual value of the trend line by using this equation against my data but its not working.
For example based on this formula i got the following for the first 4 values in my time series
original data | data from the equation | |
1 | 1,124,041,004 | 1,100,000,000 (1*10^8)(1)+(1*10^9) |
2 | 1,353,546,669 | 1,200,000,000 (1*10^8)(2)+(1*10^9) |
3 | 1,592,063,714 | 1,300,000,000 (1*10^8)(3)+(1*10^9) |
4 | 1,477,367,226 | 1,400,000,000 (1*10^8)(4)+(1*10^9) |
<tbody>
</tbody>
But according to the trend line on the graph by time series 3 i should have already hit 1,500,000,000 and the formula only returns 1,300,000,000
What am i doing wrong?
Thank you so much for your help. I have been trying to find a solution for this for hours already