WEB TUTORIAL

Introduction to using Excel 2016

Exercises

 

Instructions for Exercise 1:

  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).

  2. 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).

  3. To calculate the associated error of C1 you should have used following equation:

  4. 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.