This is a brief explanation of the problem I presented in the 28. January 2020 GIS stammtisch.
I have a database in Excel. the larfer part of the data is nominal. The solumns represent categorical variables and the rows represent the sites.
I am looking for different methods that I can analyze the data. group the sites, or find correlations between variables.
I would like to find groups of sites that are more similar to eachother according to this data.
In total I have around 60 sites and 30 variables.
I created a contingency table and tried the Chi square test.
I also converterd the data into binary data and made the fisher exact test on it. but it is difficult to interpret the data.
I was thinking about doing other tests like uncertainty coefficient, etc.
I am looking for other suggestions.