Reference no: EM131518433
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.
Attachment:- cluster_data.rar
|
Demonstrate steps performed in an apriori analysis
: The purpose of this assignment is to demonstrate steps performed in an Apriori analysis (i.e. Market Basket analysis).
|
|
Machine learning for generating css
: Is it possible to use machine learning for generating CSS?
|
|
Find the break-even point in unit sales
: Alpha Corporation reported the following data for its most recent year: sales, $610,000; variable expenses, $305,000; and fixed expenses, $244,000.
|
|
Raptor flowchart to display a sequence of numbers
: Develop a Raptor flowchart to display a sequence of numbers from 1 to N, whereby each number in the sequence, is equal to the sum of its two immediate.
|
|
Determine the ideal number of clusters
: Plot the data on a scatter plot. Determine the ideal number of clusters.Choose random center points (centroids) for each cluster.
|
|
Oem printer cartridge versus refilled cartridge
: Use Microsoft PowerPoint to make a presentation about "OEM Printer Cartridge Versus Refilled Cartridge".
|
|
What is the role of pharmaceutical marketing
: How has this regulatory change affected the market for pharmaceuticals? What is the role of pharmaceutical marketing within distribution control
|
|
Develop and arrange a minimum eight slide presentation
: For this assignment, you will need to develop and arrange a minimum eight slide PowerPoint presentation, not including title or reference slides.
|
|
What amount should griffin report in a board designated fund
: In June 2017, a public university bills and collects $30 million in tuition for the summer semester that runs from June 1 through July 15.
|