forecasting expression

[didierodayo]

Hello,

I need some help with the sample table below, I am trying to get on what date the level will hit 100 which is the highest level or more.

I need to know how to write the script to populate the Estimated_highlvl_Date.

I have attached the excel sample as well.

Your help is appreciated

Thanks

[sunny_talwar]

How would be the estimate the rate of increase? I mean based on what criteria?

[didierodayo]

Hi Sunny,

I would like it based first on :

given the level is at x rate in y number of months/days it will hit the highest level or more by DATE???

That is the sort of concept am building in my mind I don't know if it is clear ?

[effinty2112 · Accepted solution]

Hi Didier,

               If we assume a linear model for the increase over time then using regression analysis:

=Date((100-LINEST_B(level,DATE))/LINEST_M(level,DATE))

gives a date of 9th Jan 2016 as the forecast of when level reaches 100.

Hope this helps.

Cheers

Andrew

[didierodayo]

Thanks Andrew, that is what I am trying to represent.