XL Spreadsheets for Natural Selection Laboratory - Bacteria and Antibiotics
Evolutionary Biology BI 25, Saint Anselm College
| Sample | ||||||
| Group | Jon, Mary | See calculations in manual | See calculations in manual | |||
| Bacteria | E. coli | |||||
| Plate # | Antibiotic | Agar Plate Diameter (cm) | Agar Plate area | Diamter of antibiotic circle (cm) | Antibiotic circle area | Antibiotic area/Agar Plate area = s coefficient |
| 1 | chl | 20 | 314.2857143 | 2 | 3.142857143 | 0.01 |
| 2 | tetra | 20 | 314.2857143 | 1.1 | 0.950714286 | 0.003025 |
| 3 | penic | 20 | 314.2857143 | 10.9 | 93.35071429 | 0.297025 |
| 4 | erythr | 20 | 314.2857143 | 3.5 | 9.625 | 0.030625 |
| 5 | amp | 20 | 314.2857143 | 2.2 | 3.802857143 | 0.0121 |
| 6 | other | 20 | 314.2857143 | 1 | 0.785714286 | 0.0025 |
| Group | ||||||
| Bacteria | ||||||
| Plate # | Antibiotic | Agar Plate Diameter (cm) | Agar Plate area | Diamter of antibiotic circle (cm) | Antibiotic circle area | Antibiotic area/Agar Plate area = s coefficient |
| 1 | chl | |||||
| 2 | tetra | |||||
| 3 | penic | |||||
| 4 | erythr | |||||
| 5 | amp | |||||
| 6 | other |