Business & Finance HOMEWORK
RVP2021
BIO100A2024Midtermlabdatasheet1.xlsxInstructions
| This excel sheet contains the tables from the midterm lab manual, but with the formulas included, so as soon as you populate the numbers in the tables you will get the calculations. Cells were your numbers are to be input are highlighted in blue. It is recommended that you save the template first in case you need to go back and redo the calculations | |
Table mid.1
| Bottle | Sugar (tsp) | Yeast amount (tsp) | Water amount (cup) | Yeast solution height (cm) | Temperature | |
| 1 | 1.00 | 2 | 0.25 | Room Temp | ||
| 2 | 1.00 | 2 | 0.25 | Water bath | ||
| 3 | 1.00 | 2 | 0.25 | Water bath | ||
| 4 | 0.33 | 2 | 0.25 | Water bath | ||
| 5 | 0.00 | 2 | 0.25 | Water bath | ||
| 6 | Please write your alternative experiment | 2 | 0.25 | |||
| Average yeast height | ERROR:#DIV/0! | |||||
Table mid.3
| Options | Ballon sizes | Yeast growth | ||||||
| Select from dropdown menu | L | H | ||||||
| Bottle | Balloon size | Yeast growth | M | M | ||||
| 1 | S | L | ||||||
| 2 | N | N | ||||||
| 3 | ||||||||
| 4 | ||||||||
| 5 | ||||||||
| 6 | ||||||||
Table mid.4
| Bottle | Independent variable | Initial Yeast height (cm) | New yeast height (cm) | Yeast growth (cm) |
| 1 | Room temperature | 0 | ||
| 2 | Control 1 | 0 | ||
| 3 | Control 2 | 0 | ||
| 4 | 1/3 tsp sugar | 0 | ||
| 5 | Negative control (no sugar) | 0 | ||
| 6 | 0 | |||
Table mid.5
| Bottle | Circumference (cm) | Top to base (cm) | Radius (cm) | Volume (cm3) | |
| 1 | 0 | 0 | |||
| 2 | 0 | 0 | |||
| 3 | 0 | 0 | |||
| 4 | 0 | 0 | |||
| 5 | 0 | 0 | |||
| 6 | 0 | 0 | |||
