Results 1 to 2 of 2

Thread: What forumula does Excel 2016 use to extend data series?

  1. #1
    Seeker montaguelord's Avatar
    Join Date
    Jun 2018
    Posts
    6
    Articles
    0
    Excel Version
    Excel 2016

    What forumula does Excel 2016 use to extend data series?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have a series of GDP data from various countries from 1990 to 2023. I need to extend the series to 2050 by dragging the lower right-hand corner of the selected series to 2050.
    Can anyone tell me what formula Excel 2016 uses to calculate (forecast) the series?
    Also, is there a way to change the way that the series are extended (forecasted) by, for example, using ARMA or ARIMA formulas?
    Thank you in advance for your help.

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,435
    Articles
    0
    Excel Version
    Office 365 Subscription
    Have a look at the FORECAST function: https://www.excel-easy.com/examples/forecast-trend.html
    Ali
    Enthusiastic self-taught user of MS Excel!

Tags for this 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
  •