forecast function help

  • Thread starter Thread starter method
  • Start date Start date
M

method

This might seem a bit newbie but im having trouble with the forecas
function.

Say for example i have a collection of data for sales of each item ove
a number of years:

item 2000 2001 2002 2003

1 3 4 5
2 4 3 2
3 2 2 4
4 3 1 5
5 4 1 6
6 2 2 4

i am asked to forcast the values for the year 2003. I have read an
looked at many examples on how to do this and still can't work ou
where to start?
Any help would be great, thank you
 
I will assume the entry Item is in A1 while the years are in B1:E1
That row 2 is empty
That the 1 (for item 1) is in A3 while the data is in B3:D3

In E3 enter =FORECAST($E$1,B3:D3,$B$1:$D$1)
Copy formula down to E8

But with such limited data do not place too much confidence on the results
If the numbers must be integers use =ROUND(FORECAST($E$1,B3:D3,$B$1:$D$1),0)

best wishes
 
Back
Top