Hi, Alebachew

watch please this tutorial video   https://www.youtube.com/watch?v=GZgCqIempiA

if you need a excel sheet i had one the just put your figures and you will get the diversity result if you need msg me. you can alter it accordingly to your needs.

One way around the cero values in some of the cells is to use the if() function as follows:

Assuming that abundances of species are in one column.

Calculate de Pi for each species in one column. Let CellName be the Excell cell where the Pi values are stored, then calculate for each species the following formula in an adjacent column:

IF(CellName=0,0,CellName*(log(CellName)/log(2)))

That way the error for log(0) is avoided.

Then add all values for the entire sample.

I hope this is helpfull. But there are software that does it available in the web. Try one called PAST.

After putting your data, you need to go to insert function, then choose log, change the base to 2. You will have the log2pi values. I think then you can multiply and sum up the values to get the H.

Thanks

Hope you have had your excel already.

Or, I have samples for you. Not only Shannon's diversity index , but also others. REMEMBER, you should press "Ctrl"+"Shift"+"Enter" together when you have new cells.

Hi Alebachew,

try to calculate Shannon and other indices with Estimate S. its free

its a very good tool and uts relatively easy to use

http://viceroy.eeb.uconn.edu/estimates/EstimateSPages/EstSUsersGuide/EstimateSUsersGuide.htm#DiversityIndices

All the best

Cesar

The best and most convenient way is to use an excel addin.

The excel addin is available with more information at

http://www.reading.ac.uk/ssc/resources/diversity/Diversity.html

Cheers!

What is a natural logarithm or In(Pi)

 Dear Gerardo Umaña Villalobos,

I understand that ln(0) does not exist but why do we setup the contribution of the entropy to 0 ?

https://www.youtube.com/watch?v=0fsZr5U07aw

Dear Asaad Ali Karam,

Excellent video and thankyou so much!

An example https://entnemdept.ifas.ufl.edu/hodges/ProtectUs/lp_webfolder/9_12_grade/Student_Handout_1A.pdf

I think it would be easier for you if you use PAST3.

https://folk.uio.no/ohammer/past/

past 3 is good for the calculation of diversity indices

In this website (1) and excel spreed sheet (2) you can find an example

(1) https://www.slideserve.com/moeshe/how-to-calculate-the-shannon-weaver-diversity-index

(2) kbsgk12project.kbs.msu.edu › wp-content › uploads › 2013/09

Do you have Shannon's diversity index for excel? How to do that on excel?

https://www.youtube.com/watch?v=w9TvlB4hf7k

https://theexcelclub.com/simple-explanation-of-machine-learning-shown-with-excel-part-1/

https://www.youtube.com/watch?v=71cL-bap0WE

Here is how I did it. There is probably a more simple formula, but this is mine to get the Shannon for the species in cells B2:F2 and the total count (=SUM(B2:F2)) in G2:

=-SUM(((B2/G2)*(IF(B20,LN(B2/G2),0))),((C2/G2)*(IF(C20,LN(C2/G2),0))),((D2/G2)*(IF(D20,LN(D2/G2),0))),((E2/G2)*(IF(E20,LN(E2/G2),0))),((F2/G2)*(IF(F20,LN(F2/G2),0))))