How To Do Hierarchical Clustering For A Column In Excel?

Question

[grosy]

Hi friends,

I have few values with few numbers, now i want to do hierarchical clustering using R or using excel. I only know to do clustering for a matrix. But how can i do it if my data is in a single column.

For E.g.

f1        18.047945
f10      18.367643
f100       17.824951
f101      18.347809
f102      18.689985

Now how can i cluster f1, f10, f100, f101 and f102 based on the values? Please help!

Answer 1

[Michael]

Clustering one dimensional data doesn't really make sense because it is trivial to order the data points. You can simply sort one-dimensional data instead, then all data points are next to the closest data point. However, you should be able to use k-means on the data.

Answer 2

[GouthamAtla]

You could use MultiExperiment Viewer (http://www.tm4.org/mev/)

Load the data from a tab delimited file.