Descriptive statistics
The average price coffee was 22.62 ETB with standard deviation of 3.315 ETB per kilogram. The minimum and maximum average price of 1KG of coffee was 14.000 and 34.000 ETB, respectively (Table 1).
Trend analysis
Trend is general tendency to increase or decrease during a long period. In order to measure trend we have to eliminate seasonal time series data. As one can observe from the figure, price of coffee was increased by 3.72E-0.028 ETB for a unit change of time (in months). The best model was a model with minimum value of MAD which was 2.5536. Fig 1
Test of stationary
Time series plot
As it observed from Fig 1, there was increase or decrease in price change of coffee from the 2001 to 2010 year (
i.e. not stationary). Therefore, we have to change non-stationary time series in to stationary time series by taking the differences. The following graph showed that approximately stationary time series plot. Stationary time series would have no predictable patterns (no growth or decline in the data) in the long-term (Fig 2).
Augmented duchy fuller test (ADF)
The test result showed that the null hypothesis that the series in level contain unit root could not rejected because p-value was greater than α (5%) and there is a unit root in the data series. This means, there is no stationary time series data in levels (Table 2).
The test result Table 3 also showed that the null hypothesis that the series in level contain unit root be rejected because p-value was less than α (5%) and there is no unit root in the data series. This means, there is stationary time series data in 2
nd difference.
ARIMA model
We have the stationary time series after second order differencing. Now, the model that we are looking at is ARIMA (
p, 2,
q). We have to identify the model, estimate suitable parameters, diagnostic checking for residuals and finally achieve our objective of forecasting the future price change of coffee in Mettu town.
Model identification
After suitably transforming of the data, the next step Firstly, we compute ACF and PACF of the stationary series which consists of the sample ACF and PACF values. The parameters of ARIMA consist of three components: p (Autoregressive parameter), d (number of difference) and q (moving average parameters). From these analyses it is possible to identify the order of AR (p) process and MA (q) process by plotting a correlogram (is the plot of the ACF against lag k) and partial correlogram, using R statistical software and the following graph was obtained. The graph showed that ACF to cut off to zero after lag 2 in moving average so it show statinarity of time series data after differencing (Fig 3).
The following (Fig 4) graph shows that the model identification is based on recognizable pattern of ACF and PACF. PACF is used to identify a tentative ARIMA model. The behavior of the partial autocorrelation coefficients (PACF) for the stationary time series, along with the corresponding ACF, is used to identify an uncertain ARIMA model.
Parameter estimation and model identification
The best model, using OLS method, was identified by using AIC which shows ARIMA (1,2,1) model was the best model because the value of AIC ARIMA (1,2,1) is minimum (622.5) as compared to other candidate model (Table 4).
Model diagnostics checking
ACF of residuals plot
A first step in diagnostic checking of fitted model is to observing residual plot and their ACF diagrams. The figure showed that the ACF plot of Residuals for price change of coffee which shows that neither of values break the confidence interval (95%); this implies the fixed mean with constant variance (Fig 5).
Normality checking
Normal probability plot is also one of the technique which checking diagnostic modeling of a given data. This indicate that the most of the residuals are not much far from the line showing randomness so, this implies that the fitted model ARIMA (1,2,1) was an appropriate (Fig 6).
Analysis of residual
From the following test statistic (Ljung-Box statistic), since all the p-values of lag are less than 5%, so the residual is independent and uncorrelated. This implies that, the selected model ARIMA (1, 2, 1) is an appropriate model for price change of coffee in study area (Table 5).
Forecasting
Forecasting is prediction which is used to determining what might happen to one particular item of interest such as price of coffee. ARIMA model for price we can check the accuracy of the forecasted value by using the above 95% confidence interval (CI) described as follows. All the forecast values are found between the lower and the upper interval then we can say that forecasted value is accurate (Table 6).