fishfeller
New Member
- Joined
- Mar 24, 2013
- Messages
- 5
site 1 | site2 | site3 | |
species 1 | 2 | 5 | |
species 2 | 1 | ||
species 3 | 7 | ||
species 4 | 4 | ||
species 5 | 1 | 4 | |
species 6 | |||
species 7 | 3 | 1 | 6 |
species 8 | |||
species 9 | 1 | 10 | |
species 10 | 9 |
<tbody>
</tbody>
Above is an example of my data set. I want calculate how many species make up 90% of the total abundance at a given site. For example in site 1 above total abundance is 10, so 3 species make up 90% of the total abundance. I was wondering if there was a formula that would do this automatically since I need to do this for 220 sites.