Do Not Reply until read assingment understand it ans capable of doing please BIOLOGY LAB EXCELL

profilejudykudge
worm-data-2015.xls
Home>Biology homework help>Do Not Reply until read assingment understand it ans capable of doing please BIOLOGY LAB EXCELL

Sheet4

Sheet5

Sheet6

t-Test: Two-Sample Assuming Unequal Variances
Variable 1 Variable 2
Mean 11.02 14.5744680851
Variance 16.1016326531 18.7280296022
Observations 50 47
Hypothesized Mean Difference 0
df 93
t Stat -4.1875230853
P(T<=t) one-tail 0.0000320153
t Critical one-tail 1.6614036742
P(T<=t) two-tail 0.0000640306
t Critical two-tail 1.9858017682

Sheet1

Table 1. Lifespans of class I and class II worms Table 2. Results of selfing class II worm
---------class I worms--------- ---------class II worms---------
Worm # lifespan (days) Worm # lifespan (days) Worm # Intestinal development lifespan (days)
1 15 1 13 1 severely abnormal 18
2 10 2 18 2 abnormal 17
3 13 3 13 3 normal 12
4 9 4 17 4 severely abnormal 20
5 6 5 20 5 severely abnormal 22
6 17 6 10 6 abnormal 19
7 12 7 9 7 normal 10
8 7 8 17 8 severely abnormal 22
9 5 9 16 9 abnormal 11
10 8 10 12 10 abnormal 20
11 12 11 12 11 abnormal 14
12 5 12 15 12 normal 5
13 13 13 22 13 abnormal 15
14 10 14 14 14 normal 11
15 7 15 21 15 abnormal 21
16 7 16 13 16 abnormal 20
17 16 17 10 17 abnormal 12
18 12 18 19 18 severely abnormal 22
19 5 19 21 19 severely abnormal 17
20 14 20 10 20 abnormal 17
21 6 21 14 21 abnormal 13
22 13 22 11 22 normal 14
23 15 23 10 23 normal 12
24 11 24 21 24 normal 9
25 15 25 12 25 abnormal 15
26 7 26 11 26 abnormal 14
27 13 27 12 27 normal 8
28 5 28 17 28 severely abnormal 22
29 12 29 20 29 severely abnormal 26
30 5 30 13 30 abnormal 12
31 15 31 8 31 normal 5
32 11 32 12 32 abnormal 12
33 6 33 22 33 abnormal 17
34 14 34 11 34 abnormal 22
35 15 35 13 35 abnormal 13
36 15 36 10 36 abnormal 16
37 8 37 11 37 normal 13
38 13 38 21 38 abnormal 12
39 12 39 11 39 normal 13
40 16 40 22 40 abnormal 17
41 16 41 13 41 abnormal 11
42 16 42 11 42 normal 13
43 6 43 12 43 normal 7
44 14 44 19 44 severely abnormal 22
45 14 45 12 45 severely abnormal 27
46 15 46 11 46 severely abnormal 18
47 17 47 23 47 normal 7
48 5 48 normal 12
49 13 49 abnormal 14
50 3 50 abnormal 12
n 51 abnormal 17
mean 52 abnormal 16
SEM 53 severely abnormal 22
max 54 severely abnormal 20
min 55 abnormal 18
56 abnormal 21
57 abnormal 18
58 normal 14
59 abnormal 16
60 abnormal 15
61 abnormal 16
62 severely abnormal 19
63 severely abnormal 19
64 abnormal 12
65 abnormal 12
66 abnormal 13
67 abnormal 15
68 normal 7
69 severely abnormal 17
70 abnormal 12
n of normal
mean lifespan of normal
SEM lifespan normal
max
min
n of abnormal
mean lifespan of abnorm
SEM lifespan of abnormal
max
min
n of severe
mean lifespan of severe
SEM lifespan of severe
max
min

Sheet2

Sheet3