# Kirsop Labs

Skills development for science students everywhere

So you’re working on your physical lab write-up, and looking for the most marks possible. But you just can’t seem to get your head around those pesky errors.

# Learn to Use Excel and Origin

Before I even start to consider uncertainties, my first tip is learn to use both Microsoft Excel and Origin correctly; this makes data analysis, graphing, and more importantly keeping track of, and calculating your errors significantly easier. Personally, I would suggest using Excel for all the data analysis and Origin for graphing and finding the lines of best fit.

In the physical labs there are two distinct types of experimental uncertainty you need to be aware of when conducting and analysing experiments.

1. Those from multiple measurements

2. Those from a single measurement

These should be treated discretely, and I’ll discuss each in turn before showing how to bring them together.

## Uncertainties from Multiple Measurements (or experiments)

Imagine that you’ve completed the same experiment a number of times to produce a series of results e.g., an experiment measuring the activation energy of a reaction. You completed the experiment 12 times and found the activation energy values (Ea) shown in Table 1.

###### Table 1. Sample measurements of Ea (kJ/mol)
 Measurement Ea (kJ/mol) 1 38.542 2 38.751 3 39.016 4 38.768 5 38.943 6 38.426 7 39.124 8 38.546 9 38.864 10 38.687 11 38.579 12 38.798

We can see that no single value is the correct one as they all differ. It’s equally wrong to take the average and quote that alone, because this value is not precisely equal to the ‘real’ average value. So, we must determine the ‘statistical uncertainty’ from this series of experiments. And in finding this, there are 3 important metrics to investigate.

1. The sample mean 2. The sample standard deviation 3. The statistical uncertainty in the sample mean ### Finding the Sample Mean

The sample mean is the ‘average’ that you’ll be familiar with from high school, and it can be found quickly using the “=AVERAGE()” function, in Microsoft Excel. Here, the values used to calculate the sample mean appear within the brackets. Figure 1 shows how this would look on your spreadsheet.

The sample mean is found from Equation 1: (Eqn 1)

n  =  number of values =  sum of all values

This can be easier to think of as adding all the values together and dividing the total by the total number of values.

### Finding the Sample Standard Deviation

The easiest way to find the sample standard deviation is to use the “=STDEV.S()” function, in Microsoft Excel. This is significantly more complex to find without the use of spreadsheet software, and is found by dividing the sum of the square of the differences between each value and the sample mean, and taking the square root.

I have shown the equation below, but strongly emphasise using Excel to do this: (Eqn 2)

n     =  number of values

xi     =  the value, i = the sample mean from (Eqn 1)

Below are examples of what an Excel column looks like with the values highlighted. The “=AVERAGE()” and “=STDEV.S()” functions are included, in order to demonstrate the selected ‘values’: Figure 1. Examples of Microsoft Excel functions in action

### Finding the Statistical Uncertainty in the Sample Mean

Finally, the metric of uncertainty, when considering multiple measurements. The ‘statistical uncertainty’ can be found using a calculator, as it is simply the sample standard deviation divided by the square root of the total number of values (what you divided by to get the sample mean). (Eqn 3)

n  =  number of values

s  =  the sample standard deviation from (Eqn 2)

This is the ‘uncertainty’ that’s quoted with the sample mean, and is the uncertainty that should be propagated through the equation (see Propagation of Errors below).

If you want to try these calculations out for yourself, the sample mean, sample standard deviation and statistical uncertainty for the Ea data are shown here.

If asked to quote the value of the Activation Energy as determined by your experiments you would give:

Ea = 38.753 ± 0.061 kJ/mol

## Uncertainties from a Single Measurement

This ‘uncertainty’ arises from the limited precision of the output display on the measuring ‘instrument/tool/apparatus’. For example, this might be an alcohol thermometer where the scale shows measurements in increments of 2 °C, or the electronic display on a pH meter which shows pH values only to the first decimal place (both examples are shown in Figure 2). Using the example of the pH meter; from the reading (pH = 7.4), all that can be stated with any precision is that the solution pH is somewhere between 7.35 and 7.45. At pH < 7.35, the reading is rounded down to 7.3, and at pH >= 7.45, the reading rounds up to 7.5. This means that the uncertainty associated with this single measurement would be ± 0.05, which is one half of the smallest interval that can be measured.

This rule holds true for the uncertainty of any individual measurement. In the example of the alcohol thermometer, the uncertainty would be ± 1 °C as the interval of measurement is 2 °C. So, for any measurement made, it’s important to note down the uncertainty associated with it.

Now that we have a grasp of these two types of errors, we must consider how to deal with these, and how they affect further analyses.

Figure 2. Two examples of display methods for which an uncertainty should be accounted for.

## Propagation of Errors

Often, an arithmetic operation must be performed on a measured value in order to obtain some other useful value. For example, a car moving over a 100 ± 0.5 m track (the uncertainty in the distance is ‘half the smallest interval in the surveyor’s wheel’), at a speed of 25 ± 1.1 m/s (this uncertainty is the statistical uncertainty of 4 speed measurements made throughout the 100 m track as shown).

 Speed (m/s) 25.8 24.9 26.9 22.4 Sample Mean 25.0 Sample Standard Deviation 2.1 Statistical Uncertainty 1.1

So, to get back to the topic, we can determine the time taken for the car to travel this distance is 4s: t = time

d = distance

v = velocity

However, it is also important to consider how the uncertainty in the measurement of both distance and velocity affects the uncertainty of time. This is called the ‘propagation of errors’.

To find how the uncertainty of a measurement propagates through an equation we must take the derivative of the calculated value with respect to the measured value (if you are struggling with first-order derivatives try using a website such as //www.derivative-calculator.net).

For example, to find how the uncertainty in distance affects the uncertainty in time, we take the derivative of t with respect to d: (Eqn 4) = uncertainty in time with respect to distance = uncertainty in distance

Here we can see that a ‘small change in distance’ (the uncertainty in distance), divided by the constant velocity, v will result in the ‘small change in time’,  (or the uncertainty in time with respect to distance).

Using Lorentz notation (rather than Newtonian) for derivation makes the propagation of errors significantly easier to get to grips with. It’s also important to consider how the error in time is affected by the error in velocity, and for this we take the derivative of t with respect to v: (Eqn 5) = uncertainty in time with respect to velocity = uncertainty in velocity

So, the uncertainty in the velocity, multiplied by the distance, and divided by the velocity squared, will give the effect of the velocity uncertainty on the time uncertainty.

The minus sign can be essentially ignored; as uncertainties are always plus-or-minus the uncertainty should be treated as an absolute value, e.g. magnitude.

Now we have the effect of the distance and the velocity on the time uncertainty, but how should we bring these together to give the overall time uncertainty?

This is done by adding the squares of the smaller uncertainties and taking the square root (additionally this will also turn any rogue negative values into the absolute value): (Eqn 6) = total uncertainty in time

The same formula can also be used to bring together an uncertainty from a single measurement, as well as from many measurements. For example, you measure the pH of a solution 4 times and find it to be 7.4 ± 0.1. However, the single measurement uncertainty is 0.05, which also must be accounted for. So the total ‘uncertainty’ is found with Equation 6, by adding the square of the statistical uncertainty with the square of the single measurement uncertainty.

This total uncertainty will often be very similar to one of the other uncertainties that make it up, but it’s an important step nonetheless, both for thoroughness and to ensure you consider the different uncertainties equally.

So that’s a brief run through of the types of error analysis that should be applied to undergraduate physical labs. It may seem like a lot of work for a few marks, but once you have a good grasp of error analysis, it can be very quick and straightforward. 