Overview
This finds the smallest and largest of your numbers, along with the range between them. The range is a quick first measure of how spread out data are.
Enter your values in any order. Negative numbers and decimals are fine.
Worked examples
| Inputs | Result |
|---|---|
| Your numbers12, 16, 14, 21, 19 | Min: 12Max: 21Range: 9 |
Show 2 more examples
| Your numbers-8, -2, 3, 0, 7 | Min: -8Max: 7Range: 15 |
| Your numbers2.5, 2.05, 2.55, 2.505, 2 | Min: 2Max: 2.55Range: 0.55 |
How it works
Each value is compared to find the lowest and highest. The range is the maximum minus the minimum. Because the range depends on only two values, one unusual data point can change it a lot.
The formula
Practical tips
- For 12, 16, 14, 21 and 19, the minimum is 12, the maximum is 21 and the range is 9.
- With negatives, the minimum is the furthest below zero. The minimum of −8, −2 and 3 is −8.
- Check extreme values before relying on them, since a typing error often appears as a surprising max or min.
Frequently asked questions
What's the range used for?
It's a quick view of spread. For more detail, use the interquartile range or standard deviation.
Can minimum and maximum be the same?
Yes, if all the values are equal, and the range is then 0.
How do I find max and min in Excel?
Use =MIN(A1:A5) and =MAX(A1:A5).