Formula to predict future data
Hi,
I have a set of numbers, such as the ones below:
Date Hours worked
3 Dec -----18
10 Dec-----9
17 Dec ----24
24 Dec-----36
31 Dec-----7
7 Jan-------0
14 Jan-----19
My data goes back over the past 52 weeks and I need to predict what the data is likely to be over the coming 52 weeks. I have tried different formulas but they either don't work or give me figures that are gradually reducing.
Any help that anyone could offer would be really appreciated!
Thanks
|