# How to Calculate Range in Excel

The range of a data set shows you in a simple way how far apart the values are. The range is a good place to start when you’re looking at your data, and you might need to think about it if you’re making a box and whisker plot. Excel’s “MIN” and “MAX” functions make it easy to find the range.

## What does it mean to say “range”?

The range is a simple way to figure out how far apart the values in a set of data are. It’s simple to explain:
Range = maximum value – minimum value

So, if you have a set of numbers like 4, 2, 5, 8, 12, 15, the range is the highest number (15) minus the lowest number (4). (2). In this instance:
Range = 15-2 = 13

This shows that the data set is made up of 13 numbers. In a box and whisker plot, the minimum and maximum values are marked by the ends of the whiskers. This makes it easy to see the range. A large range means that the results are spread out, and a small range means that the data are clustered around a single value.

## MIN and MAX are two functions.

To find a range in Excel, you need to know what the minimum and maximum values are. Type “=MIN” into a cell to find the least amount. Either double-click where it says “MIN” in the drop-down list or type a “(” to begin. Type the letter of the first column and the number of the first row inside the parentheses. If your data is in a single row or column, type a colon, then the letter and number that correspond to the last data point, and then close the parentheses to get the minimum value. You can also do this by clicking the right cell after opening the parentheses, then holding down “Shift” and clicking the cell with the last data point before closing the parentheses.