Spreadsheet: 119945d1314880078-excel-2007-bizarre-diagonal-lines-joining-up-data-points-completed-avgs-microbial
Sheet: Sheet1

Microbiology Techniques 2011 Class Data: Group 1 (with toilet), Group 2 (without toilet)
ID No |  |  | PLAQUE SAMPLE (cells per gram) |  |  |  |  |  | ID No |  |  | TOOTHBRUSH (Cells per head) |  |  |  |  |  | ID No |  |  | SINK SURFACE (cells per square cm) |  |  |  |  |  | ID No |  |  | TAP WATER (cells per mL)
 | CBA | R2A | PYO | LTA37 | LTA44 | ME (fil fungi) | ME (yeasts) |  |  | CBA | R2A | PYO | LTA37 | LTA44 | ME (fil fungi) | ME (yeasts) |  |  | CBA | R2A | PYO | LTA37 | LTA44 | ME (fil fungi) | ME (yeasts) |  |  | CBA | R2A | PYO | LTA37 | LTA44 | ME (fil fungi) | ME (yeasts)
Group 1 |  |  |  |  |  |  |  |  | Group 1 |  |  |  |  |  |  |  |  | Group 1 |  |  |  |  |  |  |  |  | Group 1
2 | 1821705426 | 1266149871 | 0 | 0 | 0 | 31008 | 2403100 |  |  | 3500000 | 1875000 | 0 | 0 | 0 | 1500 | 3500 |  |  | 33112500 | 750000 | 0 | 0 | 0 | 1125 | 753 |  |  | 675 | 2100 | 0 | 0 | 0 | 375 | 50
3 | 670000000 | 41800000000 | 0 | 0 | 0 | 0 | 52000 |  |  | 1500000 | 2500000 | 4050 | 2850 | 0 | 1500 | 500 |  |  | 150000 | 7500 | 0 | 0 | 5 | 250 | 25 |  |  | 45 | 95 | 0 | 0 | 0 | 25 | 5
5 | 0 | 77000000 | 0 | 0 | 0 | 1292 | 0 |  |  | 25000000 | 14000000 | 28000 | 49000 | 11000 | 0 | 37000 |  |  | 3000 | 30000 | 0 | 42 | 0 | 13 | 438 |  |  | 100 | 125 | 0 | 0 | 0 | 5 | 5
9 | 1534625323 | 1698191214 | 0 | 0 | 0 | 64591 | 81395 |  |  | 750000 | 225000 | 0 | 0 | 0 | 25 | 75 |  |  | 125000 | 8750 | 0 | 0 | 0 | 500 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 3 | 0
10 | 45200000 | 43400000 | 0 | 0 | 0 | 25800 | 25800 |  |  | 725000 | 8300000 | 0 | 0 | 0 | 500 | 7750 |  |  | 12500 | 12500 | 0 | 0 | 0 | 250 | 250 |  |  | 10 | 275 | 0 | 0 | 0 | 10 | 5
13 | 12500 | 2750 | 0 | 0 | 0 | 50 | 125 |  |  | 1500000 | 120000 | 400 | 200 | 250 | 100 | 250 |  |  | 12500 | 2750 | 0 | 0 | 0 | 50 | 125 |  |  | 5 | 25 | 0 | 0 | 0 | 10 | 0
14 | 0 | 180878553 | 0 | 0 | 0 | 517 | 1550 |  |  | 1000000 | 32500 | 0 | 0 | 0 | 50 | 30 |  |  | 3975000 | 1060000 | 0 |  |  | 14800 | 0 |  |  | 930 | 105 | 0 | 20 | 0 | 50 | 0
18 | 23255814 | 47803618 | 0 | 0 | 0 | 5168 | 20672 |  |  | 650000 | 470000 | 0 | 45200 | 0 | 100 | 4250 |  |  | 30000 | 2750 | 0 | 0 | 0 | 375 | 500 |  |  | 905 | 275 | 0 | 0 | 0 | 5 | 5
20 | 1700000000 | 750000000 | 0 | 49000000 | 0 | 78000 | 930000 |  |  | 450000 | 30000 | 0 | 0 | 50 | 700 | 0 |  |  | 20000 | 3500 | 0 | 0 | 0 | 3000 | 2000 |  |  | 10 | 0 | 0 | 0 | 0 | 1 | 2
26 | 341085271 | 60723514 | 0 | 0 | 0 | 38760 | 403101 |  |  | 175000 | 112500 | 0 | 0 | 0 | 100 | 25 |  |  | 187500 | 6125 | 29 | 128 | 109 | 125 | 863 |  |  | 85 | 800 | 0 | 0 | 0 | 0 | 53
29 | 1036000 | 6460000 | 0 | 0 | 0 | 0 | 5168 |  |  | 2500000 | 575000 | 50 | 125 | 0 | 500 | 1500 |  |  | 200000 | 28750 | 25 | 0 | 0 | 625 | 875 |  |  | 0 | 473 | 0 | 0 | 0 | 40 | 28
33 | 1510000 | 1180000 | 0 | 0 | 0 | 92 | 370 |  |  | 39000000 | 2310000 | 0 | 0 | 0 | 50 | 300 |  |  | 1150000 | 5250 | 0 | 0 | 0 | 375 | 1000 |  |  | 25 | 35 | 0 | 0 | 0 | 10 | 8
34 | 20671834 | 25839793 | 0 | 0 | 0 | 0 | 2584 |  |  | 3000000 | 10000 | 0 | 0 | 0 | 50 | 800 |  |  | 0 | 4000 | 0 | 0 | 0 | 0 | 150 |  |  | 0 | 50 | 0 | 0 | 0 | 5 | 0
36 | 280000000 | 350000000 | 0 | 0 | 0 | 26000 | 0 |  |  | 0 | 40000 | 0 | 0 | 0 | 280 | 330 |  |  | 2500 | 2875 | 5 | 17 | 0 | 250 | 150 |  |  | 10 | 800 | 0 | 0 | 0 | 5 | 0
37 | 547718 | 622407 | 0 | 0 | 0 | 125 | 42 |  |  | 2500000 | 1050000 | 0 | 0 | 0 | 200 | 350 |  |  | 10000 | 4000 | 0 | 0 | 0 | 25 | 0 |  |  | 15 | 100 | 0 | 0 | 0 | 15 | 10
41 | 85271318 | 96899225 | 0 | 0 | 0 | 7752 | 1292 |  |  | 125000 | 325000 | 0 | 0 | 0 | 75 | 2525 |  |  | 8750 | 4000 | 533 | 1360 | 220 | 4250 | 2500 |  |  | 13 | 185 | 0 | 0 | 0 | 20 | 13
43 | 2447711 | 256350000 | 0 | 0 | 0 | 8 | 204 |  |  | 6000000 | 65000000 | 0 | 0 | 0 | 10000 | 2000 |  |  | 50000 | 400000 | 0 | 0 | 0 | 175 | 1000 |  |  | 105 | 320 | 0 |  | 0 | 5 | 95
44 | 34752 | 251949 | 0 | 0 | 0 | 9 | 87 |  |  | 11000000 | 130000 | 0 | 0 | 0 | 5000 | 2500 |  |  | 200000 | 15750 | 0 | 0 | 0 | 20 | 15 |  |  | 50 | 110 | 0 | 0 | 0 | 40 | 30
45 | 103000000 | 76200000 | 0 | 0 | 0 | 310000 | 36000 |  |  | 89000000 | 400000 | 0 | 0 | 0 | 3000 | 400 |  |  | 200000 | 7000 | 0 | 0 | 0 | 800 | 1800 |  |  | 265 | 180 | 0 | 20 | 20 | 33 | 13
47 | 90000000 | 3800000 | 646 | 904 | 0 | 6460 | 3876 |  |  | 0 | 75000 | 16250 | 11400 | 5850 | 500 | 0 |  |  | 75000 | 2625 | 370 | 273 | 0 | 375 | 0 |  |  | 5 | 43 | 0 | 0 | 0 | 8 | 0
AVERAGE
SDEV
SE |  |  |  |  |  |  |  |  | SE |  |  |  |  |  |  |  |  | SE |  |  |  |  |  |  |  |  | SE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ID No
ID No |  |  | PLAQUE SAMPLE (cells per gram) |  |  |  |  |  | ID No |  |  | TOOTHBRUSH (Cells per head) |  |  |  |  |  | ID No |  |  | SINK SURFACE (cells per square cm) |  |  |  |  |  |  |  |  | TAP WATER (cells per mL)
 | CBA | R2A | PYO | LTA37 | LTA44 | ME (fil fungi) | ME (yeasts) |  |  | CBA | R2A | PYO | LTA37 | LTA44 | ME (fil fungi) | ME (yeasts) |  |  | CBA | R2A | PYO | LTA37 | LTA44 | ME (fil fungi) | ME (yeasts) |  | Group 2 | CBA | R2A | PYO | LTA37 | LTA44 | ME (fil fungi) | ME (yeasts)
Group 2 |  |  |  |  |  |  |  |  | Group 2 |  |  |  |  |  |  |  |  | Group 2
1 | 62000000 | 83000000 | 0 | 0 | 0 | 7800 | 47000 |  |  | 5500000 | 1100000 | 28000 | 51200 | 37200 | 400 | 500 |  |  | 45000 | 1100000 | 0 | 5 | 0 | 3000 | 1000 |  |  | 40 | 380 | 0 | 0 | 0 | 30 | 25
4 | 0 | 7751938 | 0 | 0 | 0 | 25840 | 0 |  |  | 48000000 | 2400000 |  |  | 0 | 50 | 2350 |  |  | 10000 | 95000 | 60 | 65 | 0 | 100 | 500 |  |  | 20 | 85 | 0 | 0 | 5 | 10 | 10
6 | 0 | 2967359 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 750000 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 174000 | 0 | 0 | 0 | 25 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
7 | 868000000 | 724000000 | 0 | 0 | 0 | 129000 | 3410000 |  |  | 50000 | 650000 | 0 | 50 | 0 | 150 | 100 |  |  | 5000 | 4750 | 0 | 0 | 0 | 1000 | 750 |  |  | 60 | 18 | 0 | 5 | 0 | 35 | 0
8 | 25839793 | 930000000 | 0 | 0 | 0 | 510000 | 3300000 |  |  | 15000000 | 8000000 | 500 | 500 | 0 | 3000 | 3000 |  |  | 250000 | 37500 | 0 | 0 | 0 | 2500 | 5000 |  |  | 250 | 950 | 0 | 0 | 0 | 50 | 250
11 | 660000000 | 540000000 | 0 | 0 | 0 | 2584 | 0 |  |  | 14750000 | 3475000 | 0 | 0 | 0 | 0 | 630 |  |  | 5000 | 3375 | 0 | 0 | 0 | 88 | 25 |  |  | 10 | 33 | 0 | 5 | 35 | 5 | 5
12 | 89447 | 94035 | 0 | 0 | 0 | 161 | 46 |  |  | 4250000 | 210000 | 0 | 0 | 0 | 3000 | 0 |  |  | 15000 | 23750 | 61 | 44 | 8 | 0 | 125 |  |  | 27 | 10 | 0 | 0 | 0 | 80 | 0
15 | 0 | 180000 | 0 | 0 | 0 | 1400 | 78000 |  |  | 320000000 | 5900000 | 0 | 50 | 0 | 0 | 1100 |  |  | 190000 | 190000 |  |  | 12 | 15 | 13 |  |  | 0 | 8 | 0 | 0 | 0 | 0 | 6
16 | 5167959 | 452196382 | 0 | 0 | 0 | 1292 | 5168 |  |  | 1750000 | 3900000 | 0 | 50 | 0 | 250 | 1750 |  |  | 87500 | 37500 | 0 | 0 | 2 | 25 | 600 |  |  | 14 | 169 | 0 | 0 | 0 | 5 | 14
17 | 20671834 | 645994832 | 0 | 258 | 0 | 258 | 51680 |  |  | 1500000 | 200000 | 0 | 0 | 0 | 100 | 50 |  |  | 25000 | 26000 | 0 | 0 | 0 | 500 | 0 |  |  | 20 | 150 | 0 | 0 | 0 | 5 | 0
19 | 75522 | 257462 | 0 | 0 | 0 | 64 | 0 |  |  | 1800000 | 4300000 | 0 | 0 | 0 | 100 | 150 |  |  | 110000 | 4250 | 0 | 0 | 1500000 | 50 | 63 |  |  | 10 | 54 | 0 | 0 | 0 | 5 | 8
21 | 62000000 | 67000000 | 0 | 0 | 0 | 0 | 5200 |  |  | 11000000 | 450000 | 200 | 150 | 0 | 500 | 500 |  |  | 330000 | 40000 | 580 | 660 | 405 | 500 | 36000 |  |  | 5 | 40 | 0 | 0 | 0 | 0 | 3
22 | 38759690 | 16795656 | 0 | 0 | 0 | 0 | 0 |  |  | 1750000 | 840000 | 50 | 0 | 0 | 50 | 100 |  |  | 15000 | 300000 | 0 | 0 | 0 | 100 | 50 |  |  | 20 | 30 | 0 | 0 | 0 | 5 | 5
23 | 36000000 | 3900000000 | 0 | 0 | 0 | 59000 | 130000 |  |  | 1000000 | 380000 | 0 | 0 | 0 | 1000 | 1000 |  |  | 230000 | 8750 | 20 | 30 | 0 | 65 | 83 |  |  | 120 | 4000 | 0 | 0 | 0 | 5000 | 60
24 | 10400000 | 17000000 | 0 | 0 | 0 | 2500 | 95000 |  |  | 2500000 | 375000 | 0 | 0 | 0 | 30 | 500 |  |  | 1182000000 | 149000000 | 0 | 0 | 0 | 1020 | 25700 |  |  | 0 | 40 | 0 | 0 | 0 | 13 | 8
25 | 1900000000 | 2400000000 | 0 | 0 | 0 | 110000 | 18000 |  |  | 35000000 | 50000 | 0 | 0 | 0 | 500 | 0 |  |  | 20000 | 1000 | 3 | 0 | 0 | 25 | 0 |  |  | 60 | 65 | 0 | 0 | 0 | 0 | 0
27 | 1160000000 | 1060000000 | 0 | 0 | 0 | 0 | 0 |  |  | 500000 | 50000 | 0 | 0 | 0 | 50 | 100 |  |  | 0 | 3000 | 0 | 0 | 0 | 50 | 25 |  |  | 0 | 720 | 0 | 0 | 0 | 0 | 0
28 | 3617571059 | 23255814 | 517 | 258 | 258 | 2583 | 5168 |  |  | 350000000 | 1500000 | 50 | 0 | 0 | 3500 | 14000 |  |  | 5000 | 1250 | 0 | 0 | 0 | 150000 | 50000 |  |  | 25 | 70 | 0 | 0 | 0 | 35 | 5
30 | 720000000 | 2000000000 | 260 | 520 | 0 | 3600 | 0 |  |  | 300000 | 250000 | 0 | 0 | 0 | 500 | 2000 |  |  | 20000 | 11000 | 0 | 50 | 0 | 200 | 50 |  |  | 25 | 170 | 0 | 0 | 0 | 25 | 0
32 | 77500000 | 413000000 | 0 | 0 | 0 | 5200 | 103000 |  |  | 1000000 | 80000 | 0 | 0 | 0 | 50 | 500 |  |  | 75000 | 17500 | 0 | 0 | 0 | 75 | 50 |  |  | 20 | 1640 | 0 | 0 | 0 | 15 | 20
35 | 144702842 | 179586563 | 0 | 0 | 0 | 90439 | 3876 |  |  | 510000000 | 25000000 | 0 | 0 | 0 | 5000 | 0 |  |  | 1125000 | 2250000 | 0 | 0 | 0 | 500 | 250 |  |  | 5 | 21 | 0 | 0 | 0 | 3 | 0
38 | 12000 | 6200000 | 12000000 | 0 | 0 | 100000 | 10000 |  |  | 800000 | 15000 | 0 | 0 | 0 | 100 | 0 |  |  | 2500 | 350 | 0 | 0 | 0 | 250 | 0 |  |  | 2 | 160 | 0 | 0 | 0 | 0 | 0
39 | 12919897 | 12979897 | 0 | 0 | 0 | 5168 | 2403100 |  |  | 200000 | 375000 | 0 | 0 | 0 | 1500 | 0 |  |  | 75000 | 125000 | 0 | 0 | 0 | 25 | 150 |  |  | 43 | 465 | 0 | 0 | 0 | 0 | 0
40 | 86000000 | 250000000 | 258 | 1292 | 0 | 1292 | 261000 |  |  | 175000 | 305000 | 0 | 500 | 0 | 1500 | 2500 |  |  | 8750 | 3000 | 0 | 0 | 3 | 100 | 100 |  |  | 1 | 85 | 0 | 0 | 0 | 3 | 3
42 | 64600 | 0 | 0 | 258 | 0 | 0 | 1750 |  |  | 20500000 | 82300000 | 0 | 50 | 0 | 0 | 3000 |  |  | 0 | 53 | 0 | 0 | 0 | 0 | 33 |  |  | 1130 | 238 | 0 | 0 | 0 | 0 | 25
46 | 155038760 | 25839793 | 1034 | 5168 | 0 | 51680 | 51680 |  |  | 100000 | 1500000 | 0 | 50 | 0 | 500 | 1000 |  |  | 125000 | 10000 | 0 | 0 | 0 | 500 | 0 |  |  | 10 | 75 | 0 | 0 | 0 | 10 | 0
48 | 2900000 | 880000000 | 0 | 0 | 0 | 0 | 0 |  |  | 1680000 | 2750000 |  |  |  |  |  |  |  | 290000 | 50000 | 0 | 0 | 0 | 10 | 250 |  |  | 30 | 600 | 0 | 0 | 0 | 55 | 5
50 | 2583979 | 49095607 | 0 | 0 | 0 | 155038 | 0 |  |  | 4000000 | 100000 | 0 | 0 | 0 | 150 | 200 |  |  | 375000 | 6250 | 100 | 75 | 0 | 750 | 250 |  |  | 25 | 150 | 5 | 0 | 0 | 20 | 30
51 | 100000000 | 9300000 |  |  |  | 5000 | 0 |  |  | 0 | 200000 | 0 | 0 | 0 | 3500 | 500 |  |  | 0 | 20000 | 0 | 0 | 0 | 50 | 75 |  |  | 0 | 25 | 0 | 0 | 0 | 5 | 5
52 | 39018088 | 6976744 | 0 | 0 | 0 | 0 | 2584 |  |  | 1500000 | 110000 | 0 | 0 | 0 | 100 | 0 |  |  | 0 | 12500 | 0 | 0 | 0 | 150 | 25 |  |  | 0 | 50 | 0 | 0 | 0 | 10 | 0
53 | 34000000 | 39000000 | 250 | 0 | 0 | 1000 | 5200 |  |  | 2000000 | 5500000 | 0 | 0 | 0 | 150 | 50 |  |  | 125000 | 40000 | 0 | 0 | 0 | 3 | 0 |  |  | 150000 | 250000 | 0 | 0 | 0 | 15 | 0
AVERAGE
SDEV
SE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SE