International Journal of Information Engineering and Electronic Business(IJIEEB)

ISSN: 2074-9023 (Print), ISSN: 2074-9031 (Online)

Published By: MECS Press

IJIEEB Vol.11, No.6, Nov. 2019

Efficient Predictive Model for Determining Critical Factors Affecting Commodity Price: The Case of Coffee in Ethiopian Commodity Exchange (ECX)

Full Text (PDF, 598KB), PP.32-36

Views:55   Downloads:6


Worku Abebe Degife, Abiot Sinamo

Index Terms

Commodity Price;Predictive Model;J48 decision tree


In this paper, we have focused on the data mining technique on market data to establish meaningful relationships or patterns to determine the determinate critical factors of commodity price. The data is taken from Ethiopia commodity exchange and 18141 data sets were used. The dataset contains all main information. The hybrid methodology is followed to explore the application of data mining on the market dataset. Data cleaning and data transformation were used for preprocessing the data. WEKA 3.8.1 data mining tool, classification algorithms are applied as a means to address the research problem. The classification task was made using J48 decision tree classification algorithms, and different experimentations were conducted. The experiments have been done using pruning and unpruning for all attributes. The developed models were evaluated using the standard metrics of accuracy, ROC area. The most effective model to determine the determinate critical factors for the commodity has an accuracy of 88.35% and this result is a good experiment result.
The output of this study is helpful to support decision-making activities in the area of the Ethiopia Commodity Exchange. The study support commodity suppliers to take care of the determinant factors work towards maintaining quality. Ethiopia Commodity Exchange (ECX), as the main facilitator of commodity exchanges, can also use the model for setting price ranges and regulations.

Cite This Paper

Worku Abebe Degife, Abiot Sinamo, " Efficient Predictive Model for Determining Critical Factors Affecting Commodity Price: The Case of Coffee in Ethiopian Commodity Exchange (ECX)", International Journal of Information Engineering and Electronic Business(IJIEEB), Vol.11, No.6, pp. 32-36, 2019. DOI: 10.5815/ijieeb.2019.06.05


[1]C. J. Santana-Boado, Leonela; Brading, ‘Commodity exchanges in a globalized economy’, no. September, pp. 1–8, 2000.

[2]M. A. Hernandez, S. Lemma, and S. Rashid, ‘The Ethiopian commodity exchange and the coffee market: Are local prices more integrated to global markets?’, no. April 2008, 2015.

[3]H. Patel and D. Patel, ‘A Brief survey of Data Mining Techniques Applied to Agricultural Data’, vol. 95, no. 9, pp. 6–8, 2014.

[4]T. Edition and T. C. Corporation, Introduction to Data Mining and. .

[5]M. Gandhi and G. Vishwavidyalaya, ‘Data mining Techniques for Predicting Crop Productivity – A review article’, vol. 4333, pp. 98–100, 2011.

[6]G. Marketos, K. Pediaditakis, and Y. Theodoridis, ‘Intelligent Stock Market Assistant using Temporal Data Mining’, pp. 1–11.

[7]D. Das and M. S. Uddin, ‘T he S Tock M arkeT’, vol. 4, no. 1, pp. 117–127, 2013.

[8]D. V. Setty, ‘A Review on Data Mining Applications to the Performance of Stock Marketing’, vol. 1, no. 3, pp. 33–43, 2010.

[9]S. Tiwari and A. Gulati, ‘Prediction of Stock Market from Stream Data Time Series Pattern using Neural Network and Decision Tree’, vol. 7109, pp. 99–102, 2011.

[10]S. Džeroski, ‘Relational data mining’, in Data Mining and Knowledge Discovery Handbook, Springer, 2009, pp. 887–911.

[11]K. V Nesbitt and S. Barrass, ‘Patterns in Stock’, pp. 45–55, 2004.

[12]Niketa Gandhi, Leisa Armstrong,” Applying Data Mining Techniques to predict yield of Rice in Humid Subtropical Climatic Zone of India”. 978-9-3805-44212/16/$31.00_c 2016 

[13]A.T.M Shakil Ahamed, Navid Tanzeem Mahmood, Nazmul Hossain, Mohammad Tanzir Kabir, Kallal Das, Faridur Rahman, Rashedur M Rahman,” Applying Data Mining Techniques to Predict Annual Yield of Major Crops and Recommend Planting Different Crops in Different Districts in Bangladesh”, 15978-1-4799-8676-7/15/$31.00 copyright 2015 IEEE SNPD 2015, June 1-3 2015, 

[14]A. M. Ticlavilca, D. M. Feuz, and M. Mckee, ‘Forecasting Agricultural Commodity Prices Using Multivariate Bayesian Machine Learning Regression by Andres M . Ticlavilca , Dillon M . Feuz , and Mac McKee’, 2010.

[15]M. P. Naeini, H. Taremian, and H. B. Hashemi, ‘Stock market value prediction using neural networks’, in Computer Information Systems and Industrial Management Applications (CISIM), 2010 International Conference on, 2010, pp. 132–136.

[16]H. Pan, C. Tilakaratne, and J. Yearwood, ‘Predicting Australian stock market index using neural networks exploiting dynamical swings and intermarket influences’, J. Res. Pract. Inf. Technol., vol. 37, no. 1, pp. 43–56, 2005.

[17]Monali Paul, Santosh K. Vishwakarma, Ashok Verma,” Analysis of Soil Behaviour and Prediction of Crop Yield using Data Mining Approach” ,2015 International Conference on Computational Intelligence and Communication Networks, 978-1-5090-0076-0/15 $31.00 © 2015

[18]Ramesh A. Medar,Vijay S. Rajpurohit, “A survey on Data Mining Techniques for crop yield prediction”, International Journal of Advance Research in Computer Science and Management Studies.Volume 2 , Issue 9, Sept 2014.