How to Calculate Range in Excel

how to calculate range in excel
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.

See also : How to Find a Port Number

If the data is spread out in an odd way, you can specify each cell separately by putting a comma between each one. For example, you might type “=MIN(A2, F3, H12, J1)” to find the minimum of the values in cells A2, F3, H12 and J1.

Type “=MAX” into a cell and follow the same steps as for the “MIN” function to use the “MAX” function to find the highest value in the data set.

Range in Excel in Steps

Doing the calculation step by step is the easiest way to use Excel for range. Follow the instructions in the previous step to put the minimum value in one cell (for example, cell E1) and the maximum value in another cell (for example, cell F1). Type “=F1-E1” into another cell to find the range. This tells Excel to find the range by taking the difference between the minimum in cell E1 and the maximum in cell F1.

How to Figure Out Range in One Step

You can also use the above formulas for minimum and maximum to figure out range in a single step in Excel. Imagine you have data running from cell A2 to cell A20. Type “=MAX(A2:A20)-MIN(A2:A20)” to find the range in a single step. This tells Excel to find the most important piece of information and then take away the least important piece of information.