| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
1 | Species | i | ni = number of individual species | pi = relative abundance of species | ln(pi) | pi[ln(pi)] | |
2 | honda car | 1 | 4 | 0.1538461538 | -1.871802177 | -0.2879695657 | |
3 | jeep | 2 | 3 | 0.1153846154 | -2.159484249 | -0.2491712595 | |
4 | ford suv | 3 | 1 | 0.03846153846 | -3.258096538 | -0.1253114053 | |
5 | subaru | 4 | 3 | 0.1153846154 | -2.159484249 | -0.2491712595 | |
6 | chevy truck | 5 | 15 | 0.5769230769 | -0.5500463369 | -0.3173344251 | |
7 | 6 | 0 | #NUM! | #NUM! | |||
8 | 7 | 0 | #NUM! | #NUM! | |||
9 | 8 | 0 | #NUM! | #NUM! | |||
10 | 9 | 0 | #NUM! | #NUM! | |||
11 | 10 | 0 | #NUM! | #NUM! | |||
12 | 11 | 0 | #NUM! | #NUM! | |||
13 | 12 | 0 | #NUM! | #NUM! | |||
14 | 13 | 0 | #NUM! | #NUM! | |||
15 | 14 | 0 | #NUM! | #NUM! | |||
16 | 15 | 0 | #NUM! | #NUM! | |||
17 | 16 | 0 | #NUM! | #NUM! | |||
18 | 17 | 0 | #NUM! | #NUM! | |||
19 | 18 | 0 | #NUM! | #NUM! | |||
20 | 19 | 0 | #NUM! | #NUM! | |||
21 | 20 | 0 | #NUM! | #NUM! | |||
22 | 21 | 0 | #NUM! | #NUM! | |||
23 | 22 | 0 | #NUM! | #NUM! | |||
24 | 23 | 0 | #NUM! | #NUM! | |||
25 | 24 | 0 | #NUM! | #NUM! | |||
26 | 25 | 0 | #NUM! | #NUM! | |||
27 | |||||||
28 | TOTAL # of Species =S | N = total # of individuals of ALL species | H' = Shannon Diversity Index | Note: The bigger the Diversity Index number, the greater the diversity | |||
29 | 5 | 26 | 1.228957915 | ||||