inordertoviewtheoutputsfromxlstatproperly,youneed.docVIP

Using XLStat for K-Means Clustering You can download XLStat from . The student version is available for $50, and a free evaluation version (with all the required capabilities) is available for a 30 day period. XLStat provides a good tutorial on running “K-means clustering” using this software at: /en/support/tutorials/cluster2.htm. In order to view the outputs from XLStat properly, you need to first change the security settings in Excel. To do that, first select the “Excel Options” by clicking on the windows icon on the top left corner of Excel. Within Excel Options, select “Trust Center”, and within trust center select “Trust Center Settings” Within Trust Center settings, select the “Macro Settings” and check, “Trust access to Visual Basic Project”. Activate XLStat by clicking on the XLStat logo in the Excel Toolbar. This will activate the XLStat menu. You can choose “K-means clustering” from the options for “Analyzing Data” in the XLStat toolbar. Once you choose “K-means clustering” you will see a dialog box as below. In this dialog box, the “observations/variable table” option allows you to choose the data to be used for cluster analysis. Choose the 62 attitudinal questions for the 250 respondents from the “Psychograhic Data” sheet in the “Ford Ka (students)” file. Please Note that you will be choosing only the columns that have the answers to the 62 attitudinal questions and NOT the column containing the respondent number. You are choosing only the variables that form the basis for clustering, respondent number is not a clustering variable. Choose the “Determinant (W)” as the clustering criterion. You can choose other criterion also and the results do not change much. This is a popular and safe criterion for clustering. Details on this criterion are beyond the scope of this class. Specify the “Number of Classes (or clusters)” you want the “K-means clustering” algorithm to use. You would have to repeat the cluster an