biological project，due within 6 hours

Nancy 00001
terrestrial_field_study_data.xlsx
Home>Biology homework help>biological project，due within 6 hours

Sheet1

Terrestrial field study data March 2019
understory species = percent cover per m2
trees = number of trees per 100m2
Scroll down for data from the Coniferous Forest, scroll to the right for data on abiotic factors and tree abundance
The complete names of all plant species can be found at the bottom of this sheet
Deciduous Forest Deciduous Forest
Replicate Polystichum R. ursinus R. spectabilis Gaultheria Vaccinium Mahonia Dryopteris Moss Ilex Hedera R. discolor Air temp. oC Light intensity Lux Replicate Pseudotsuga Thuja plicata Tsgua Alnus A. circinatum A. macrophyllum Populus bal. Prunus emargin. Laburnum
1 0 30 0 0 0 0 0 0 0 0 0 19 17560 1 0 3 0 5 0 0 2 1 0
2 0 16 30 0 0 0 0 0 0 0 9 19 15000 2 0 1 0 7 0 0 0 2 0
3 30 18 6 0 0 0 0 1 0 0 0 21 40600 3 0 1 0 11 0 1 1 0 1
4 0 15 0 0 0 0 0 1 0 0 12 18 22600 4 0 1 0 15 0 0 0 0 0
5 28 0 5 0 0 0 0 1 0 0 0 21 35000
6 0 27 19 0 0 0 0 32 0 0 0 19 8000
7 0 14 0 0 0 0 0 0 0 0 0 18 56000
8 19 20 24 0 0 13 0 0 0 0 36 18 26000
9 0 30 0 0 0 0 0 0 0 0 0 20 4390
10 0 27 0 0 0 0 0 4 0 0 0 18 5190
11 0 7 0 0 0 0 0 0 0 0 0 19 16480
12 0 4 0 0 0 0 0 0 0 0 0 19 30900
13 0 41 23 0 0 0 0 4 0 0 0 21 28000
14 12 16 0 0 0 0 0 2 0 0 0 20 15000
15 0 20 27 0 0 0 0 0 0 0 0 18 47900
16 36 17 0 0 0 0 0 0 0 0 0 18 22900
17 0 0 0 0 0 0 0 5 0 0 0 18 42100
18 0 0 0 0 0 0 0 12 4 0 0 18 10000
19 0 17 100 0 0 0 0 32 0 0 0 18 15300
20 0 95 21 0 0 0 0 0 0 0 0 18 51100
21 0 32 3 0 0 0 0 0 0 0 22 15 9340
22 0 41 5 0 0 0 0 0 0 0 0 17 5390
23 0 27 35 0 0 17 0 20 0 0 0 22 28600
24 0 0 10 0 0 0 0 0 0 0 0 21 60500
25 0 0 0 0 0 24 0 1 0 0 0 17 40500
26 6 10 0 0 0 34 0 4 0 0 0 18 46900
27 9 0 0 0 0 0 0 23 0 0 0 25 52200
28 0 0 0 0 0 27 0 0 0 0 0 19 7400
29 0 0 0 0 0 86 0 0 0 0 0 19 25700
30 3 0 35 0 0 17 0 6 0 0 0 22 25700
31 10 10 0 0 0 9 0 0 0 0 0 16 4200
32 0 7 0 0 0 5 0 15 0 0 14 19 23100
33 0 9 0 0 0 42 0 0 0 0 0 18 52500
34 0 0 0 0 0 72 0 0 0 0 0 12 36200
35 0 0 11 0 0 21 0 0 0 0 0 21 25000
36 0 32 0 9 23 8 0 0 0 0 0 21 39400
37 0 8 0 0 0 8 0 0 0 0 12 20 38000
38 0 0 0 0 0 3 0 0 0 0 14 20 36000
39 0 3 0 0 0 24 0 0 0 0 0 19 31700
40 0 0 15 0 0 30 0 0 0 0 0 18 41000
41 0 0 0 0 0 90 0 0 0 0 2 18 10970
42 0 20 0 0 0 0 0 0 0 0 0 15 56000
43 7 19 0 24 0 18 0 0 0 0 0 20 50000
44 0 15 0 0 0 54 0 0 0 0 14 20 30000
45 0 6 22 0 0 4 0 0 0 0 0 16 50000
46 0 0 0 0 0 10 0 0 0 0 0 15 50000
47 0 0 0 0 0 21 0 0 0 0 0 17 39500
48 0 14 0 0 0 56 0 0 0 0 0 17 56000
Coniferous Forest Coniferous Forest
Replicate Polystichum R. ursinus R. spectabilis Gaultheria Vaccinium Mahonia Dryopteris Moss Ilex Hedera R. discolor Air temp. oC Light intensity Lux Replicate Pseudotsuga Thuja plicata Tsgua Alnus A. circinatum A. macrophyllum Populus bal. Prunus emargin. Laburnum
1 100 0 0 0 0 0 0 2 0 0 2 18 3810 1 2 4 3 0 4 0 0 0 0
2 0 0 0 0 12 0 0 9 0 0 9 16 3480 2 2 4 2 0 16 0 0 0 0
3 0 0 2 0 0 0 0 3 5 0 0 15 420 3 4 0 1 0 8 0 0 0 0
4 45 2 4 0 0 0 0 60 26 0 0 15 8900 4 16 0 0 0 2 0 6 0 0
5 0 0 0 0 0 0 11 7 0 1 0 18 620
6 0 34 0 0 0 0 1 27 7 0 0 16 330
7 32 0 8 0 11 0 1 27 0 0 0 15 630
8 39 0 12 0 0 7 1 38 14 0 0 15 910
9 10 5 2 0 0 0 0 78 1 0 0 17 373
10 58 0 0 0 0 0 0 0 0 0 0 16 421
11 0 2 0 0 0 0 0 0 13 0 0 17 338
12 47 0 22 0 0 0 3 6 12 0 0 17 444
13 30 0 8 0 23 0 0 0 0 0 0 16 732
14 0 0 0 0 0 0 0 17 16 0 0 20 5100
15 0 0 14 0 0 0 0 13 29 0 0 14 1700
16 0 0 0 0 0 0 0 8 25 0 0 13 5740
17 0 36 0 0 0 0 0 0 0 0 0 17 150
18 0 26 0 0 0 4 0 20 0 0 0 17 425
19 47 0 0 0 0 9 0 11 0 0 0 16 478
20 0 0 0 0 0 100 0 0 0 0 0 16 347
21 0 0 0 0 0 0 0 2 0 0 0 15 8180
22 0 0 0 0 0 0 0 0 0 0 0 15 19300
23 21 0 0 0 0 0 0 39 0 0 0 15 339
24 0 0 0 0 0 0 0 3 0 0 0 15 159
25 0 0 0 0 20 0 0 5 0 0 0 16 553
26 1 0 0 4 0 0 1 0 5 8 1 16 2900
27 0 0 0 11 0 0 0 4 0 0 0 15 900
28 18 4 0 0 0 0 0 86 0 0 0 15 450
29 0 0 0 0 0 0 0 22 0 0 0 16 366
30 0 0 0 3 0 0 0 0 0 0 0 15 553
31 96 0 0 19 0 0 0 0 0 0 0 14 834
32 0 0 0 0 1 0 0 1 0 0 0 14 422
33 0 0 0 0 26 0 0 0 0 0 0 12 370
34 15 0 0 47 0 0 0 8 0 0 0 13 1080
35 0 0 16 2 0 0 0 0 9 0 0 15 722
36 0 2 0 0 33 0 0 0 0 0 0 14 656
37 0 0 0 2 0 0 25 0 0 0 0 13 800
38 0 2 0 0 0 0 1 0 0 0 0 13 7000
39 0 0 0 0 40 0 0 0 0 0 0 14 3300
40 12 0 0 4 0 0 0 0 0 0 0 14 3000
41 0 0 0 24 0 0 0 5 0 0 0 16 658
42 0 0 0 7 0 0 2 8 0 0 0 14 620
43 0 0 0 18 0 0 0 0 5 0 0 13 11000
44 8 0 0 0 23 0 3 0 0 0 0 13 3000
45 0 0 0 14 0 0 6 0 0 0 8 13 200
46 36 0 0 0 18 0 0 0 0 0 0 12 300
47 0 12 0 29 0 0 0 18 0 0 0 13 6850
48 0 0 0 0 0 0 0 27 0 0 0 15 8150
Understory Plants Trees
Polystichum munitum (sword fern) Pseudotsuga menzeisii (Douglas fir)
Rubus ursinus (trailing blackberry) Thuja plicata (Western red cedar)
Rubus spectabilis (salmonberry) Tsuga heterophylla (Western hemlock)
Gaultheria shallon (salal) Alnus rubra (Red alder)
Vaccinium parvifolium (red huckleberry) Acer circinatum (Vine maple)
Mahonia nervosa (dull Oregon-grape) Acer macrophyllum (Big leaf maple)
Symphoricarpos albus (snowberry) Populus balsamifera (Black cotton wood)
Dryopteris expansa (spiny wood fern) Prunus emarginata (Bitter cherry)
Ilex aquifolium (English Holly) Laburnum watereri (Golden chain tree)
Hedera helix (English Ivy)
Rubus discolor (Himalayan blackberry)
Prunus laurocerasus (Laurel)
Sorbus sp. (Mountain ash)