# Multivariate Cluster Analysis

I have conducted a multiple choice survey, and now I want to analyze it using a cluster analysis.

Since it is a multiple choice, multiple variant survey k-mean clustering or fuzzy k-mean clustering seemed like the obvious choice. However, since I am completely new to clustering, I am not sure if it is the best approach after all.

Furthermore, the multiple answers are giving me a hard time, as it does not allow a clear clustering of one-to-one answers. Should I produce distinct data sets for each multiple answer? It would expand the data set way beyond 250 entries, and I am not even sure if it would provide any useful answers because it won't be able to represent when multiple answers were given.

Here is a [link][1] to my data sheet. In the data multiple answers are distinguished by ";" and blank answers are indicated by NULL.

Are there any algorithms that can deal with the data? How would you approach this data set?

Data Snippet:

|Z | A | B | C | |:--|:--:|:--:|-----:| |1 |1 |5 | 1;2;3| |2 |NULL|2 | 1;2| |3 |2 |3 | 1;2;3| |4 |3 |2 | 1;2| |5 |4 |3 | 1;2| |6 |2 |3 | 1;2| |7 |3 |3 | 2| |8 |2 |4 | 1;2| |9 |3 |2 | 1;2| |10 |3 |2 | 1;2| |11 |1 |3 | 1;2;3| |12 |2 |3 | 1;2;3| |13 |4 |3 | 1;2| |14 |4 |4 | 1;2;3| |15 |4 |6 | 1;2;3| |16 |3 |7 | 1;2| |17 |4 |NULL| 1;2| |18 |3 |3 | 1;2;3| [1]: https://docs.google.com/spreadsheets/d/1m7jv-CtHd7vAsRC5J3rK8lJuhnRB4ClCggyIltK_ytA/edit?usp=sharing

• What is "multiple variant survey k-mean clustering"? I tried to google it but nothing came up. Also better show some of your data here and explain it. By "multiple answers" you mean people get a number of choices and can choose more than one? Commented May 21, 2021 at 20:27
• Hey, I want to analyze it using k-mean, but there are multiple questions in the survey. Hence multivariate analysis. By multiple answers I mean exactly what you said - more than one answer option is valid to enter as an answer. See the added snippet of the data above. Commented May 22, 2021 at 9:05
• By the way, another note on terminology: "Multivariate" just means that there is more than one variable involved. Almost all clustering is multivariate, there's nothing particularly "multivariate" about yours. Commented May 23, 2021 at 9:08