Mathematically, you calculate a range by subtracting the minimum value from the maximum value in a given data set. It represents the spread of values within a data set and is useful for measuring variability: the larger the range, the more spread out and variable your data is.
How to Calculate Range in Excel
Fortunately, finding the range of a set of data is easy using Excel functions. Here's how.
The easiest way to find the range in Microsoft Excel is to use the MIN and MAX functions. The MIN function calculates the largest value in a data set, while the MIN function calculates the smallest value.
First, make sure your data is neatly organized in your worksheet for easy analysis. Then, you can use the MIN and MAX functions as follows:
