Determine the ideal number of clusters

Assignment Help Management Information Sys

Reference no: EM131590831

Question: 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.

Reference no: EM131590831

Questions Cloud

Write a report to your private investment company : Write a report to your private investment company and explain your analysis and your recommendations. Provide a rationale for your decision.

Explain the denormalization functionality : Having an adequate data model to serve specific business needs of an organization is important. Evaluate the need for denormalization within an organization.

Design a class named triangle : Design a class named Triangle that extends GeometricObject - Construct a geometric object with color and filled value - A default constructor

State the number of images : State the number of images formed when an object is between two plane mirror placed in parallel.

Determine the ideal number of clusters : The purpose of this assignment is to demonstrate steps performed in a K-Means Cluster analysis.

Illuminated by light of wavelength : A 3.0-cm-wide diffraction grating has 2500 slits. It is illuminated by light of wavelength 590 nm.

Where discount or premium appear in financial statements : Wie Company has been operating for just 2 years, Where should a discount or premium appear in the financial statements

Create a presentation file using powerpoint : Create a presentation file using PowerPoint and then create a three- to five-minute screencast video of your presentation with pertinent audio.

How will the rapid advancements made in communication : How will the rapid advancements made in communication and technology impact leadership in your professional field?

User Account

All Pages