Forecasting is an Art,Science,Social studies,Maths and more !
Use of trends can make forecasting easy ! And God's gift to corporate mankind can make it easier !( Well, I 'am referring to Excel)
However, the trend line in excel does not display the values it holds. Computing the values on excel is an extremely confusing stuff .
You need to use innumerable formulae in excel to arrive at the values.
Just to make the job easy, here I present a way to do it. I have also attached an excel file link in the presentation. You can download the same and use it.
Alternatively you can download it from my BOX: Trendlines.XLS
Computing trendline values in excel
 |
| From www.Forexmillion.com |
However, the trend line in excel does not display the values it holds. Computing the values on excel is an extremely confusing stuff .
You need to use innumerable formulae in excel to arrive at the values.
Just to make the job easy, here I present a way to do it. I have also attached an excel file link in the presentation. You can download the same and use it.
Alternatively you can download it from my BOX: Trendlines.XLS
Computing trendline values in excel