Attached Files:

Included delay this provision is an Excel spreadsheet that contains facts delay two configuration values.

The end of this provision is to reveal steps done in a K-Means Gathering decomposition.

Review the "k-MEANS CLUSTERING ALGORITHM" minority in Chapter 4 of the Sharda et. al. textbook for additional setting.

Use Excel to complete the subjoined facts decomposition.

1. Plot the facts on a strew devise.
2. Determine the imaginative number of gatherings.
3. Choose chance life subject-matters (centroids) for each gathering. (Note:  Each ward accomplish prime a unanalogous chance set of centroids.)
4. Using a trutination space formula appraise the space from each facts subject-matter to each life subject-matter.
5. Assign each facts subject-matter to an judicious gathering clime domiciled on influence.
6. For each gathering number new life subject-matters.
7. Repeat steps 4 through 6.

You accomplish use Excel to acceleration delay calculations, but barely trutination functions should be used (i.e. don't use a plug-in to complete the decomposition for you.)  You need to pretext your labor doing this decomposition the hanker way.  If you were to renew steps 4 through 6, what accomplish mitigated supervene delay the gathering centroids?  

Here is a connect to an stance spreadsheet using a smaller facts set.  It contains two tabs.  The chief tab is the raw facts.  The promote tab contains the decomposition that was done.  Make unfailing that you use a unanalogous starting life subject-matters from the stance.

Example Excel Analysis