stats job

strength
AntCommunityMatrix.xlsx
Home>Mathematics homework help>Statistics homework help>stats job

Ant Diversity DATA

# Sample Habitat polyrhachis Lasius Niger Tapinoma Sessile Monomorium Pharaonis Iridomyrmex Ghost Ant Camonorus Humilies Technomyrmex Pinoma Sessile Pachycondyla lutea Megaccephala Notoncus Capitatus Ochetellus glaber Aphaelogaster longiceps WhiteFoot Monomorium
1 Control 1 RecentBurn 9
2 Control 2 RecentBurn 2
3 Control 3 RecentBurn 4
4 Control 4 RecentBurn 1 1
5 Control 5 RecentBurn
6 Control 6 RecentBurn 1
7 Control 7 RecentBurn
8 Control 8 RecentBurn
9 Trap1 RecentBurn 1
10 Trap2 RecentBurn
11 Trap3 RecentBurn 1 3 1 1
12 Trap4 RecentBurn 1 1 9 1
13 Trap5 RecentBurn
14 Trap6 RecentBurn 1 1 1
15 Trap7 RecentBurn
16 Trap8 RecentBurn
17 Control 1 OldBurn 1
18 Control 2 OldBurn
19 Control 3 OldBurn 1
20 Control 4 OldBurn 2
21 Control 5 OldBurn 2 1 1
22 Control 6 OldBurn 1
23 Control 7 OldBurn 3
24 Control 8 OldBurn
25 Trap1 OldBurn 4 3
26 Trap2 OldBurn
27 Trap3 OldBurn 1 1 6 1
28 Trap4 OldBurn
29 Trap5 OldBurn
30 Trap6 OldBurn 30
31 Trap7 OldBurn
32 Trap8 OldBurn 1 23
33 Control 1 NoBurn 1 1 3
34 Control 2 NoBurn
35 Control 3 NoBurn
36 Control 4 NoBurn 1
37 Control 5 NoBurn
38 Control 6 NoBurn 1 1 1
39 Control 7 NoBurn 1
40 Control 8 NoBurn
41 Trap1 NoBurn
42 Trap2 NoBurn 11
43 Trap3 NoBurn
44 Trap4 NoBurn 7
45 Trap5 NoBurn 1 6 5
46 Trap6 NoBurn 1
47 Trap7 NoBurn
48 Trap8 NoBurn 1
17 31 1 3 71 10 3 4 2 1 1 2 10 1 2 5

SUMMARY

# Species RecentBurn Old Burn NewBurn
1 polyrhachis 10 4 3
2 Lasius Niger 10 7 14
3 Tapinoma Sessile 1 0 0
4 Monomorium Pharaonis 0 3 0
5 Iridomyrmex 0 57 14
6 Ghost Ant 0 10 0
7 Camonorus Humilies 0 0 3
8 Technomyrmex 3 0 1
9 Pinoma Sessile 1 0 1
10 Pachycondyla lutea 1 0 0
11 Megaccephala 1 0 0
12 Notoncus Capitatus 2 0 0
13 Ochetellus glaber 9 0 1
14 Aphaelogaster longiceps 1 0 0
15 WhiteFoot 1 1 0
16 Monomorium 0 0 5
Total
Abundance 40 82 42 164
Diversity 11 6 8 16

Sheet1

Site 1
Species RecentBurn Relative abundance (Pi) ln(Pi) Pi ln(Pi)
1 polyrhachis 10 0.25 -1.3862943611 -0.3465735903
2 Lasius Niger 10 0.25 -1.3862943611 -0.3465735903
3 Tapinoma Sessile 1 0.025 -3.6888794541 -0.0922219864
4 Monomorium Pharaonis 0 0 0 0
5 Iridomyrmex 0 0 0 0
6 Ghost Ant 0 0 0 0
7 Camonorus Humilies 0 0 0 0
8 Technomyrmex 3 0.075 -2.5902671654 -0.1942700374
9 Pinoma Sessile 1 0.025 -3.6888794541 -0.0922219864
10 Pachycondyla lutea 1 0.025 -3.6888794541 -0.0922219864
11 Megaccephala 1 0.025 -3.6888794541 -0.0922219864
12 Notoncus Capitatus 2 0.05 -2.9957322736 -0.1497866137
13 Ochetellus glaber 9 0.225 -1.4916548768 -0.3356223473
14 Aphaelogaster longiceps 1 0.025 -3.6888794541 -0.0922219864
15 WhiteFoot 1 0.025 -3.6888794541 -0.0922219864
16 Monomorium 0 0 0 0
Total 40
Abundance 40
Diversity 11
Species Richness (S): 2.5298221281
Shannon-Wiener Diversity (H'): 1.926158097
Species Evenness (H'/ln(S)): 2.0752682027
Site 2
Species Old Burn Relative abundance (Pi) ln(Pi) Pi ln(Pi)
1 polyrhachis 4 0.0487804878 -3.0204248861 -0.1473377993
2 Lasius Niger 7 0.0853658537 -2.4608090982 -0.2100690694
3 Tapinoma Sessile 0 0 0 0
4 Monomorium Pharaonis 3 0.0365853659 -3.3081069586 -0.1210283034
5 Iridomyrmex 57 0.6951219512 -0.3636679794 -0.2527935955
6 Ghost Ant 10 0.1219512195 -2.1041341543 -0.2566017261
7 Camonorus Humilies 0 0 0 0
8 Technomyrmex 0 0 0 0
9 Pinoma Sessile 0 0 0 0
10 Pachycondyla lutea 0 0 0 0
11 Megaccephala 0 0 0 0
12 Notoncus Capitatus 0 0 0 0
13 Ochetellus glaber 0 0 0 0
14 Aphaelogaster longiceps 0 0 0 0
15 WhiteFoot 1 0.012195122 -4.4067192473 -0.0537404786
16 Monomorium 0 0 0 0
Total 82
Abundance 82
Diversity 6
Species Richness (S): 1.7669044172
Shannon-Wiener Index of Diversity (H'): 1.0415709723
Species Evenness (H'/ln(S)): 1.8297922134
Site 3
Species NewBurn Relative abundance (Pi) ln(Pi) Pi ln(Pi)
1 polyrhachis 3 0.0714285714 -2.6390573296 -0.188504095
2 Lasius Niger 14 0.3333333333 -1.0986122887 -0.3662040962
3 Tapinoma Sessile 0 0 0 0
4 Monomorium Pharaonis 0 0 0 0
5 Iridomyrmex 14 0.3333333333 -1.0986122887 -0.3662040962
6 Ghost Ant 0 0 0 0
7 Camonorus Humilies 3 0.0714285714 -2.6390573296 -0.188504095
8 Technomyrmex 1 0.0238095238 -3.7376696183 -0.0889921338
9 Pinoma Sessile 1 0.0238095238 -3.7376696183 -0.0889921338
10 Pachycondyla lutea 0 0 0 0
11 Megaccephala 0 0 0 0
12 Notoncus Capitatus 0 0 0 0
13 Ochetellus glaber 1 0.0238095238 -3.7376696183 -0.0889921338
14 Aphaelogaster longiceps 0 0 0 0
15 WhiteFoot 0 0 0 0
16 Monomorium 5 0.119047619 -2.1282317058 -0.2533609174
Total 42
Abundance 42
Diversity 8
Species Richness (S): 2.4688535994
Shannon-Wiener Index of Diversity (H'): 1.6297537011
Species Evenness (H'/ln(S)): 1.8033157892