Urban Prairie Data.xlsx

	A	B	C	D	E	G	H	I	J	K	L
1	BIRD ABUNDACE AND RICHNESS BY DATE					FILL IN THIS TABLE BY CALCUTING SUMMARY STATISTICS FROM THE DATA GIVEN
2	Each year, 3 surveys were conducted (date 1, 2, 3). This table includes the total number of birds seen on that sampling date (ABUNDANCE), and the total number of different species seen on each sampling date (RICHNESS)						Year	Mean bird abundance (avg date 1, 2, 3)	Standard deviation of bird species abundance	Mean bird species richness (avg date 1, 2, 3)	Standard deviation of bird species richness
3	YEAR	START YEAR	DATE	ABUNDANCE	RICHNESS	Pre-restoration	2010
4	2010-11	2010	date 1	0	0	Post-retoration	2012
5	2010-11	2010	date 2	1	1		2013
6	2010-11	2010	date 3	0	0		2014
7	2012-13	2012	date 1	15	5		2015
8	2012-13	2012	date 2	46	9		2016
9	2012-13	2012	date 3	39	9
10	2013-14	2013	date 1	8	3	Insert graphs here according to the instructions provided.
11	2013-14	2013	date 2	4	3
12	2013-14	2013	date 3	5	3
13	2014-15	2014	date 1	27	9
14	2014-15	2014	date 2	6	1
15	2014-15	2014	date 3	22	6
16	2015-16	2015	date 1	16	4
17	2015-16	2015	date 2	25	9
18	2015-16	2015	date 3	2	1
19	2016-17	2016	date 1	15	4
20	2016-17	2016	date 2	3	2
21	2016-17	2016	date 3	16	3
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100