copy_of_collected_data_1.xlsx
The writing should be a scientific report about a “Bird Study” trip that was taken place in Washington Park in Colorado. I will upload the data of the birds that was collected in the Study Area (e.g., kind and number of birds). Also, I will upload the 2 pages that you would need to read carefully in order to get the report instructions. Do not paste the chats and graphs, only use them to interpret in the Scientific Report.
>Sheet nesday
Group # Group # Group # Group # 1 9
1 9 1 1 1.8333
2 2 80 2 2 66
1
3 3 2 3 0 3 .66667
4 4 0 4 99 4 5 0 5 5 6 0 6 11 6 Mean Mean Mean Mean 28 46
SE 00478926
SE 8167 SE 39197258
SE .0512567892
2SE 00957852
2SE 2SE 2SE sday
1 1 0 1 39 1 3 2 42 2 0 3
4 4 0 4 4 4 5 52 5 42 5 5 0 .5
Mean 68 Mean Mean Mean 4 77336
SE SE SE SE 4672
2SE 2SE 2SE 2SE 036
1 1 0 1 0 1 2 3 2 40 2 20 2 3 6 3 30 3 1 3 5 56 5 0 5 0 5 Mean Mean Mean SE SE SE SE 2SE 2SE 2SE 2SE 1 76 1 1 1 0 1 0 5 5 0 5 0 5 0 0.5 Mean 0.5 Mean 3.3333333333 Mean 0 0 SE SE SE 3.3333333333 SE 0 2SE 2SE 2SE 2SE 0 6.83333 3.3333 North Lake- Wednesday Canadian Goose Mallards Crow Seagulls 129 61.833300000000001 15.166600000000001 49.666670000000003 North Lake – Thursday Canadian Goose Mallards Crow Seagulls Coot 68 53.333329999999997 12.333299999999999 40.5 1.1666669999999999 South Lake – Wednesday Canadian Goose Mallards Crow Seagulls 135 17.16667 11.66667 6.8333300000000001 South Lake- Thursday Canadian Goose Mallards Crow Seagulls Coot 115 69.333299999999994 0.5 3.3332999999999999 0 Seagull Mean South lake Wed Thur 6.8333300000000001 3.3332999999999999 North Lake Wed Thur 49.666670000000003 40.5 Mean
2
1
North Lake
Wed
Group #
Canadian Goose
Mallards
Crow
Seagulls
12
9
1
12
4
5
3
0
6
2
1
80
95
1
30
15.
16
3
11
41
49
4
217
99
5 130 5
42
28
6 12 6
35
Mean
129
61.8333333333
15.1666666667
49.6666666667
SE
26.02
56
39
11.
60
13.04
45
64
21.
37
2SE
52
23.
20
26.08916335
27
42.7478394516
Thur
Group # Canadian Goose Group # Mallards Group # Crow Group # Seagulls Group #
Coot
1
71
34
2 80 2 49 2
32
68
3 45 3 60 3 0 3 20 3 0
5
3.3333
4
116
65
50
12.3333
5
48
55
40
6 48 6 60 6 0 6 37 6 0
1.166667
5
3.3333333333
12.3333333333
0.5
Mean
1.1666666667
SE
11.23
38
4.5436157897
7.90639684
76
4.9581582602
0.7490735018
2SE
22.467
75
9.0872315794
15.8127936951
9.9163165204
1.49814
70
South Lake
Wednesday
Group # Canadian Goose Group # Mallards Group # Crow Group # Seagulls Group #
1
206
10
135
2
140
17.16667
3
150
11.66667
4 64 4 12 4 0 4 20 4
6.83333
5
180
6 70 6 16 6 0 6 0 6
Mean 135 Mean
17.1666666667
11.6666666667
6.8333333333
SE
23.5102814388
7.9850554858
7.4907350181
4.1666666667
2SE
47.0205628777
15.9701109716
14.9814700362
8.3333333333
Thursday
Group # Canadian Goose Group # Mallards Group # Crow Group # Seagulls Group #
Coot
1
120
2 80 2 49 2 0 2 0 2 0
3 50 3 27 3 0 3 0 3 0
115
4 75 4 38 4 0 4 0 4 0
69.3333
5
317
106
6 48 6 120 6 2 6 20 6 0 3.3333
Mean 115 Mean
69.3333333333
SE
41.7803781697
15.4308493321
0.3415650255
2SE
83.5607563393
30.8616986643
0.6831300511
6.6666666667
Wed Thur
South lake
North Lake
49.66667
40.5
Sheet2
Sheet3