*66*

The **standard error of the mean** is a way to measure how spread out values are in a dataset. It is calculated as:

**Standard error = s / âˆšn**

where:

**s**: sample standard deviation**n**: sample size

We can calculate the standard error of the mean for a given dataset in Google Sheets by using the following formula:

=STDEV.S(range of values) / SQRT(COUNT(range of values))

The following example demonstrates how to use this formula.

**Example: Standard Error in Google Sheets**

Suppose we have the following dataset:

The following formula shows how to calculate the standard error of the mean for this dataset:

Â

The standard error of the mean turns out to be **2.0014**.

**How to Interpret the Standard Error of the Mean**

The standard error of the mean is a measure of how spread out values are around the mean. There are two things to keep in mind when interpreting the standard error of the mean:

**1. The larger the standard error of the mean, the more spread out values are around the mean in a dataset.**

To illustrate this, consider if we change the last value in the previous dataset to a much larger number:

Notice how the standard error jumps fromÂ **2.0014Â **toÂ **6.9783**. This tells us that the values in this dataset are more spread out around the mean compared to the previous dataset.

**2. As the sample size increases, the standard error of the mean tends to decrease.**

To illustrate this, consider the standard error of the mean for the following two datasets:

The second dataset is simply the first dataset repeated twice. Thus, the two datasets have the same mean but the second dataset has a larger sample size so it has a smaller standard error.