Wednesday, April 3, 2013

Plotting Dendogram of Cluster analysis results in Excel using RExcel

See the related posts on RExcel (for basic, Excel 2003 and Excel 2007) for basic information.

We discussed how we can use RExcel in previous posts. By implementing RExcel we can perform cluster analysis and generate Dendogram plots.

(1) First load R and then R commander to see R menu in Excel (see previous posts)

(2)  Now we need to load the data ( a variables in column and observations  in rows - here variables are V1 to V20 while Observations (subjects) are A1 to A30) - please refer to previous blogs on how to load data. Here by selecting data area, right click and put data in R. The provide name of data (here variability) in the box.

(4) Now under stastics menu, you have Dimension analysis -> cluster analysis -> Heirachical Clustering. You can then see the following input box. Now specify different parameters you want to use and plot dendogram to plot the dendogram. You need to select all variables that will be used to classify the observations, and then Click OK.

(5) Now you can see the dendogram plotted in  a R graphics window.

No comments:

Post a Comment