WEB TUTORIAL

Introduction to using Excel 2016

Exercises

 

Instructions for Exercise 3:

For more detailed instructions on how to use Excel to find the Mean value (with associated error) follow this link.

  1. To calculate the concentration, rearrange the Ideal Gas equation to obtain this:

    Where n/V = concentration (C) (mol m-3); R = gas constant (8.314 J mol-1K-1); T = temperature (K).

  2. Use these equations to find CMax, CMin and error sC:

  3. Further input all your data into Excel and do the calculation. Your spreadsheet should look like this:

    Now you can go back to Exercise 3.