Forecasting By Date

  • Thread starter Thread starter instereo911
  • Start date Start date
I

instereo911

If I have the following table

a b c

1 Monday 1350
2 Tuesday 1000
3 Wednesday 900
4 Thursday 700
5 Friday 800
6 Monday 1800
7 Tueday 1200
8 wednesday 600
9 thursday 750
10 Friday 800

And wanted to forecast the following week based on these numbers, how would i
do this. I tried the help on MExcel but couldn't understand how this play
into my situation. Any help would be great.

Thanks again everyone!
 
If you select all of the data and use the fill handle in the lower
right corner of the selection and fill down 5 rows you get...

11 Monday 800
12 Tuesday 765
13 Wednesday 731
14 Thursday 696
15 Friday 662

However, that doesn't appear to be a reasonable forecast
as Monday and Tuesday have much higher numbers than
the rest of the week. I would suggest just averaging the data
for each day over the past two weeks. So...

Monday 1,575
Tuesday 1,100
Wednesday 750
Thursday 725
Friday 800

--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"instereo911" <u27979@uwe>
wrote in message
If I have the following table
a b c
1 Monday 1350
2 Tuesday 1000
3 Wednesday 900
4 Thursday 700
5 Friday 800
6 Monday 1800
7 Tueday 1200
8 wednesday 600
9 thursday 750
10 Friday 800

And wanted to forecast the following week based on these numbers, how would i
do this. I tried the help on MExcel but couldn't understand how this play
into my situation. Any help would be great.
Thanks again everyone!
 
Back
Top