Call for Paper - July 2023 Edition
IJCA solicits original research papers for the July 2023 Edition. Last date of manuscript submission is June 20, 2023. Read More

A Simple Approach to Clustering in Excel

International Journal of Computer Applications
© 2010 by IJCA Journal
Number 7 - Article 4
Year of Publication: 2010
Aravind H
C Rajgopal
K P Soman

Aravind H, C Rajgopal and K P Soman. Article:A Simple Approach to Clustering in Excel. International Journal of Computer Applications 11(7):19–25, December 2010. Published By Foundation of Computer Science. BibTeX

	author = {Aravind H and C Rajgopal and K P Soman},
	title = {Article:A Simple Approach to Clustering in Excel},
	journal = {International Journal of Computer Applications},
	year = {2010},
	volume = {11},
	number = {7},
	pages = {19--25},
	month = {December},
	note = {Published By Foundation of Computer Science}


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.


  • Ali, R., Ghali, U., Saeed, A. “Data Clustering and Its Applications”. Available at the web address :
  • 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 : .
  • 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