question :

XLMiner Steps for k-Means Clustering

Step 1. Select any cell in the range of the data Step 2. Click the XLMiner Platform tab in the Ribbon Step 3. Click Cluster in the Data Analysis group Step 4. Click k-Means Clustering

Step 5. When the k-Means ClusteringStep 1 of 3 dialog box appears: In the Data source area, confirm the Worksheet:, Workbook:, and Data range: entries correspond to the appropriate data In the Variables area, select the checkbox for First Row Contains Headers In the Variables In Input Data box of the Variables area, select the variables Age, Income, and Children (pressing the Crtl key while selecting the variables will allow you to select them all at once) and click the > button to populate the Selected Variables box Click Next > Step 6. In the k-Means ClusteringStep 2 of 3 dialog box: Select the checkbox for Normalize input data In the Parameters area, enter 3 in the # Clusters box, and enter 50 in the # Iterations box In the Options area, select Random Starts: and enter 10 in the adjacent box In the Centroid Initialization box within the Options area, select the checkbox for Set Seed: and enter 12345 in the adjacent box Click Next > Step 7.In the k-Means ClusteringStep 3 of 3 dialog box, click Finish: In the Output Options area, select the checkboxes for Show data summary and Show distances from each cluster center Click Finish