How to Plot Mean and Standard Deviation in Excel

In this tutorial, you will learn how to plot mean and standard deviation in Excel.

An average is a simple mathematical average of a set of two or more numbers. The average of a given set of numbers can be calculated in several ways, including the arithmetic average method, which uses the sum of the series of numbers, and the geometric average method, which uses the average of the range of products. However, all of the major methods of computing the simple mean return approximately the same approximation.

Standard deviation is a statistic that measures the spread of a data set about its mean and is calculated as the square root of the variance. Standard deviation is calculated as the square root of variance by determining the deviation of each data point from the mean.

If the data points are far from the mean, there will be more variation within the data set. Therefore, the wider the data, the higher the standard deviation.

Once ready, we’ll get started by utilizing real-world examples to show you how to plot mean and standard deviation in Excel.

Plot Mean and Standard Deviation in Excel

Before we begin we will need a group of data to plot mean and standard deviation in Excel.

Step 1

First, you need to have a clean and tidy group of data.

Step 2

First we will calculate the mean and standard deviation for the 3 classes. You can easily calculate the mean with this formula =AVERAGE(B2:E2).

Step 3

We will then calculate the standard deviation with this formula =STDEV(B2:E2).

Step 4

Now we can plot the mean by selecting ‘Insert’, then select ‘Clustered Column’.

Step 5

We can then add the standard deviation into the column chart as well by selecting ‘Chart Design’, select ‘Add Chart Element’, select ‘Error Bars’ and select ‘Standard Error’.

Step 6

Next, we will customize the error bars by selecting the range of standard deviation that we have calculated.

Step 7

Once we are done, the chart will look like this.