+ Reply to Thread
Results 1 to 3 of 3

Predict the next number following a series of numbers

  1. #1
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Predict the next number following a series of numbers

    Hi all!
    I have a series of numbers for which I want to forecast the next number.
    So if my series of data would be: 10,20,30,40,50,60,70,80,90,100. Then the next number would be 110.
    What formula should I use to calculate the 110?
    Of course my real data won't be this regular.
    Cheers!
    Tsjallie




    --------
    If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!

    If you think design is an expensive waste of time, try doing without ...

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Predict the next number following a series of numbers

    smth like that____________
    Attached Files Attached Files

  3. #3
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: Predict the next number following a series of numbers

    Yep, exactly what I was looking for!
    Almost got there by myself, but was strugling with the extra parameters.
    Wasn't aware that the solution for that would be that obvious
    Thx!

+ 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. [SOLVED] predict the next occurrence of a variable series
    By argeedblu in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-03-2014, 03:31 PM
  2. [SOLVED] finding a partial series of numbers within a number
    By bzl in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 02-05-2014, 06:23 AM
  3. Predict Numbers based on known variables. Thanks in advance!
    By farnlc in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-12-2014, 11:01 AM
  4. Replies: 3
    Last Post: 09-19-2013, 06:59 PM
  5. To Predict 3-digit Numbers using Excel
    By MD507 in forum Excel General
    Replies: 6
    Last Post: 02-06-2008, 07:19 PM

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