Formula to predict trends/outcomes

Helly,

In the attachment i wrote down an example of combinations of arrangements.

I used three different dates. In which the outcomes were available. The first three sheets.

Is there a possiblity to use excel to calculate a future outcome of the next month(Sheet 4). The figures are in a way linear, because the previous months are in it.

So it's possible for the future outcome to go up or stay the same. It can't be less then previous months.

See attachments.


It's about a holiday (combinations) of arrangements. So it'll be influenced by the date (because of holliday plannings), finance etc etc. But the last factors/variables we will use and test in SPSS and other programs.

The question is more: Is there a program/formula in excel which will predict the outcome in the last sheet with maybe a factor of outliners (this coincendence of a better salary in some parts/or the date that people will book a holiday). And how the formula would be formulated in the last sheet?

Hi,

Please use FORECAST formula for forecasting.