Data Mining Application for the Performance of Indian Industries using Financial Ratios
Lakshmi R Priya and R Chandarasekaran. Article: Data Mining Application for the Performance of Indian Industries using Financial Ratios. IJCA Proceedings on International Conference on Communication, Computing and Information Technology ICCCMIT 2014(2):1-7, March 2015. Full text available. BibTeX
@article{key:article,
author = {R. Lakshmi Priya and R. Chandarasekaran},
title = {Article: Data Mining Application for the Performance of Indian Industries using Financial Ratios},
journal = {IJCA Proceedings on International Conference on Communication, Computing and Information Technology},
year = {2015},
volume = {ICCCMIT 2014},
number = {2},
pages = {1-7},
month = {March},
note = {Full text available}
}
Abstract
This paper examines the effectiveness of Data Mining and classification techniques in detecting Indian Industrial Performance (IIP) using financial ratios and deals with identification of factors associated to IIP. In this research paper, industries are split into five major groups and analyzed using traditional multivariate analysis and data mining techniques based on fourteen financial ratios. The present work is also intended to analyze financial performances of the five groups to understand financial scenario and to assess their financial strengths to enable the decision makers for future planning. The dataset relates to 445 companies of five major industrial sectors from Indian corporate database. The dataset comprises of important financial ratios of 78 companies from cement, 115 companies from steel, 102 companies from plastic, 66 companies from leather and 84 companies from hardware and software industries. The time frame of the data pertaining to the present study is 2001-2010. The salient feature of this study is the application of Factor Analysis, K-means clustering and Discriminant Analysis as data mining tools to explore the hidden structures present in the dataset for each of the study periods. Factor analysis is applied for Data Reduction and extraction of the hidden structure in the original data set. The financial ratios are used to find initial and final groups by k-means clustering algorithm. A few outlier industries, which could not be classified to any of the group, are discarded, as some of the ratios possessed unusual values. Finally, to cross validate the final clusters obtained by k-means algorithm, Discriminant Analysis is used to identify the industries as belonging to EP-Class (Elevated Performance), MP-Class (Moderate Performance) and SP-Class (Stumpy Performance). The results of the present study indicate that k-means clustering algorithm and Discriminant Analysis can be used as a feasible tool to analyse large set of financial data.
References
- Anderson T. W. (1984). An Introduction to Multivariate Statistical Analyis, 2/e, John Wiley and Sons, Inc. , New York.
- Altman, E. I. (1968). Financial ratios, Discriminant Analysis and the Prediction of Corporate Bankruptcy, Journal of Finance, 23(4), pp. 589-609.
- Altman, E. I. (1994). An international Survey of Business Failure Classification Models, N. Y. University Salomon Center, Volume 6, Number 2, 1997, p. 23.
- Deakin, E. 1972. A discriminant analysis of predictors of business failure. Journal of Accounting Research 10(1): 167-179.
- M. Kantardzic, "Data Mining: Concepts, Models, Methods, and Algorithms", the textbook, IEEE Press & John Wiley, (First edition, November 2002; Second Edition, August 2011).
- Chandrasekaran R, Manimannan G and Lakshmi Priya (2014). Assessing Indian industries on the basis of Financial Ratios using certain Data Mining Tools, International Journal of Statistika and Mathematika, India, Volume 9, Issue 2, 2014 pp 50-55.
- Chandrasekaran R, Manimannan G and Lakshmi Priya (2013), International Journal of Scientific & Engineering Research Volume 4, Issue 2, ISSN 2229-5518.
- Chandrasekaran R, Manimannan G and Lakshmi Priya (2014). IOSR Journal of Mathematics (IOSR-JM), e-ISSN: 2278-5728, p-ISSN:2319-765X. Volume 10, Issue 1 Ver. IV, PP 63-71
- Everitt, B. and Dunn, G. (2001). Applied Multivariate Data Analysis, 2nd Ed. , Hodder Arnold, New York.
- Beaver, W. H. (1966). Financial ratios as Predictors of Failure, Journal of Accounting Research, Vol 4. pp. 71-111.
- Hair, J. F. , Black, W. C. , Babin, B. J. , and Anderson, R. E. (2010). Multivariate Data Analysis, 7th ed. ,Prentice Hall, New York.
- R. O. Duda, P. E. Hart, and D. G. Stork. Pattern Classification. John Wiley & Sons, New York, 2001.
- R. A. Fisher. The use of Multiple Measurements in Taxonomic Problems. Annals of Eugenics, 7:179–188, 1936.
- K. Fukunaga. Introduction to Statistical Pattern recognition. Academic Press, San Diego, CA, 1990.