Reference no: EM131229057
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.
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.
Attachment:- assign.rar
|
Claim for violation of the constitutional right
: Can a government employee state a claim for a violation of the constitutional right to privacy when she was required, as a job applicant, to sign an affidavit stating that she had not used tobacco products for one year prior to the application date?
|
|
Determining the network standards and protocols
: List and discuss at least three major ways your life has been impacted due to the ability to communicate over the Internet? What specific network standards and protocols do you use personally when communicating over the Internet?
|
|
What are the six main barriers to effective communication
: What are the six main barriers to effective communication? Which barriers are easiest to surmount? Why? please provide a different answer than the ones that have already been answered.
|
|
Status of building renovations
: We are happy to announce that the renovation of the lobby is not behind schedule. By Monday, October 9, we should be ready to open the west end of the lobby to limited traffic. The final phase of the renovation will be placing a new marble floor in f..
|
|
What will likely happen with the cluster centroids
: 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 throu..
|
|
Write response of attach documents
: You have to write response in each document at the end of each document. Read the document, comment on it impressively by choosing only two articles or journal related to the topic
|
|
What will be the investor aftertax income from cash dividend
: Assume in Stage IV that an investor owns 285 shares and is in a 15 percent tax bracket. What will be the investor's aftertax income from the cash dividend?
|
|
Create a 2d tm mode simulation that is 100 × 200 grid cells
: Can you think of a way to do this simulation with a hole that is less than one grid cell wide? We will revisit this problem in Chapter 12.
|
|
On the job success and professional success
: Using a single example or multiple examples from your professional life now and/or in the past, or from your research, answer the following questions. How do you use critical thinking in decision making and problem solving in your professional life? ..
|