skip to Main Content
The smarter way
to do assignments.

Please note that this is just a preview of a school assignment posted on our website by one of our clients. If you need assistance with this question too, please click on the Order button at the bottom of the page to get started.

This qnswer you have to do it on your own no copy from online source

Included with this assignment is an Excel spreadsheet that contains data with two dimension values.
The purpose of this assignment is to demonstrate steps performed in a K-Means Cluster analysis.
Review the “k-MEANS CLUSTERING ALGORITHM” section in Chapter 4 of the Sharda et. al. textbook for additional background.
Use Excel to perform the following data analysis.

Plot the data on a scatter plot.
Determine the ideal number of clusters.
Choose random center points (centroids) for each cluster. (Note:  Each student will select a different random set of centroids.)
Using a standard distance formula measure the distance from each data point to each center point.
Assign each data point to an initial cluster region based on closeness.
For each cluster calculate new center points.
Repeat steps 4 through 6 as a second pass.
Repeat steps 4 through 6 as a third pass.

Provide final answers on your Excel spreadsheet indicating your initial center points, second pass center points, and third pass center points.  You must submit your spreadsheet and these answers to receive full credit. 
You will use Excel to help with calculations, but only standard functions should be used (i.e. don’t use a plug-in to perform the analysis for you.)  You need to show your work doing this analysis the long way.  If you were to repeat steps 4 through 6, what will likely happen with the cluster centroids?  The rubric for this assignment can be viewed when clicking on the assignment link.
Here is a link to an example spreadsheet using a smaller data set.  It contains two tabs.  The first tab is the raw data.  The second tab contains the analysis that was performed.  Make sure that you use a different starting center points from the example.


Clicking on this button will take you to our custom assignment page. Here you can fill out all the additional details for this particular paper (grading rubric, academic style, number of sources etc), after which your paper will get assigned to a course-specific writer. If you have any issues/concerns, please don’t hesitate to contact our live support team or email us right away.

How It Works        |        About Us       |       Contact Us

© 2018 | Intelli Essays Homework Service®