+ Reply to Thread
Results 1 to 2 of 2

Users registration forecast

  1. #1
    Registered User
    Join Date
    10-11-2016
    Location
    UK
    MS-Off Ver
    Microfort Office 365 ProPlus
    Posts
    1

    Users registration forecast

    Hello,

    Just a little help here please!!

    I am just trying to calculate a forecast for users registrations which will show in which day I will reach 100 users in the system and stop there. Any ideas on how I can do this?

    Thank you!

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,854

    Re: Users registration forecast

    Cannot provide any specific suggestions with so little information. Standard approach I would expect to see:

    1) Analyze historic data for trends. Do the trends look seasonal, linear, exponential, or whatever it happens to be.
    2) Quantify the trend -- usually some kind of regression type algorithm
    3) Use the result of (2) to extrapolate/forecast the desired value.

    Most of the time, the Excel programming parts are steps 2 and 3, assuming you already know how to do (1).
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. Convert 52 Week Rolling Forecast to Monthly Forecast
    By rainintl in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-04-2014, 07:24 PM
  2. Replies: 2
    Last Post: 01-26-2014, 07:57 AM
  3. Forecast Variance and Percent - need help with hours forecast
    By hoppythyme in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-27-2013, 11:15 AM
  4. Forecast Variance and Percent - need help with hours forecast
    By hoppythyme in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-24-2013, 08:37 PM
  5. Challenging Forecast Wape - Rolling 12 Month Sum Of Orders And Forecast
    By nguyeda in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-17-2013, 06:20 PM
  6. Replies: 0
    Last Post: 06-15-2005, 01:05 PM
  7. [SOLVED] Help - Automating a file.. Adding Users , Deleting users, Changing
    By Tim Harding in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-16-2005, 10:06 AM

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