Topic: Data trend extrapolationSubscribe | Previous | Next
Matthew Davis 1/20/2017
Hello,
I am wondering if there is a simple way to do the following:
- If I have data for specified years - ex: Interp(2010,500,2020,600,2030,650)
- and I want to extrapolate the trend outwards to a future year - ex: Interp(2010,500,2020,600,2030,650) + extrapolate the trend from 2010-2030 out to 2050
I have searched through the built in functions and could not find one that does exactly this. The "LinDataTrend" was the closest I could find but the interpolation results are not desirable.
I have been doing this in excel and linking the file but I would like to know if there is a way to do it in LEAP with an expression.
Thank you,
Matthew
Emily Ghosh 1/20/2017
Hi Matthew,
LEAP does not have a built-in function that extrapolates values into the future based on a combination of historical and future data points. However, you can specify a growth rate at the end of the Interp function to grow values after the last data year. For example:
Interp(2010,500,2020,600,2030,650, 1.5%)
In this case, 1.5% is the calculated annual average growth rate between 2010 and 2030.
Hopefully this helps! If you have any other questions, just let us know.
Thanks,
Emily