forecast function help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

method - 05 Oct 2004 15:14 GMT

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

Reply to this Message

Frank Kabel - 05 Oct 2004 15:30 GMT

Hi
see your other post

Signature

--
Regards
Frank Kabel
Frankfurt, Germany

> This might seem a bit newbie but im having trouble with the forecast
> function.
>
> Say for example i have a collection of data for sales of each item

over

> a number of years:
>
[quoted text clipped - 17 lines]
> method's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15030
> View this thread: http://www.excelforum.com/showthread.php?threadid=266448

Reply to this Message

Bernard Liengme - 05 Oct 2004 15:38 GMT

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

Signature

Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in e-mail address

> This might seem a bit newbie but im having trouble with the forecast
> function.
[quoted text clipped - 15 lines]
> where to start?
> Any help would be great, thank you.

Reply to this Message