Simpson's Species Diversity in Excel

[@Snailrind]

N.B. the final equation here is upside down. It should be Σni(ni-1) / N(N-1), not N(N-1) / Σni(ni-1). With that small adjustment, this video is really helpful and clear. Thanks!

[@biancaleighhamman4234]

Lol I thought something was wrong with that equation!

[@ProjectNature915]

Yes. Thank you

[@chameleontwist2551]

Yea thats what i was wondering

[@morganbruce8090]

Thank you! You saved everything for me! I was wondering why my values had such a large range. Yes, this video is extremely helpful but you made it perfect!

[@Rewsquable]

I think it's also important to clear that this formula is D' for sampling without replacement (dependent samples).

[@i.kaanozgencil9833]

Thanks for making the video. This video saved me a lot of time! Don't worry about the upside equation. It's easy to fix it.

[@aarzoo1982]

I agree the final equation is upside down.

[@felistaobasi4427]

Thank you so much for the video! Very helpful

[@romanelegac3725]

thank's very much

[@aetobatus]

Thanks this was helpful!

[@nasserbarakat5556]

very good

[@h-oneyb-e]

thanks