I am trying to make group categories based on the similarity in attributes. For example;
Car1: blue, big tires, slow, comfortable
Car2: green, small tires, fast, comfortable
Car3: blue, big tires, slow, comfortable
My data set it much larger than that , but pretty much the same idea. What can I use in excel to find categories that are the most similar to each other?
I tried few methods, but have not been able to group qualitative data.