Table 2 (Sample data for homework). The number of ducklings that fledged (survived) from randomly located
nests at five prairie pothole lakes in southern Minnesota during the summer of 2021.
Hemlock Loon
Jitterbug Eagle
Lake
Lake
Lake
Lake
Middle
Lake
12
15
12
5
7
13
11
14
4
7
12
13
12
3
8
13
10
9
6
8
11
9
23
4
8
12
11
15
8
7
5
9
15
13
6
11
2
1
Table 3. Use this sheet as an example to set up your table for this homework assignment in Excel. (Note:
format your table following the format provided in the Homework Guidelines).
Lake
X
Median DF
SS
s2
Hemlock 13
13
s (or SD)
SE
t95(SE)
12
7
I5
2.14
1.46
0.52
2.36
Loon
11
11
7
38
5.93
2.33
0.82
2.36
Jitterbug 11
11
205
25.62
5.06
1.68
2.31
Eagle
4
4
8
20
2.5
2.5
0.52
2.31
Middle
8
8
6
7
1,17
1.17
0.91 2.45
12
What needs to be turned in next week:
Properly formatted table and figure using the data from Table 3.
Answers to the following questions, using full sentences. Follow the homework guidelines.
1. What is the mean and 95% CI of Hemlock Lake? (2 pts)
2. Which lakes had a difference in mean number of ducklings fledged (interpret this visually from
differences in the 95% CI)? State all contrasts that are significantly different. It may help to first
use letters to denote differences better lakes like you did on page 7. (4 pts)
3. Using a t-test, report the single t-score and P-value generated when comparing fledgling
population differences among Jitterbug and Middle Lakes. Use a declarative statement to
describe if the lake means are significantly different from each other or not. See the example
on page 9 for an example of a declarative statement. (4 pts)