1
$\begingroup$

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.

$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.