Hi to all
Good Evening
I have 10 individuals with their two groups memberships in a table like below. Now i would to plot them into clusters by using their group membership values.
Individual Q1 Q2
1 0.8 0.2
2 0.75 0.25
3 0.82 0.18
4 0.7 0.3
5 0.2 0.8
6 0.3 0.7
7 0.35 0.65
8 0.1 0.9
9 0.15 0.85
10 0.25 0.75
for example I want to make two clusters having Group membership value is greater than 0.8 example individual 1 belongs or cluster with 1st cluster (because value is >0.8) like this i would like to repeat with all the individuals to have final two clusters. Please find my example excel file for better understand. i tried with normal cluster graph in excel but not getting as expected. are there any ways to get expected cluster plot in excel? any help in this regard will be highly appreciated
Thanks in advance
Regards
Bookmarks