CrayfishLab006S20191.xlsx

Sheet1

chela length (cm) cephalothorax length (cm) chela length (cm)/cephalothorax length (cm) chela length (cm) cephalothorax length (cm) chela length (cm)/cephalothorax length (cm)
males males males females females females
3.2 4.3 0.744 3.2 4.3 0.744
4.4 4.8 0.917 4.4 4.8 0.917
4.7 5 0.94 4.7 5 0.94
5.5 5.8 0.948 5.5 5.8 0.948
4.1 4.8 0.854 4.1 4.8 0.854
6 6 1 4.8 6.2 0.774
5 5 1 4 5.6 0.714
5 4.8 1.042 4.8 5 0.96
4.5 4.8 0.938 4 5.5 0.727
4.4 4.3 1.023 2.8 5.1 0.549
4.3 5.2 0.827 3.7 5.9 0.627
3.7 4.4 0.841 4.3 5.3 0.811
5 5.5 0.909 4.4 5.9 0.746
5.2 5.6 0.929 3.5 4.9 0.714
6.5 5.6 1.161 3.7 5.2 0.712
3.4 4.5 0.756 3 4.5 0.667
5.1 5.2 0.981 4.7 5.5 0.855
2.2 4.7 0.468 3.5 4.4 0.795
5.4 5.4 1 2.7 4.6 0.587
4.7 5.3 0.887 3.6 5.1 0.706
5.5 6.5 0.846 4 6.5 0.615
4 5 0.8 4.5 7 0.643
5.5 6.5 0.846 4.5 6.5 0.692
3.5 5 0.7 3.75 6 0.625
4.5 7 0.643 4 6.5 0.615
5.3 5.5 0.964 2.8 4.7 0.596
3.9 4.3 0.907 3.6 5.1 0.706
5.1 5.1 1 4 5.7 0.702
4.7 4.8 0.979 4 5.6 0.714
4.6 4.5 1.022 3.2 4.1 0.78
3.85 4.5 0.856 4.3 5.3 0.811
4.8 5.2 0.923 3.5 4.8 0.729
3.8 4.4 0.864 5.9 6.3 0.937
3.25 4.6 0.707 4.7 4.9 0.959
2.1 4.4 0.477 3.1 5.4 0.574
4.75 5.25 0.905 3 5.25 0.571
5 5.5 0.909 4 5.5 0.727
5.6 5.75 0.974 3.5 4.75 0.737
4.25 4.25 1 3.5 5.6 0.625
5.25 5 1.05 2.75 5.1 0.539
3.8 5 0.75 3.4 4.9 0.694
6 6.3 0.952 3.4 4.6 0.739
4.4 5.2 0.846 3.3 4.6 0.717
4.2 4.7 0.894 3.1 5.3 0.585
3.6 3 1.2 3.1 5.3 0.585
MEAN: 4.5233333333 5.0722222222 0.8928666667 3.8288888889 5.3044444444 0.7236444444
SD 0.9237768326 0.7152999653 0.144628301 0.7256258184 0.6509453111
P=0.05
Null hypothesis = There is no difference in length between male chela and female chela.
Alternative hyptothesis = Male chela length is greater than female chela length.
Chela Length Males vs Females T Test: Two-Sample Assuming Equal Variances Cephalothorax Males vs Females T Test: Two-Sample Assuming Equal Variances
Males Females Males Females
Mean 4.5534090909 3.8431818182 Mean 5.0897727273 5.3272727273
Variance 0.8315578753 0.5293710359 Variance 0.5093697146 0.4095877378
Observations 44 44 Observations 44 44
Pooled Variance 0.6804644556 Pooled Variance 0.4594787262
Hypothesized Mean Difference 0 Hypothesized Mean Difference 0
df 86 df 86
t Stat 4.0383686643 t Stat -1.643396093
P(T<=t) one-tail 0.0000582617 P(T<=t) one-tail 0.0519761556
t Critical one-tail 1.6627653893 t Critical one-tail 1.6627653893
P(T<=t) two-tail 0.0001165235 P(T<=t) two-tail 0.1039523113
t Critical two-tail 1.9879341663 t Critical two-tail 1.9879341663
Ratio Chela/Cephalothorax Males vs Females T Test: Two-Sample Assuming Equal Variances
Males Females
Mean 0.89625 0.7231818182
Variance 0.0208767035 0.0139959197
Observations 44 44
Pooled Variance 0.0174363116
Hypothesized Mean Difference 0
df 86
t Stat 6.1475385546
P(T<=t) one-tail 0.0000000119
t Critical one-tail 1.6627653893
P(T<=t) two-tail 0.0000000239
t Critical two-tail 1.9879341663