I have multiple bacterial isolates having different antibiotic pattern. I would like to prepare dendrogram no basis of similarity of antibiotic pattern.
If you have data in excel sheet, that means you have rows and columns. You can do any type of cluster analysis, lets say hierarchical clustering and make dendograms based on your data. There are several libraries which has this functionality and several good tutorials too. R is absolutely free aswell.