
Part 2. MM4XL Tools > 2. Analytical Tools > Cluster Analysis > How to run Cluster Analysis Cluster AnalysisHow to run Cluster Analysis Tip:
From the MM4XL menu select Cluster Analysis and the window below displays.
In the Input range select the range, using your mouse, where the input data is stored, and select an Output range where to print the resulting output, starting at the upper left cell. If your data set does not have row and/or column labels, uncheck the corresponding option in the frame. The option Cluster data vertically changes the orientation of the Ward analysis. When unchecked, the analysis is done using input data by column, otherwise it is done using input data by row. The Normalize input data (Standardization) option is checked by default. For more information about standardizing data see later in this chapter. Clicking on the tab Kmeans or Wards method selects the respective clustering method. For the Kmeans method the Number of clusters is needed as input from the user. The frame Terminate Condition hosts two options for stopping the cluster algorithm from reiterating. Find exact solution stops when the best partitioning is reached and, default option, the user can stop the algorithm at the Best of n iterations. Each time the algorithm runs, items are assigned to a certain group and a new ratio (Inertia Between Group) / (Inertia Within Group) is computed. The highest ratio of all iterations is then chosen as the best partition. Tip: The Dispersion chart is a quick visual aid that shows how items are clustered in groups. Print cluster numbers prints, in the first available column beside the input data set, a new column of numbers corresponding to the cluster group each item belongs to.
The Wards method is very easy to run. The user can simply accept the default setting and click on the OK button. But one can also determine when and how to terminate the algorithm reiteration. The first option, Automatically, stops when all items are grouped in one cluster only. Alternatively, the user can stop the tool as the desired Number of groups is reached. The third option stops the algorithm when the desired Inertia level is reached. For using the latter two options, simply check the corresponding option and type an integer value in the input box. If you make an incorrect entry, MM4XL warns you, do not be afraid to try. Note: 