+ Reply to Thread
Results 1 to 3 of 3

Predicting Future Periods based on Weekly Historic Data - Regression

  1. #1
    Registered User
    Join Date
    10-11-2012
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    45

    Predicting Future Periods based on Weekly Historic Data - Regression

    I am wanting to predict the 2016 Sales the data I want to base the prediction on is the 52 weeks data from 2015 and the first 25 weeks of data from 2016.

    For the 2016 year, I was planning on using a cumulative week to understand the trajectory and then use the line of best fit equation to assume the remaining of the year however using this method does not account for the learnings in 2015.

    Is there another method I could be using?
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Predicting Future Periods based on Weekly Historic Data - Regression

    Have you considered the Holt-Winters method?
    https://www.google.com/webhp?sourcei...d%20in%20excel
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Registered User
    Join Date
    10-11-2012
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    45

    Re: Predicting Future Periods based on Weekly Historic Data - Regression

    Quote Originally Posted by mikeTRON View Post
    Have you considered the Holt-Winters method?
    https://www.google.com/webhp?sourcei...d%20in%20excel
    Thanks mikeTRON ill have a look now. Much appreciated.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Future value with different payments in different periods
    By mikeasmel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-07-2016, 02:45 PM
  2. Replies: 1
    Last Post: 07-18-2014, 04:44 AM
  3. Regression - Predicting trends with LINEST
    By excelbuddy82 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-02-2013, 11:34 AM
  4. Replies: 3
    Last Post: 03-13-2012, 02:14 PM
  5. Forcasting, Predicting Future sales figures.
    By skate1991 in forum Excel General
    Replies: 1
    Last Post: 03-09-2012, 10:11 AM
  6. Estimate next months based on historic & future target
    By Pyogenesis in forum Excel General
    Replies: 1
    Last Post: 01-11-2011, 07:00 AM
  7. Predicting Sales Data in future!
    By nandhamnk in forum Excel General
    Replies: 10
    Last Post: 07-30-2009, 05:26 AM
  8. Replies: 1
    Last Post: 04-26-2009, 08:16 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1