Hi everyone,

Can someone please help with the forecast in Excel? Based on past 7 days of data, is it possible to forecast next 19 days?

As you can see from the data, weekend sales are low for all three products so I do need to factor in the 'day of the week'.

Should I be using the multiple regression? Any other method in Excel?

Day Product 1 Product 2 Product 3 Total
Thur___90_______43_______8_______140
Fri_____83______39________8_______131
Sat_____66______33________7_______106
Sun_____57______25________5_______86
Mon____73_______37________8______119
Tue____77_______38________7______122
Wed
Thur
Fri
Sat
Sun
Mon
Tue
Wed
Thur
Fri
Sat
Sun
Mon
Tue
Wed
Thur
Fri
Sat
Sun

There are only 6 days with data. Does ths mean, at first
one has to predict a value for the first Wednesday?

, is it possible to forecast next 19 days?
Just Copy&Paste, I suppose. You don't have additional
information other than from the first week, so AFICS
you have to predict that all Mondays will show 90/43/8.
The same with the other weekdays.

With kind regards

K.

 Tweet

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts