Forecasting Prices Of Chilli (dry) In Major Markets Of Andhra Pradesh And Telangana

0 Views

S.B. RAMYA LAKSHMI, I. BHAVANI DEVI AND G. MOHAN NAIDU*

Department of Agricultural Economics, S.V. Agricultural College, Tirupati – 517 502, A.P.

ABSTRACT

In this study, chilli (dry) prices in Guntur and Khammam markets of Andhra Pradesh and Telangana were examined by using ARIMA, trend analysis, decomposition fit, moving average, SES, DES, WMM, ANN models, by using 156 months data of market prices of Red chillies the period from April 2000-01 to 2012-13 of the market prices of red chilli. The ARIMA (1,0,0) was the most suitable model to forecasts red chilli prices in Guntur, while ARIMA (1,0,1) in Khammam markets. According to the forecasts, the price of chilli per quintal would be ranging from Rs. 6,818 to 6,647 in Guntur, whereas Rs. 6,539 to Rs. 6,262 in Khammam markest for the months from April to July 2013.

KEYWORDS:

Price forecasting, ARIMA, trend analysis, decomposition fit, Moving Average, SES, DES, WMM, ANN.

INTRODUCTION

Chilli known as “Universal Spice” is grown in almost all states in India. Among the spice crops grown in India, chilli is the major crop cultivated in 30 per cent of the area under spices (Ajjan et al. 2012). Andhra Pradesh, Telangana Maharashtra, Karnataka and Tamil Nadu account for about 75 per cent of total area as well as annual production of the country. During 2013-14 Andhra Pradesh and Telangana states occupied about 1/4th of the total area (26.46 per cent) contributing 63.70 per cent of production. India is also leading country in chilli exports.

Even though chilli occupies major position in Indian spices, there were very limited studies conducted in India and out of which most of those were concentrated on its cost of cultivation, price spread, marketing channels etc. Thus, keeping in view the importance of chillies there is a need to analyze the behaviour of prices.

Forecasting involves making estimates of the future values of variables of interest using past and current information. There are a number of methods to generate prediction using time series data. Mohan Naidu, Meena Kumari and Srikala (2014) studied behavior of market arrivals and prices of red chillies (Capsicum annuum). Kumuda Keerthi and Mohan Naidu (2013) applied ARIMA for forecasting monthly prices of tomato in Madanapalli market of Chittoor district. There exists a large number of papers studying time series forecasting

and comparing the results obtained from different forecasting techniques. Box and Jenkins (1970) first introduced the ARIMA model building methodology. Attempts were made during present study to develop model for chilli prices in selected markets.

Forecasting involves making estimates of the future values of variables of interest using past and current information. There are a number of methods to generate prediction using time series data. ARIMA and other models (trend analysis, Decomposition fit, Moving Average, SES, DES, WMM, ANN) were used for forecasting chilli prices. Hence the present study was undertaken with an objective of forecasting the prices of chillies.

MATERIALS AND METHODS

The study was undertaken with an objective to forecast prices of red chilli in selected markets of Andhra Pradesh. Purposive sampling technique was used to select the markets. The secondary data pertaining to monthly prices (Rs. Qtls)-1 of red chillies were collected from Guntur and Khammam Agricultural Market Committees. The data pertained to the period 2000-01 to 2012-13(13 years) and were analysed. To forecast future prices of chillies in the selected markets, ARIMA model, trend analysis, decomposition fit, moving average, single exponential smoothing, double exponential smoothing, Winter’s multiplicative and ANN models were employed Description of the model In general, an ARIMA model is characterized by the notation ARIMA (p, d, q) where p, d and q denote orders of auto-regression, integration (differencing) and moving average respectively. In ARIMA, time series is a linear function of past actual values and random shocks. A stationary ARIMA (p, q) process is defined by the equation

yt = 0 1 yt 1 2 yt 2 ……… p yt p 1 t 12 t 2 ……….q t qt (1)

where, yt is the response (dependent) variable at time t. yt 1, yt 2 ,……., yt p are the responses with time lags t-1, 1, 2 ,….., p are t-2,…….,t-p respectively.

the coefficients to be estimated. t is the error term at time t that represents the effects of variables not explained by the model; the assumptions about the error term are the same as those for the standard regression model. t 1 , t 2 ,………, t q are errors that represent the effect of variables not explained by the model.

The assumptions about the error term are the same as those for the standard regression model. 1 , 2 ,……., q are the coefficients to be estimated. Identification The foremost step in the process of modelling is to check for the stationarity of the series, as the estimation procedures are available only for the stationary series. There are two types of stationarity, viz., stationarity in ‘mean’ and stationarity in ‘variance’.

The visual examination of graph of the data, structure of autocorrelation and partial correlation coefficients help to check the presence of stationarity. Another way of checking for stationarity is to fit a first order autoregressive model for the raw data and test whether the coefficient ‘ 1 ’ is less than one. If the model is found to be non-stationary , stationarity is achieved by differencing the series.

If ‘Xt’ denotes the original series, the non-seasonal

The next step in the identification process is to find the initial values for the orders of non-seasonal parameters, p and q. They are obtained by looking for significance of autocorrelation and partial autocorrelation coefficients. There are no strict rules in choosing the initial values. Though sample auto correlation coefficients are poor estimates of population autocorrelation coefficients, still they are used as initial values while the final models are achieved after going through the stages repeatedly.

Estimation

At the identification stage, one or more models are tentatively chosen that seem to provide statistically adequate representations of the available data. Then precise estimates of parameters of the model are obtained by least squares. Standard computer packages like SAS,SPSS, MINITAB etc., are available for finding the estimates of relevant parameters using iterative procedures.

Diagnostics

Different models are obtained for various combinations of Auto Regressive and Moving Average individually and collectively .The best model is selected based on the following diagnostics:

a) Low Akaike Information Criteria (AIC) b) Insignificance of auto correlations for residuals (Q-tests)

(a) Low AIC: Akaike Information Criteria is given by = ( -2log L +2m) Where m = p+q and L is the likely hood function. Since -2 log L is approximately equal to {n(1+log 2 ) + n log 2 }, where 2 is the model MSE, AIC is written as AIC = {n (1+log 2) + n log 2m}

And because first term in this equation is a constant, it is omitted while comparing between models. As an alternative to AIC, sometimes Schwarz Bayesian Information Criteria (SBC) is also used which is given by

SBC = log (m log n) /n.

(b) Non-significance of autocorrelations of residuals (Q tests)

difference of first order is
Yt= Xt – Xt-1

After tentative model is fitted to the data, it is

important to perform diagnostic checks to test the adequacy of the model and, if need be, to suggest potential

improvements. One way to accomplish this is through the analysis of residuals. It has been found that it is effective to measure the overall adequacy of the chosen model by examining a quantity Q known as Box-Pierce statistic (a function of autocorrelations of residuals) whose approximate distribution is chi-square and is computed as follows:

Q = n   r 2 ( j)
(3)

Where summation extends from 1 to k with k as the maximum lag considered, n is the number of observations in the series, r(j) is the estimated autocorrelation at lag j; k can be any positive integer and is usually around 20. Q follows chi-square with (k-m1) degrees of freedom, where m1 is the number of parameters estimated in the model. A modified Q statistic is the Ljung-box statistic which is given by

Q  n(n  2)   r 2 ( j) /(n   j) (4)

The Q statistic is compared to critical value from chi-square distribution. If model is correctly specified, residuals should be uncorrelated and Q should be small (the probability value should be large). A significant value indicates that the chosen model does not fit well.

Forecasting

After the identification of the model and its adequacy check, it is used to forecast the prices of chilli for the next periods. Hence, we used the identified ARIMA model to forecast chilli prices for the months of April 2013 to July 2013.

Single Exponential Smoothing (SES)

Forecast requires only three pieces of data. The most recent actual, the most recent forecast and a smoothing constant. The smoothing constant (α) determines the weight given to the most recent past observations and therefore controls the rate of smoothing or averaging.

Ft = α Yt-1 + (1- α) Ft-1

The current forecast equals to a weighted average of the most recent actual value and the most recent forecast value. The first actual value is chosen as the forecast for the second period.

Ft = Ft-1 + α (Yt-1 – Ft-1)

It means that the current forecast is equal to the old forecast plus a fraction (α) of the error in the previous forecast, where α always lies between 0 and 1 (0.1 and 0.9). The best α should be the one to minimize the SSE or RSE. If greater weight is given to the most recent actual value, a high smoothing constant is chosen. This refers to as low smoothing. When α = 1 provides no smoothing because the forecast equals to the most recent actual value. This refers to the zero smoothing and becomes a one period MA.

Ft = Yt-1 (Naive model)
Derivation of Exponential Weight for the past actual
F = α Y + (1- α) F t-1 ; F t-1 = α Y
t-1 t-2
Ft-2 = α Yt-3 + (1- α) Ft-3; Ft-3 = α Yt-4
After substitution
Ft = α Yt-1 + (1- α) [α Yt-2 + (1- α) Ft-2]
Ft = α Yt-1 + (1- α) {α Yt-2 + (1- α) [α Yt-3 + (1- α) Ft-3]}
Finally,
= α Yt-1 + α (1- α) Yt-2 + α (1- α) 2Yt-3 + α (1- α) 3Yt-4
+……+ (1- α) Ft-”
where, (1- α)  Ft-  = 0
s
Ft = α   1  α  Yt  s 1
S  0
It simply states that the forecast in tth period is equal
to a weighted average of all past actual values and one
initial forecast (closer to zero).
All weights will be summed to 1 since
α
s
α   1  α 1
1- α
S 0
Brown’s Double Exponential Smoothing
Let S’ denotes a single smooth and S” denotes the
double smoothed value
S’t = α Yt + (1- α) S’t-1
S”t = α S’t + (1- α) S”t-1
at = S’t + (S’t – S”t ) = 2 S’t – S”t

where, at is the smoothed value of the end of period t
bt =
α-1 α
(S’t – S”t )
where, bt is the estimated trend of the end of the period t Therefore, the m-period forecast is Ft+m = at + m bt Same as the SES, the Double smoothing estimation also requires a starting value to initialize the formulae. The common methods for estimating the starting values for Browns exponential smoothing are as follows. Let S’t = S”t = Y1 a1 = Y1
b1 = 2 )Y(Y)Y(Y 3412 
Artificial Neural Networks (ANN) Model An ANN is a mathematical structure designed to mimic the information processing functions of a network of neurons in the brain. Each neuron, individually, functions in a quite simple fashion. It receives signals from other cells through connection points (synapses), averages them and if the average over a short of time is greater than a certain value, the neuron produces another signal that is passed on to other cells. It is the high degree of connectivity rather than the functional complexity of the neuron itself that gives the neuron its computational processing ability. Neural networks are very sophisticated modeling techniques, capable of modeling extremely complex functions. The neural network user gathers representative data and then invokes training algorithms to automatically learn the structure of the data. The methodology consisted of an Artificial Neural Network, trained with the well-known error back propagation learning algorithm, which has been successfully used in a number of forecasting applications. This is especially true in light of the fact that when we analyze a relatively small sample. Multilayer Perceptrons (MLPs) use a linear PSP function (i.e., they perform a weighted sum of their inputs) and a non-linear activation function. The standard activation function (sigmoid) was used in the study. To determine the appropriate configuration of the feed-forward network, several

parameters have been varied. The number of neurons in the hidden layer was determined automatically by adopting network complexity

RESULTS AND DISCUSSION

Residual analysis, ACF, PACF and also forecasted values in Guntur and Khammam markets are shown in Tables 1 and 2. The actual and forecasted values are shown in Figures 1 and 2.

Prices of chilli in Guntur Market

ARIMA model was estimated after transforming the price data of chillies into stationary series. The ACF and PACF values are presented in Table I. Based on ACF and PACF many models were tested. Finally model (1,0,0) was identified as the best model to forecast prices in Guntur market. The forecasted prices obtained from the model with the least difference between AIC and SBC were considered.

Both actual and predicted were done and it was compared with actual observations. The prices were

forecasted up to July 2013. The results of actual and predicted prices are illustrated in Fig 1. As can be seen from the graph the actual and forecasted prices of chillies were more or less closer. According to the forecasts, the price of chillies per quintal would be ranging from Rs. 6,818 to Rs.6, 647 per quintal for the months from April to July 2013 in Guntur market.

Prices of Chilli in Khammam Market

The particulars of forecasting of prices of chilli in Khammam market are presented here under. The ACF

and PACF vales are presented in Table 1. Based on ACF and PACF values many models were tested. Finally model (1,0,1) was identified as the best model to forecast prices in Khammam market.

The results of Actual and predicted prices are illustrated in Fig.2. As can be observed from the graph, there was not much variation between actual and forecasted prices in Khammam market. The price of chilli per quintal would be Rs. 6,539 to Rs. 6,262 for the period commencing from April to July 2013 in Khammam market.

Comparison of Forecasted Values with Real Time Prices for Chillies in Selected Markets

A comparision was made between the forecasted values obtained through various models viz. ARIMA, Trend Analysis, Decomposition Fit, Moving Average, Single Exponential smoothing (SES), Double Exponential smoothing (DES), Winters Multiplicative Method (WMM) and ANN, with those of real time prices for chillies in selected markets in order to find out the closeness of the forecasted values of different models with real time prices.

The results obtained through trend analysis were relatively closer in respect of Guntur market (Table 3). WMM and ANN models were better than the other models in respect of Khammam (Table 4). Najafi et al.(2007) reported that ANN had the lowest error in prediction of prices of different commodities.

CONCLUSION

From the results it can be observed that there was not much variation between actual and forecasted prices. Hence marketing information is an important tool for decision making at all the stages right from farm production to ultimate consumption for all the participants in marketing channel. Marketing information is essential for producers in market led production and is equally important for other market participants for trading and also for consumers. Therefore marketing information is to be provided to all the stakeholders at right time.

REFERENCES

  1. Ajjan, N., Raveendran, N., Raghu Ram, P., Bhavani Devi, I., Srikala, M., Ranganath, P.D and Balaji, T. 2012. Establishment and networking of agricultural market intelligence centres in India, Commodity report (Red Chillies).
  2. Box, G.E. and Jenkins, G.M. 1970, “Time series analysis:
  3. Forecasting and control”, Holden Day, San Francisco
  4. Kumuda Keerthi, P and Mohan Naidu, G. 2013. Forecasting monthly prices of tomato in Madanapalli market of Chittoor district. BIOINFOLET 10(1B):201-203.
  5. Mohan Naidu, G., Meena Kumari, V., and Srikala, M. 2014. Behaiour of market arrivals and prices of red chillies (Capsicum annuum). Plant Archives. 14(1): 511-519
  6. Najafi, B., Zibaei, M.; Sheikhi, M. H. and Tarazkar, M.H. 2007. Forecasting price of some Crop products in Pars province: application of artificial neural network.[Persian]. Journal of Science and Technology of Agriculture and Natural Resources. 11: 1(B), 501-512.
Join Us - Editorial Member Submit An Article Subscribe TO APJAS