# How To Make Jitter Plots In Excel

A Jitter Plot is a type of data visualization used to dsiplay the distribution of a set of numerical data points. It is particularly useful when you have a small dataset and want to visualize the distribution of values.

This guide gives you an introduction to Jitter Plots, why you should use them, and how to make them in Excel.

##### What is jitter, and why should you use it?

Some charts are difficult to read because their values overlap. This happens a lot when you’re working with survey data that uses a pseudo-interval scale such as the numerical scale of 1-10 or 0-10.

Look at this plot showing the relationship between satisfaction with product range and overall satisfaction. There’s no distinction between the points where there’s just one customer, and those where lots of customers have given the same pair of scores.  By “jittering” the plot, in other words by adding a small random variation to where each point is plotted, we can make the chart much easier to read and more informative: Jitter can also be useful when you want to understand the distribution of a single variable, such as the Customer Satisfaction Index (CSI). We can plot all the responses as a dot plot, but even with a continuous variable there is a great deal of overlap: We can add some random jitter to spread out the dots and make the pattern easier to see: Even better, we can make the amount of spread proportional to the number of nearby dots, so the shape of the plot reflects the distribution of scores: ### =RAND()

The built in RAND() function generates a random number between 0 and 1, so we use that as our basis.

### +(RAND()-0.5)

Adding RAND() to each value we want to jitter will move it randomly, but also add a positive bias - on average each dot will be shifted 0.5 to the right. We can offset that by subtracting 0.5:

### +(RAND()-0.5)/4

That works, but it tends to give a spread that is too wide. We can control the spread by dividing the amount to jitter by a constant, Something in the region 3-5 often works well:

##### Here’s how that looks: # Summary

Excel’s RAND() function makes it easy to jitter the points of a scatter or dot plot so that you can visualise your data more effectively. A few little tweaks to the formula can help make sure your charts are effective and easy to read.

## Want to Know More?

Send us a message if you would like to learn more about analysis techniques in customer research. Sign up and receive a monthly collection of interesting articles and opinion pieces on a range of customer experience and research topics.