How to use Excel to calculate the Shannon index of diversity

[@joekendrick6584]

I am college student studying at level 4 in the UK and this was amazingly helpful and easy to follow, thanks for pretty much saving one of my assignments :)

[@devonpaulino513]

Your teaching skills are amazing. You make it easy to follow and understand.

[@lunar_rainbow]

Thank you so much, I've been stuck on an assignment for hours now because I didn't understand how to do this and your video simplified things really well for me :) Will actually be able to get my work done now, very relieved!

[@oliviahoughton8423]

This was genuinely so helpful thank you so so much!!! You just saved my grade on my assignment!

[@cleargreyskies]

Thank you for this video! I had to tweak it a little because I had many empty values and zeroes, but I found a solution! We never learned Excel in my ecology studies (only R), so videos like this are very helpful.

[@aliitheCat]

I love these formulas applied to excel as it's easier to understand it's mechanisms without dealing with arithmetics and making silly calculation errors.

[@bulfcrog]

thankyou i struggled with this in my undergrad, now in masters and cant believe how easy you made it

[@miissJoceLyn]

Great and easy explanation. Thank you so much !!!

[@indusacademyscience]

Thanks a lot explained well with clearly.

[@ananyaagnihotri1243]

this was so helpful and to the point, thank you so much

[@zacswicord4496]

Thanks, total lifesaver

[@zlu224]

this can be evaluated as =-SUM(C2:C10*LN(C2:C10)), or from the frequency column directly =-SUM(B2:B10*LN(B2:B10))/B11+LN(B11).

[@sharlah4057]

Very helpful thank you!

[@crystalworld2435]

Merci, je n'ai trouvé aucune vidéo aussi bien en français alors j'ai suivi la vôtre et même en anglais j'ai tout compris 😊

[@makedaphevrin3630]

Thank you SO much

[@sarwatjahan278]

Thank you so much ma'am it's helpful lot's for me a warm thank you 😊

[@anaosorio3785]

Thank you so much 😭

[@zbrownie1672]

Amazing, thanks!!!

[@Wings_whisperer]

Thank you so much ;-)

[@bongbongchan9771]

thank you so much

[@aurox0122]

thanks a lot!

[@neddahabdella8787]

Thank You

[@bernamariamathew2804]

,👍