Reference no: EM131447692
Assignemnt
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.
1. Plot the data on a scatter plot.
2. Determine the ideal number of clusters.
3. Choose random center points (centroids) for each cluster. (Note: Each student will select a different random set of centroids.)
4. Using a standard distance formula measure the distance from each data point to each center point.
5. Assign each data point to an initial cluster region based on closeness.
6. For each cluster calculate new center points.
7. 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:- Cluster_Data.xlsx
|
Describe best way to present each person employment history
: Planning a Résumé, If you haven't begun your professional career yet or you are pursuing a career change, the employment history section on your résumé can sometimes be a challenge to write. A brainstorming session with your wise and creative clas..
|
|
Develop the rest of your presentation
: You are now ready to develop the rest of your presentation. Use research to explain your selected topic, and develop the content for the presentation with a strong conclusion.
|
|
Develop the skills to master practices of marketing
: Develop the skills to master the following course competencies:Apply theories, models, and practices of marketing.Integrate marketing analyses into general business management planning and decision making.Communicate in a manner that is professional ..
|
|
How different would this calculation look for a worker
: How different would this calculation look for a worker who earned $500,000 and lived in Vermont? This worker would face a state income tax rate of 9.5 percent and a federal income tax rate of 35 percent.
|
|
Determine the ideal number of clusters
: 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.)
|
|
Before and after marriage
: A woman marries her butler. She paid him $60,000 a year. They get married. She earns one million per year, both before and after marriage.
|
|
Develop your main idea with adequate and relevant support
: Write an essay that defines what it is to be a man or woman. Use examples from your experience to help define the concept.
|
|
Places on each bottle of water
: It is hot day, and Bert is thirsty. Here is the value he places on each bottle of water:
|
|
Why are businesses interested in bop markets
: Define BOP markets. Why are businesses interested in BOP markets? What are some examples of products developed to profitable serve BOP markets? Identify and explain 4 challenges of serving BOP markets
|