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.

  • $\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

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.