I have monthly data for these prices from 2005-2018. However, I want to have an approximation for the next 5 years. Using TREND() function at excel worked for CPI as it has a "linear" trend but when it comes to GNL, Diesel or Brent I don't want to include in my study just a linear approximation (although I can assume that this price maintains overtime).

I don't have a great statistics background and for my purposes I need a simple approximation, if it's possible. Right now, I' reading about ARIMA that could be of great use.

New contributor
Diegov is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
  • $\begingroup$ This question is very broad, and I believe you would profit from reading an introductory level textbook. I recommend the excellent free online book Forecasting: Principles and Practice (2nd ed.) by Athanasopoulos & Hyndman. If afterwards you still have more specific questions, then please do ask them here. If you already have read such a textbook, please edit your question to make it more specific. Thank you! $\endgroup$ – Stephan Kolassa Feb 12 at 5:28

Your Answer

Diegov is a new contributor. Be nice, and check out our Code of Conduct.

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged or ask your own question.