Are you looking for groups of like-minded respondents? Try Cluster analysis. It is used to segment items or people in homogeneous groups.
LogRatio applies the Ward’s clustering method. It belongs to the Hierarchical methods, and it is particularly effective in the case of automated analysis because it does not require specifying in advance the desired number of clusters to find in the data.
Anderberg (1973) wrote: The value of exploratory cluster analysis is primarily in the tendency for new arrangements of data units or variables to suggest relationships and principles previously unnoticed. The substantive results are not the output of the computer but the new ideas prompted in the analyst’s mind.
In order to prompt new ideas in the reader’s mind, LogRatio performs two different cluster analyses with the closed-ended variables in sheet Main_DB: by column and by row.
The results of the cluster analysis by row (respondents) are coded and placed at the right-side end of sheet Main_DB. These codes are used to make the cross tables useful to understand and describe each group of respondents belonging to a homogeneous cluster.