Statistical Forecasting of Producer Price Index for Foods, Beverages and Tobaccos

  • L. О. Yashchenko National Academy of Agrarian Sciences of Ukraine


Food and beverage industry is the most significant industry for the Ukrainian economy: it accounts for nearly 1/4 in the total industrial sales, and nearly 1/5 in the total exports. This raises the importance of forecasting key indicators of the industry performance, with special emphasis on index of producer price for foods, beverages and tobaccos.

The objective of the paper is to show methodological tools for statistical forecasting for stationary and non-stationary dynamic series with monthly or quarterly periodicity by use of linear regression methods, chain substitutions and seasonal coefficients, which can be realized in MS Excel. The best method is chosen by indexes of producer price for foods, beverages and tobaccos, computed for January 2007 - September 2016.

Dynamic series are divided into stationary and non-stationary ones. A non-stationary dynamic series can consist of three main components: trend, seasonal component for monthly or quarterly data (cyclic component for yearly data), and irregular (random) component. Stationarity of a series is checked by Dickey - Fuller test. Each type of dynamic series uses its own methods of statistical forecasting: for a stationary series the method of chain substitution should be chosen, for a non-stationary series with a trend the linear regression will be the best, for a series with seasonal component the method of seasonal coefficients should be chosen, for a series with trend and seasonal component the method of seasonal coefficients should be used.

It is found by Dickey - Fuller test that the series of index of producer price for foods, beverages and tobaccos is a stationary one, i. e. the one requiring the method of chain substitutions for forecasting. Yet, all the three methods were approbated for illustration purposes. Index of producer price for foods, beverages and tobaccos is estimated by the three methods of statistical forecasting for the period of September - December 2016. The computations confirm practicability of the chain substitution method for forecasting stationary dynamic series. It is found that the most significant measure for assessing quality of the forecasts is correlation coefficient.


Download data is not yet available.


1. Yerina, А. М., & Yerin, D. L. (2014). Statystychne modeliuvannya ta proh nozuvann ia [Statistical modeling and forecasting]. Kyiv: KNEU [in Ukrainian ].

2. Mantsurov, D. I. (2014). Statystychne prohnozuvannia v systemi derzhavnoho planuvannia ta prohramuvannia rozvytku ekonomikv Ukrainy [Statistical forecasting in the system of state planning and programming of economic development of Ukraine ]. Modeliuvannia ta informatsiini systemy v ekonomitsi - Modeling and information systems in the economy, 90, 4-12 [in Ukrainian ].

3. Kulynych, R. O. (2014). Statystychne prohnozuvannia vykorystannia enerhetychnykh resursiv [Statistical forecasting of energy resources use ]. Statystyka Ukrainy - Statistics of Ukraine, 4, 11-18 [in Ukrainian ].

4. Bahatska, K. V, Sheremet, O. O., & Rozina Ya. E. (2016). Prohnozuvannia diialnosti pidpryiemstv kharchovoi promyslovosti v umovakh ryzyku [Forecasting of activity of the food industry enterprises at risk ]. Ekonomich nyi analiz. Zbirnyk naukovykh prats - Economic analysis. Collected papers. Ternopil: Ekonomichna dumka, Vol. 23, 2, 13-21 [in Ukrainian ].

5. Kasianova, V. A., Honcharova, О. M., & Hurska, O. A. (2014). Analiz ta prohnozuvannia obsiahiv vypusku produktsii kharchovoi promyslovosti Odeskoi oblasti [Analysis and forecasting of food products output in Odessa region]. Ekonomika kharchovoi promyslovosti - Economics of Food Industry, 1 (21), 11-17 [in Ukrainian ].

6. Nakaz Derzhstatu vid 21.12.2015 roku №365 “Pro zatverdzhennia metodyky rozrakhunku kvartalnoho vypusku tovariv ta posluh za vydamy ekonomichnoi diialnosti vidpovidno do KVED-2010” [The order of State Statistics Service of Ukraine of 21.12.2015 № 365 “The method of calculation of the quarterly output of goods and services by economic activity according to KVED 2010”]. Retrieved from http:// [in Ukrainian ].

7. Ofitsiinyi sait Derzhavnoi sluzhby statystyky Ukrainy [The official website of the State Statistics Service of Ukraine ]. Retrieved from [in Ukrainian ].

Abstract views: 67
PDF Downloads: 86
How to Cite
YashchenkoL. О. (2016). Statistical Forecasting of Producer Price Index for Foods, Beverages and Tobaccos. Statistics of Ukraine, (3(74), 25-32. Retrieved from