Introduction to using Excel 2016
Exercises
Instructions for Exercise 2:
For more detailed instructions on how to use Excel to find the Mean value (with associated error) follow this link.
- To convert pressure from mBar to Pa, use this conversion:
1 Bar = 100 000 PaAnd for temperature:
K =° C + 273.15- Your spreadsheet should like this:
- To calculate the mean pressure use Data Analysis in Excel and select Descriptive Statistics. Select Input Range from D2 to D6 and Output Range as A9:
- Your output should look like this:
Now you can go back to Exercise 2.