Case Study

K-Means Clustering with Excel

This case study introduces k-means clustering in two different Excel environments.

By Ron Guymon

Published

Green dots on a black backdrop

About this case study

This case study introduces k-means clustering in two different Excel environments. First, it walks through the calculations of k-means clustering by hand in a spreadsheet. Second, it presents a brief overview of VBA code for a macro to run k-means clustering, and then applies clustering to a larger (wider and longer) set of data.

Author

How to cite

"K-Means Clustering with Excel" by Ron Guymon. University of Illinois-Deloitte Foundation Center for Business Emerging Technologies. https://emergingtech.giesbusiness.illinois.edu/distributed-content/k-means-clustering-with-excel/. Licensed under CC BY-NC-SA 4.0.

Materials are shared under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 license.

  • Marathon’s Dilemma in Investing in the Future of Clean Fuels

    Case StudyPublished

    Learn how to build a decision tree in Excel, using NPV and expected monetary value, to choose between two low-carbon fuel investments under uncertainty.

    • Excel

  • Predicting Binary Outcomes: Application to Health

    Case StudyPublished

    Learn the differences between logit and linear probability models, and apply them to real-world data by estimating a model that predicts whether an individual has high blood pressure.

    • R

  • Data Storytelling for Business Analytics: Practical Applications

    Case StudyPublished

    Learning data visualization principles and techniques using Tableau and Python

    • Python
    • Tableau
University of Illinois-Deloitte Foundation Center for Business Emerging Technologies
Champaign, IL 61820
Email: EmergingTech@business.illinois.edu
Log In