Colorado State University Calculations and Graphs Worksheet All information in attached images. Due in 30 hours! Please message if any extra information ne

Colorado State University Calculations and Graphs Worksheet All information in attached images. Due in 30 hours! Please message if any extra information needed. Thank you Avg
CI (2*SE)
Male Preference
Female Preference
Sex of Focal Fish (M) Average Score Sex of Focal Fish (F) Average Score
M
-4.23 F
-2.25
M
3.5 F
-1.5
M
2.82 F
1.78
M
3.73 F
2.97
M
2.98 F
3.46
M
0.168 F
3.82
M
1.24 F
-1.14
M
-0.16 F
– 1.12
M
2.14 F
0.56
M
0.18 F
-0.92
M
1.06 F
3.2
M
-1.37 F
0.2
M
0.28 F
-0.38
M
2.84 F
2.12
M
1.18 F
2.46
M
-0.038 F
3.25
M
2.18 F
2.18
Average M
Average F
Std M
Std F
nM
n F
SEM
SEF
CIM (2*SE)
CIF (2″SE)
In excel, calculate the mean, standard
deviation, sample size, and standard error,
as well as confidence intervals, for male
and female mate choices. Graph the two
means and add custom error bars to those
means using the confidence interval values,
and include a figure caption. Additionally,
please answer the following questions in a
textbox within your excel sheet:
1. What did you hypothesize before the
start of the experiment?
2. Does the data provide evidence to
support your hypothesis or
hypotheses? Explain (In other words,
interpret your graph).
3. Could the experimental design be
improved? How so? (Hint: Think about
sample size and replicates, subjectivity
in individually assessing 1. distance to
mate choices and 2. preferred verses
non-preferred traits, or interference
that may affect behavior like movement
and light changes, etc.) Is our data
reliable?
4. How does this experiment relate to the
concept of sexual selection? (Hint:
Mate choice based on coloration and
morphological features)
Please upload your assignment as an excel
file titled Yournamefish.xxls.

Purchase answer to see full
attachment