lab report

profileBella edwards
ThursdaysectionCrayfishdatawitht-test012withGraphs.xlsx
Home>Biology homework help>lab report

Sheet1

t-Test: Paired Two Sample for Means
Variable 1 Variable 2
Mean 4.4560666667 3.68585
Variance 0.5670997921 0.6965257568
Observations 60 60
Pearson Correlation 0.2793049441
Hypothesized Mean Difference 0
df 59
t Stat 6.2454168103
P(T<=t) one-tail 0.0000000252
t Critical one-tail 1.6710930321
P(T<=t) two-tail 0.0000000504
t Critical two-tail 2.0009953781

Sheet2

t-Test: Paired Two Sample for Means
Variable 1 Variable 2
Mean 5.0069 5.1676333333
Variance 0.2994065661 0.3411898972
Observations 60 60
Pearson Correlation 0.2298859006
Hypothesized Mean Difference 0
df 59
t Stat -1.7720410663
P(T<=t) one-tail 0.040775582
t Critical one-tail 1.6710930321
P(T<=t) two-tail 0.081551164
t Critical two-tail 2.0009953781

Sheet3

t-Test: Paired Two Sample for Means
Variable 1 Variable 2
Mean 0.8896998641 0.7092285033
Variance 0.0116323952 0.0125369112
Observations 60 60
Pearson Correlation -0.0033462314
Hypothesized Mean Difference 0
df 59
t Stat 8.976911006
P(T<=t) one-tail 0
t Critical one-tail 1.6710930321
P(T<=t) two-tail 0
t Critical two-tail 2.0009953781

1121-006

Chela Length Cephalothorax Length Body Size Ratio Chela Size Cephalothorax Length Body Size Ratio
Group Crayfish Male Female Male Female Male Female Male Female Male Female Male Female
A 1 4.20 3.50 5.10 5.00 0.82 0.70 Mean 4.46 3.69 5.01 5.17 0.89 0.71
A 2 4.10 3.80 4.50 5.10 0.91 0.75 SD 0.75 0.83 0.55 0.58 0.11 0.11
A 3 4.00 3.10 4.30 5.30 0.93 0.58 N 60 60 60 60 60 60
A 4 3.70 3.40 5.00 4.80 0.74 0.71
A 5 4.20 3.00 4.50 5.00 0.93 0.60 Body Size Ratio
B 1 4.20 5.20 5.50 6.50 0.76 0.80 Chela Length Cephalothorax Length t-Test: Paired Two Sample for Means
B 2 4.00 3.90 5.00 5.30 0.80 0.74 t-Test: Paired Two Sample for Means t-Test: Paired Two Sample for Means
B 3 3.90 5.00 4.50 5.50 0.87 0.91 Variable 1 Variable 2
B 4 5.80 4.50 5.70 6.00 1.02 0.75 Variable 1 Variable 2 Variable 1 Variable 2 Mean 0.8896998641 0.7092285033
B 5 3.50 4.00 4.00 5.30 0.88 0.75 Mean 4.4560666667 3.68585 Mean 5.0069 5.1676333333 Variance 0.0116323952 0.0125369112
C 1 5.60 3.80 6.00 4.90 0.93 0.78 Variance 0.5670997921 0.6965257568 Variance 0.2994065661 0.3411898972 Observations 60 60
C 2 4.40 3.80 4.90 5.30 0.90 0.72 Observations 60 60 Observations 60 60 Pearson Correlation -0.0033462314
C 3 3.30 3.40 4.80 4.50 0.69 0.76 Pearson Correlation 0.2793049441 Pearson Correlation 0.2298859006 Hypothesized Mean Difference 0
C 4 3.10 3.00 4.50 4.60 0.69 0.65 Hypothesized Mean Difference 0 Hypothesized Mean Difference 0 df 59
C 5 3.70 2.80 4.80 4.30 0.77 0.65 df 59 df 59 t Stat 8.976911006
D 1 4.00 3.10 4.80 4.90 0.83 0.63 t Stat 6.2454168103 t Stat -1.7720410663 P(T<=t) one-tail 0
D 2 6.00 4.00 5.90 4.90 1.02 0.82 P(T<=t) one-tail 0.0000000252 P(T<=t) one-tail 0.040775582 t Critical one-tail 1.6710930321
D 3 4.10 3.20 4.70 4.70 0.87 0.68 t Critical one-tail 1.6710930321 t Critical one-tail 1.6710930321
D 4 4.50 2.70 5.20 4.80 0.87 0.56
D 5 3.90 2.40 4.80 4.20 0.81 0.57
E 1 4.30 4.30 4.70 6.50 0.91 0.66
E 2 4.20 4.30 5.00 6.40 0.84 0.67
E 3 4.80 4.00 5.20 5.60 0.92 0.71
E 4 5.50 3.50 5.70 6.00 0.96 0.58
E 5 5.20 3.70 5.50 5.30 0.95 0.70
F 1 3.80 5.00 4.90 5.00 0.78 1.00
F 2 4.50 3.00 5.10 4.70 0.88 0.64
F 3 3.50 4.50 4.70 5.60 0.74 0.80
F 4 4.20 4.60 4.60 5.00 0.91 0.92
F 5 5.50 6.00 5.30 6.00 1.04 1.00
G 1 5.50 3.00 5.90 5.10 0.93 0.59
G 2 5.10 3.50 5.00 5.30 1.02 0.66
G 3 6.20 6.50 6.60 6.30 0.94 1.03
G 4 5.90 3.00 5.60 5.00 1.05 0.60
G 5 5.80 4.50 5.40 5.80 1.07 0.78
H 1 4.80 4.20 4.90 5.50 0.98 0.76
H 2 4.60 4.50 4.80 6.00 0.96 0.75
H 3 4.10 2.80 4.90 4.00 0.84 0.70
H 4 3.80 2.90 4.20 4.80 0.90 0.60
H 5 5.40 3.50 5.10 4.50 1.06 0.78
I 1 4.50 4.00 5.00 5.50 0.90 0.73
I 2 4.50 3.50 5.00 5.00 0.90 0.70
I 3 5.00 3.50 5.50 5.00 0.91 0.70
I 4 4.00 4.00 5.00 5.50 0.80 0.73
I 5 4.50 3.50 5.00 5.00 0.90 0.70
J 1 4.50 3.50 5.00 5.00 0.90 0.70
J 2 4.00 4.00 5.00 5.50 0.80 0.73
J 3 4.50 3.50 4.50 5.00 1.00 0.70
J 4 5.50 3.50 5.50 5.00 1.00 0.70
J 5 4.00 5.00 5.50 6.50 0.73 0.77
K 1 4.30 3.30 5.00 5.00 0.86 0.66
K 2 4.00 4.00 4.60 4.40 0.87 0.91
K 3 3.50 2.50 4.40 4.80 0.80 0.52
K 4 4.60 3.50 4.80 5.00 0.96 0.70
K 5 5.20 2.60 5.90 4.50 0.88 0.58
L 1 3.81 2.54 3.05 5.08 1.25 0.50
L 2 3.18 3.05 4.57 5.08 0.70 0.60
L 3 3.81 3.05 5.08 4.57 0.75 0.67
L 4 4.06 2.54 5.33 4.50 0.76 0.56
L 5 5.00 3.18 5.08 4.83 0.98 0.66

Chela Size

Male Female 4.4560666666666675 3.6858500000000003

Cephalothorax Length

Male Female 5.0068999999999999 5.1676333333333337

Body Size Ratio

Male Female 0.88969986405171464 0.70922850334205567