CFP last date
20 May 2024
Call for Paper
June Edition
IJCA solicits high quality original research papers for the upcoming June edition of the journal. The last date of research paper submission is 20 May 2024

Submit your paper
Know more
Reseach Article

Article:A Simple Approach to Clustering in Excel

by Aravind H, C Rajgopal, K P Soman
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

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

@article{ 10.5120/1595-2144,
author = { Aravind H, C Rajgopal, K P Soman },
title = { Article:A Simple Approach to Clustering in Excel },
journal = { International Journal of Computer Applications },
issue_date = { December 2010 },
volume = { 11 },
number = { 7 },
month = { December },
year = { 2010 },
issn = { 0975-8887 },
pages = { 19-25 },
numpages = {9},
url = { },
doi = { 10.5120/1595-2144 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
%0 Journal Article
%1 2024-02-06T19:59:55.946281+05:30
%A Aravind H
%A C Rajgopal
%A K P Soman
%T Article:A Simple Approach to Clustering in Excel
%J International Journal of Computer Applications
%@ 0975-8887
%V 11
%N 7
%P 19-25
%D 2010
%I Foundation of Computer Science (FCS), NY, USA

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.

  1. Ali, R., Ghali, U., Saeed, A. “Data Clustering and Its Applications”. Available at the web address :
  2. 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.
  3. 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
  4. Implementation of clustering in Excel and Excel Add-in to load Images. Available at the URL : .
  5. MacDonald, M. (2006), Excel 2007 : The Missing Manual.Published by Pogue Press, O’Reilly. ISBN:978-0-596-52759-4.
  6. 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
  7. 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
  8. 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

Computer Science
Information Sciences


Data clustering K-Means Image Segmentation Excel add-in to read image Microsoft Excel