Hello guys
I have a time series of data as follows:
year production
2000 7085
2001 8680
2002 9409
2003 11365
2004 14361
2005 13682
2006 14303
2007 14845
2008 15526
2009 16262
2010 20779
2011 20983
2012 22967
2013 24499
2014 24913
2015 25546
2016 28720
2017 31640
2018 33681
I want to perform a forecast from 2019 to 2025. Which one should I do?
1. Should I use forecasting method as https://www.vensim.com/documentation/fn_forecast.htm? How to do so?
2. Or should I just apply a stock-flow mode (production as stock, and the rate will be calculated using excel)?
3. Or is there any other way to do so?
Thank you guys!
Forecast or What?
-
- Super Administrator
- Posts: 4590
- Joined: Wed Mar 05, 2003 3:10 am
Re: Forecast or What?
It's up to you what method you use. Given you are using PLE, the only way for you to get this data into Vensim is via a lookup table, so you can either use the forecast function or LOOKUP EXTRAPOLATE. But if you are more comfortable doing the forecast in Excel, you can do it there instead.
Advice to posters seeking help (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Units are important!
http://www.bbc.co.uk/news/magazine-27509559
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Units are important!
http://www.bbc.co.uk/news/magazine-27509559
Re: Forecast or What?
The FORECAST function is just trend-extrapolation, which is sometimes useful but often pretty dumb.
A more sophisticated approach would be to build a model that captures the driving forces for production, and fit the model to this data (by hand or by optimization). Then the model generates the forecast.
If this is just a small part of a larger system, the forecast function might be fine (and realistic, if managers forecast simplistically).
A more sophisticated approach would be to build a model that captures the driving forces for production, and fit the model to this data (by hand or by optimization). Then the model generates the forecast.
If this is just a small part of a larger system, the forecast function might be fine (and realistic, if managers forecast simplistically).
/*
Advice to posters (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Blog: http://blog.metasd.com
Model library: http://models.metasd.com
Bookmarks: http://delicious.com/tomfid/SystemDynamics
*/
Advice to posters (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Blog: http://blog.metasd.com
Model library: http://models.metasd.com
Bookmarks: http://delicious.com/tomfid/SystemDynamics
*/