lab report
>Sheet Paired Two Sample for s
.4 666667
.68585
70997921
65257568
60 orrelation
ypothesized Mean ifference
0 Variable 1 Variable 2 69
Observations 60 60 Hypothesized Mean Difference 0 t Critical one-tail 1.6710930321 t Critical two-tail 2.0009953781 Variable 1 Variable 2 96998641
92285033
Observations 60 60 Hypothesized Mean Difference 0 t Critical one-tail 1.6710930321 t Critical two-tail 2.0009953781 ength
Length
ody Size Ratio
Cephalothorax Length Body Size Ratio roup
emale
Male Female Male Female Male Female Male Female Male Female 1 5.00 0.70 Mean 5.10 0.75 0.11 0.58 60 60 60 60 60 60 5.00 0.71 A 5 4.20 4.50 5.00 0.93
2
1
t-Test:
Mean
Variable 1
Variable 2
Mean
4
5
6
0
3
Variance
0.56
0.69
Observations
60
Pearson
C
0.2793049441
H
D
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
Mean
5.00
5.1676333333
Variance
0.2994065661
0.3411898972
Pearson Correlation
0.2298859006
df 59 t Stat
-1.7720410663
P(T<=t) one-tail
0.040775582
P(T<=t) two-tail
0.081551164
Sheet3
t-Test: Paired Two Sample for Means
Mean
0.88
0.70
Variance
0.0116323952
0.0125369112
Pearson Correlation
-0.0033462314
df 59 t Stat
8.976911006
P(T<=t) one-tail 0
P(T<=t) two-tail 0
1121-006
Chela
L
Cephalothorax
B
Chela Size
G
Crayfish
Male
F
A
4.20
3.50
5.10
0.82
4.46
3.69
5.01
5.17
0.89
0.71
A 2
4.10
3.80
4.50
0.91
0.75
SD
0.83
0.55
0.58
0.11
A 3
4.00
3.10
4.30
5.30
0.93
N
A 4
3.70
3.40
4.80
0.74
3.00
0.60
Body Size Ratio
Cephalothorax Length t-Test: Paired Two Sample for Means
5.00 5.30 0.80 0.74 t-Test: Paired Two Sample for Means t-Test: Paired Two Sample for Means
0.91 Variable 1 Variable 2
4.50
0.75 Variable 1 Variable 2 Variable 1 Variable 2 Mean 0.8896998641
Mean
5.1676333333 Variance 0.0116323952 0.0125369112
3.80 6.00
0.93
Variance 0.5670997921 0.6965257568 Variance 0.2994065661 0.3411898972 Observations 60 60
3.80 4.90 5.30
Observations 60 60 Observations 60 60 Pearson Correlation -0.0033462314
3.40 4.80 4.50 0.69 0.76 Pearson Correlation 0.2793049441 Pearson Correlation 0.2298859006 Hypothesized Mean Difference 0
0.69
Hypothesized Mean Difference 0 Hypothesized Mean Difference 0 df 59
4.80 4.30
0.65 df 59 df 59 t Stat 8.976911006
t Stat 6.2454168103 t Stat -1.7720410663 P(T<=t) one-tail 0
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
4.70 0.87
t Critical one-tail 1.6710930321 t Critical one-tail 1.6710930321
5.20 4.80 0.87 0.56
4.80 4.20
1 4.30 4.30 4.70 6.50 0.91
0.71
0.58
0.70
1.00
6.50
0.60
5.80
0.78
0.76
4.20 4.80 0.90 0.60
0.78
1 4.50 4.00 5.00 5.50 0.90
1 4.50 3.50 5.00 5.00 0.90 0.70
1 4.30 3.30 5.00 5.00
0.66
4.40 4.80 0.80
5.90 4.50 0.88 0.58
3.05
5.08 0.70 0.60
2.54
4.50 0.76 0.56
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
Data Collection Procedures:
*Feel free to use the data table on the bottom of the page instead of the blanks at the top of the page.
-Do only 1 gender group at a time to avoid mixing up male & female crayfish.
-Work in pairs.
-Take 5 male crayfish OR 5 female crayfish.
Once you are done with them you will still keep them at your table to avoid multiple measures of the same crayfish.
-Get the length of the chela _____________ (A)
-Get the length of the cephalothorax _____________ (B)
-What is your ratio? ___________________(A/B)
Once you have your measurements for your crayfish, enter them into the class spreadsheet on the computer.
Analysis Procedures
:
The hypotheses you have made can be tested using the Students t-test (as you did in 1111).
We are going to be using Excel to run our data analysis. You will not be doing the statistical testing by hand (this is because rounding and other human error can cause enormously variable results in data analysis)
You can compare the t-stat and t-crit to determine if you should reject or fail to reject your null hypothesis. If the p<0.05, you can reject the H0 because 95% confidence that the variance you see is not due to sampling error. However, if the p>0.05, you fail to reject the H0 because the observed differences are likely due to sampling error.
Conduct a t-test and analyze the data for chela length, cephalothorax length and the body size ratio using male and female as your comparison groups But how do I run a t-test in Excel?
Make bar graphs in Excel- one for each of the variables above for your paper. How do I do this?
Each graph should show means + S.D. for each variable using error bars. How do I add error bars and what do they represent?