The week's pick
Random Articles
Reseach Article
Article:A Simple Approach to Clustering in Excel
| International Journal of Computer Applications |
| Foundation of Computer Science (FCS), NY, USA |
| Volume 11 - Number 7 |
| Year of Publication: 2010 |
| Authors: Aravind H, C Rajgopal, K P Soman |
10.5120/1595-2144
|
Aravind H, C Rajgopal, K P Soman . Article:A Simple Approach to Clustering in Excel. International Journal of Computer Applications. 11, 7 ( December 2010), 19-25. DOI=10.5120/1595-2144
Abstract
Data clustering refers to the method of grouping data into different groups depending on their characteristics. This grouping brings an order in the data and hence further processing on this data is made easier. This paper explains the clustering process using the simplest of clustering algorithms - the K-Means. The novelty of the paper comes from the fact that it shows a way to perform clustering in Microsoft Excel 2007 without using macros, through the innovative use of what-if analysis. The paper also shows that, image processing operations can be done in excel and all operations except displaying an image do not require a macro. The paper gives a solution to the problem of reading an image in excel by introducing a user defined add-in. The paper also has explained and implemented image segmentation as an application of clustering. This paper aims at showing that Microsoft Excel is a great tool as far as technical learning is concerned for the fact that, it can implement almost all algorithms and processes, and is very successful in providing the first hand exposure to an novice student.
References
- Ali, R., Ghali, U., Saeed, A. “Data Clustering and Its Applications”. Available at the web address : http://members.tripod.com/asim_saeed/paper.htm
- Gao, J., Goodmen, Joshua T., Miao,J. “The Use of Clustering Techniques For Language Modeling”. International Jouranal for Computational Linguistics and Chinese Language Processing. Vol. 6, No. 1, pp 27-60.
- Gunnerson, E. and Wienholt, N. (2005), A Programmer’s Introduction to C # 2.0, Third Edition, Published by Apress. ISBN (pbk) : 1-59059-501-7
- Implementation of clustering in Excel and Excel Add-in to load Images. Available at the URL : http://cen.amritafoss.org/downloads/Books/DataMining/Worksheet/ .
- MacDonald, M. (2006), Excel 2007 : The Missing Manual.Published by Pogue Press, O’Reilly. ISBN:978-0-596-52759-4.
- Ragsdale, C. T. and Zobel, C. W. (2010), A Simple Approach to Implementing and Training Neural Networks in Excel. Decision Sciences Journal of Innovative Education, 8: 143–149. doi: 10.1111/j.1540-4609.2009.00249.x
- Soman, K.P., Loganathan, R., Ajay, V. Machine learning With SVM and Other Kernel Methods. Published by PHI Learning Private Limited. ISBN:978-81-203-3435-9
- Tang, H. (2008), A Simple Approach of Data Mining in Excel.IEEE Fourth International Conference Wireless Communications, Networking and Mobile Computing, doi : 10.1109/WiCom.2008.2679
Index Terms
Keywords