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.
- 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).
- Use these equations to find CMax, CMin and error sC:
- 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.