View Single Post
  #1   Report Post  
Loztrailia Loztrailia is offline
Junior Member
 
Posts: 1
Default 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