K Mean Clustering Workbook Guide

The document outlines a K Mean Clustering tutorial, providing data on distances between clusters and their respective coordinates. It includes instructions for using a workbook to perform clustering iterations and summarizes the results of cluster assignments. Additionally, it features a visual representation of centroids and data points related to the clustering process.

Uploaded by

Zlatan Mur

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as XLS, PDF, TXT or read online on Scribd

0% found this document useful (0 votes)

13 views2 pages

K Mean Clustering Workbook Guide

Uploaded by

Zlatan Mur

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as XLS, PDF, TXT or read online on Scribd

MedA MedB MedC MedD Cluster 1 Cluster 2

X 1 2 4 5 1 2
Y 1 1 3 4 1 1

DISTANCE MedA MedB MedC MedD

Cluster 1 0 1 3.605551 5
Cluster 2 1 0 2.828427 4.242641
sum of "Yes"
Cluster 1 Yes No No No 1
Cluster 2 No Yes Yes Yes 3

Cluster 1
Sum of X when Cluster1 equal Yes 1 1 new X
Sum of X when Cluster2 equal Yes 1 1 new Y
Cluster 2
Sum of Y when Cluster1 equal Yes 11 3.667 new X
Sum of Y when Cluster2 equal Yes 8 2.667 new Y

RED x and y are cordinates of centroids BLUE x and y are cordinates of

DATA
4.5

3.5

2.5

1.5

0.5

0
0.5 1 1.5 2 2.5 3 3.5 4 4.5 5 5.5
Step 1

Step 4 How to use this workbook?

1. Delete the word "Stop" in the following blue cell STOP
2. Press F9 for next iteration
3. Repeat step 2 until no change in the cluster
4. To restart, type any letter in the blue cell above and press F9

cordinates of How does the iteration work?

This worksheet contains No Macro
It uses Tools > Options > Calculation > Manual
Iteration is checked for Maximum Iteration = 1

4.5 5 5.5

K Mean Clustering
No ratings yet
K Mean Clustering
11 pages
K Means Tutorial
No ratings yet
K Means Tutorial
8 pages
K Means Clustering
No ratings yet
K Means Clustering
18 pages
K-Means Clustering Explained
No ratings yet
K-Means Clustering Explained
8 pages
K-Means Clustering Solved Example
No ratings yet
K-Means Clustering Solved Example
10 pages
K-Means Clustering Tutorial by Kardi
100% (1)
K-Means Clustering Tutorial by Kardi
12 pages
K-Means Clustering Example Explained
No ratings yet
K-Means Clustering Example Explained
8 pages
K-Means Clustering Explained
No ratings yet
K-Means Clustering Explained
28 pages
K-Means Clustering Explained
No ratings yet
K-Means Clustering Explained
11 pages
K-Means Clustering Step-by-Step Guide
No ratings yet
K-Means Clustering Step-by-Step Guide
2 pages
K Means Clustering
No ratings yet
K Means Clustering
5 pages
Kmeansexample
No ratings yet
Kmeansexample
8 pages
K-Means Clustering Explained with Example
No ratings yet
K-Means Clustering Explained with Example
14 pages
File 01
No ratings yet
File 01
3 pages
KMeans Worksheet
No ratings yet
KMeans Worksheet
14 pages
K-Means Clustering Explained
No ratings yet
K-Means Clustering Explained
13 pages
Understanding K-Means Clustering
No ratings yet
Understanding K-Means Clustering
12 pages
K-Means Clustering and Elbow Method
No ratings yet
K-Means Clustering and Elbow Method
22 pages
Part 1 Unit 5 Clustering K-Mean
No ratings yet
Part 1 Unit 5 Clustering K-Mean
34 pages
K-Means Clustering Explained
No ratings yet
K-Means Clustering Explained
13 pages
K-Means Clustering Explained with Examples
No ratings yet
K-Means Clustering Explained with Examples
10 pages
K-means Clustering Analysis Guide
No ratings yet
K-means Clustering Analysis Guide
16 pages
K-Means Clustering Explained
No ratings yet
K-Means Clustering Explained
24 pages
K-Means Clustering Mastery Guide 1. WHAT IS K-MEANS? (The Big Picture)
No ratings yet
K-Means Clustering Mastery Guide 1. WHAT IS K-MEANS? (The Big Picture)
3 pages
Notes W4L78
No ratings yet
Notes W4L78
4 pages
K-Mean Clustering Explained
No ratings yet
K-Mean Clustering Explained
3 pages
K-Means Clustering Explained
No ratings yet
K-Means Clustering Explained
9 pages
K-Means Clustering Explained
No ratings yet
K-Means Clustering Explained
18 pages
K-means Clustering Algorithm Overview
No ratings yet
K-means Clustering Algorithm Overview
17 pages
K-Means Clustering Explained
No ratings yet
K-Means Clustering Explained
10 pages
K-Means Clustering - Numerical Example
100% (1)
K-Means Clustering - Numerical Example
6 pages
K-Means Clustering Explained
No ratings yet
K-Means Clustering Explained
12 pages
Unsupervised Learning: K-Means & DBSCAN
No ratings yet
Unsupervised Learning: K-Means & DBSCAN
46 pages
Clustering and Distance Analysis of Points
No ratings yet
Clustering and Distance Analysis of Points
12 pages
ML Notes Imp
No ratings yet
ML Notes Imp
74 pages
Chapter 5 (5.2)
No ratings yet
Chapter 5 (5.2)
40 pages
K-Means Clustering: Iteration Example
No ratings yet
K-Means Clustering: Iteration Example
8 pages
K-Means Clustering Example with K=3
No ratings yet
K-Means Clustering Example with K=3
14 pages
Understanding K-Means Clustering Algorithm
No ratings yet
Understanding K-Means Clustering Algorithm
14 pages
K-Means Clustering Explained
No ratings yet
K-Means Clustering Explained
9 pages
K-Means Clustering Explained
No ratings yet
K-Means Clustering Explained
19 pages
K-Means Clustering Explained
No ratings yet
K-Means Clustering Explained
14 pages
Unsupesfwafarvised Learning
No ratings yet
Unsupesfwafarvised Learning
49 pages
K-Means Clustering Tutorial - Matlab Code
No ratings yet
K-Means Clustering Tutorial - Matlab Code
3 pages
Understanding K-Means Clustering Algorithm
No ratings yet
Understanding K-Means Clustering Algorithm
59 pages
K-Means Algorithm Steps Explained
No ratings yet
K-Means Algorithm Steps Explained
7 pages
EM Algorithm and K-Means Clustering
No ratings yet
EM Algorithm and K-Means Clustering
22 pages
ML 3 PPT Unit 3
No ratings yet
ML 3 PPT Unit 3
46 pages
K-Means Clustering Explained
No ratings yet
K-Means Clustering Explained
10 pages
K-Means Clustering Explained
No ratings yet
K-Means Clustering Explained
35 pages
K-Means Clustering Explained
No ratings yet
K-Means Clustering Explained
21 pages
K-Means Clustering Explained
No ratings yet
K-Means Clustering Explained
15 pages
Understanding K-Means Algorithm Steps
No ratings yet
Understanding K-Means Algorithm Steps
9 pages
Clustering
No ratings yet
Clustering
86 pages
K-Means Clustering Explained
No ratings yet
K-Means Clustering Explained
20 pages
K-Means Clustering on Cancer Data
No ratings yet
K-Means Clustering on Cancer Data
16 pages
Understanding K-Means Clustering Types
No ratings yet
Understanding K-Means Clustering Types
21 pages
Batman vs Superman: Abilities & Origins
No ratings yet
Batman vs Superman: Abilities & Origins
1 page
@BSI National Standards - Code of Conduct 2010 (EN)
No ratings yet
@BSI National Standards - Code of Conduct 2010 (EN)
16 pages
Job Interview Tips for B1-B2 Learners
No ratings yet
Job Interview Tips for B1-B2 Learners
6 pages
Evolution of Banking Technology in India
No ratings yet
Evolution of Banking Technology in India
31 pages
Grade 9 Science Curriculum Overview
No ratings yet
Grade 9 Science Curriculum Overview
2 pages
Unsupervised Gaussian Processes Overview
No ratings yet
Unsupervised Gaussian Processes Overview
203 pages
SkyTrak Illustrated Parts Manual
50% (2)
SkyTrak Illustrated Parts Manual
90 pages
Fluent-V6 2 01
No ratings yet
Fluent-V6 2 01
20 pages
Decline of Global Carnivores
No ratings yet
Decline of Global Carnivores
3 pages
Management Thoeries
No ratings yet
Management Thoeries
17 pages
Shillong Plateau Uplift in 1897 Earthquake
No ratings yet
Shillong Plateau Uplift in 1897 Earthquake
7 pages
Radical Candor Executive Summary
No ratings yet
Radical Candor Executive Summary
2 pages
Modern Japanese Housing Insights
No ratings yet
Modern Japanese Housing Insights
3 pages
Adams Bashforth Multi-Step Methods
No ratings yet
Adams Bashforth Multi-Step Methods
5 pages
Jasperreports Server Admin Guide - 8 PDF
No ratings yet
Jasperreports Server Admin Guide - 8 PDF
296 pages
Sunya IAS Bootcamp Schedule 2025
No ratings yet
Sunya IAS Bootcamp Schedule 2025
4 pages
Cadastral Surveying: Pre-Comp Plans Explained
No ratings yet
Cadastral Surveying: Pre-Comp Plans Explained
105 pages
Agreement for Travel Service Technology Transfer
No ratings yet
Agreement for Travel Service Technology Transfer
5 pages
MATLAB Conditional Statements Practice
No ratings yet
MATLAB Conditional Statements Practice
2 pages
Measuring Electric Field Strength E
100% (1)
Measuring Electric Field Strength E
4 pages
Data Analysis and Table Structure Guide
No ratings yet
Data Analysis and Table Structure Guide
5 pages
Stanford HCI Program Overview
No ratings yet
Stanford HCI Program Overview
4 pages
Tincani Et Al-2018-Integrated Environmental Assessment and Management
No ratings yet
Tincani Et Al-2018-Integrated Environmental Assessment and Management
2 pages
Date Prompt Filtering in Cognos 12
No ratings yet
Date Prompt Filtering in Cognos 12
7 pages
Understanding Physical Distribution Concepts
No ratings yet
Understanding Physical Distribution Concepts
13 pages
AIESEC Brand Color Guidelines
No ratings yet
AIESEC Brand Color Guidelines
4 pages
Daikin FTKS/FTXS Indoor Unit Specs
No ratings yet
Daikin FTKS/FTXS Indoor Unit Specs
31 pages
ETL Process in SQL Server SSIS Guide
No ratings yet
ETL Process in SQL Server SSIS Guide
11 pages
Alexandru Cerchez CV: Media & Project Management
No ratings yet
Alexandru Cerchez CV: Media & Project Management
5 pages
Calibration User Guide
No ratings yet
Calibration User Guide
8 pages

K Mean Clustering Workbook Guide

Uploaded by

K Mean Clustering Workbook Guide

Uploaded by

MedA MedB MedC MedD Cluster 1 Cluster 2

DISTANCE MedA MedB MedC MedD

RED x and y are cordinates of centroids BLUE x and y are cordinates of

Step 4 How to use this workbook?

cordinates of How does the iteration work?

You might also like