+ Reply to Thread
Results 1 to 2 of 2

Thread: Please help with the forecast using week days data

  1. #1
    Points: 4, Level: 1
    Level completed: 7%, Points required for next Level: 46

    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Question Please help with the forecast using week days data




    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?

    Thank you in advance!!

    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

  2. #2
    TS Contributor
    Points: 17,779, Level: 84
    Level completed: 86%, Points required for next Level: 71
    Karabiner's Avatar
    Location
    FC Schalke 04, Germany
    Posts
    2,542
    Thanks
    56
    Thanked 640 Times in 602 Posts

    Re: Please help with the forecast using week days data


    Can someone please help with the forecast in Excel? Based on past 7 days of data
    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.

+ Reply to Thread

           




Posting Permissions

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






Advertise on Talk Stats