Introduction to using Excel 2016
Exercises
Instructions for Exercise 1:
- To determine the concentration of Solution 1 you should have used the following equation:
where 2.50 M is the concentration of the stock solution (COld); 10 mL of volume of stock solution were used (VOld) and 50 mL was the volume of the new Solution 1 that was made (VTot).
- To calculate C1,Max and C1,Min you should have used following equations:
where 0.02M is the error in the stock solution (sstock), 0.1 mL is the error of the pipette used (spipette).
- To calculate the associated error of C1 you should have used following equation:
- In Excel, in cells G2, H2, I2 and J2 you should have the following formulas:
Now you can go back to Exercise 1 and extend the calculation for the remaining solutions.