2

>Sheet

1

Paired Two Sample for

s

Mean

.4

666667

.68585

70997921

65257568

60

orrelation

ypothesized Mean

ifference

0

																																																																																							t-Test: Don't use plagiarized sources. Get Your Custom Essay on lab report Just from $13/Page Order Essay								Mean
					Variable 1						Variable 2
												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

Variable 1 Variable 2

Mean

69

Variance

Observations 60 60

Hypothesized Mean Difference 0
df 59

t Stat

P(T<=t) one-tail

t Critical one-tail 1.6710930321

P(T<=t) two-tail

t Critical two-tail 2.0009953781

				t-Test: Paired Two Sample for Means
																													5.00		5.1676333333
	0.2994065661		0.3411898972
		Pearson Correlation		0.2298859006
	-1.7720410663
	0.040775582
0.081551164

Sheet3

t-Test: Paired Two Sample for Means

Variable 1 Variable 2

Mean

96998641

92285033

Variance

Observations 60 60

Pearson Correlation

Hypothesized Mean Difference 0
df 59

t Stat

P(T<=t) one-tail 0

t Critical one-tail 1.6710930321

P(T<=t) two-tail 0

t Critical two-tail 2.0009953781

				0.88												0.70
	0.0116323952		0.0125369112
	-0.0033462314
	8.976911006

1121-006

Chela

L

ength Cephalothorax

Length B

ody Size Ratio Chela Size

Cephalothorax Length Body Size Ratio
G

roup Crayfish Male F

emale

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

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?