Back close

A Simple Approach to Clustering in Excel

Publication Type : Journal Article

Thematic Areas : Scientific reports

Authors : Dr. Soman K. P., Aravind Hanumanthaiah, C Rajgopal

Source : International Journal of Computer Applications (0975 – 8887), Volume 11, Number 7 (2010)

Campus : Coimbatore

School : School of Engineering

Center : Computational Engineering and Networking

Department : Computer Science

Year : 2010

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

Cite this Research Publication : Dr. Soman K. P., H, A., and Rajgopal, C., “A Simple Approach to Clustering in Excel”, International Journal of Computer Applications (0975 – 8887), vol. 11, 2010.

Admissions Apply Now