statistics help 2 | StudyDaddy.com
Included after a while this assignment is an Excel spreadsheet that contains facts after a while two mass values.
The scope of this assignment is to manifest steps effected in a K-Means Bunch resolution.
Review the "k-MEANS CLUSTERING ALGORITHM" minority in Chapter 4 of the Sharda et. al. textbook for added elucidation.
Use Excel to achieve the aftercited facts resolution.
- Plot the facts on a plant conspire.
- Determine the chimerical number of bunchs.
- Choose chance kernel summits (centroids) for each bunch. (Note: Each ward conciliate picked a incongruous chance set of centroids.)
- Using a plummet interspace formula value the interspace from each facts summit to each kernel summit.
- Assign each facts summit to an moderate bunch territory grounded on nearness.
- For each bunch estimate new kernel summits.
- Repeat steps 4 through 6.
You conciliate use Excel to succor after a while calculations, but simply plummet functions should be used (i.e. don't use a plug-in to achieve the resolution for you.) You scarcity to semblance your toil doing this resolution the desire way. If you were to quote steps 4 through 6, what conciliate slight fall after a while the bunch centroids? The rubric for this assignment can be viewed when clicking on the assignment be-mixed.
Here is a be-mixed to an sample spreadsheet using a smaller facts set. It contains two tabs. The chief tab is the raw facts. The avoid tab contains the resolution that was effected. Make positive that you use a incongruous starting kernel summits from the sample.