I have a 27-year Mid-winter Waterfowl Survey Data (species list and abundances) for a lake and I want to compare the years and groups of years in terms of their avian diversity. The counts are semi-standardized (for practical purposes I will have to assume they are fully standardized). Which biodiversity indices should I use to compare years and groups of years in terms of their avian diversity?

P.S.: I cannot use R. I only use Excel for now but I have friends who are really good at R. 

More Kaan Özgencil's questions See All
Similar questions and discussions