Download Article
Find the midpoint of the upper and lower boundaries of a dataset
Download Article
The midrange is the average of the range of a set of numbers, or the sum of the highest and lowest numbers divided by two. This quick equation can help you estimate the middle point of a set of numbers, similar to the mean or median. However, midrange is more useful for some datasets than others, so keep reading to learn when you should use it versus median.
Calculating Midrange
To calculate midrange, find the highest and lowest numbers in a data set. Add the numbers together, then divide the sum by two.
Steps
Section 1 of 3:
Finding the Midrange of a Dataset
Download Article
-
Determine the highest and lowest values in a set. The midrange is the average of the range of a dataset. The range is how far a dataset spans, so it starts with the lowest number and ends with the highest. [1] X Research source
- For example, if you had the dataset 10, 45, 13, 70, 55, and 40, it ranges from 10 to 70, so 10 and 70 are the numbers you would work with.
- If you’re also calculating the range of a set, subtract the lowest number from the highest. So the range of the above set is 60.
- For example, if you had the dataset 10, 45, 13, 70, 55, and 40, it ranges from 10 to 70, so 10 and 70 are the numbers you would work with.
-
Take the average of the highest and lowest values. To get the midrange, add the lowest and highest values together and divide them by two. [2] X Research source Midrange describes the central tendency across a spread of numbers and divides the range (or the boundaries of the set) in two.
- So, for the dataset 10, 45, 13, 70, 55, and 40, the midrange is 40.
Advertisement
Section 2 of 3:
Finding Midrange on Excel
Download Article
-
Input all your data in a column. Start by typing each value into a separate cell in one column or row on your sheet.
-
Find the highest and lowest values using the min and max commands. In another cell, put an equal sign and then write “max.” Highlight the column with your values and press “enter” to find the maximum. [3] X Research source Do the same thing again in a new cell, this time with “min” instead of “max.”
- If your data was in cells D8 through D15, then your equations would end up looking like: =max(D8:D15) and =min(D8:D15).
- Highlighting the column automatically adds parentheses.
- If your data was in cells D8 through D15, then your equations would end up looking like: =max(D8:D15) and =min(D8:D15).
-
Add the highest and lowest values and use “/” to divide them by two. In another cell, add an equal sign and open parenthesis, then click on the cell where you found the minimum. Press “+”, then click on the cell where you found the maximum, and close the parenthesis. Type “/2,” then press enter to divide them by two. [4] X Research source
- If your minimum value was in C1 and your maximum in C2, then the equation would look like =(C1+C2)/2.
- Alternatively, you can use the average of the maximum and minimum (which is the same thing as adding them together and dividing by 2) to find the midrange. [5] X Research source
Advertisement
Expert Q&A
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement
Video
Tips
Submit a Tip
All tip submissions are carefully reviewed before being published
Thanks for submitting a tip for review!
References
- ↑ https://youtu.be/1_IE1iFbiq8?t=78
- ↑ https://www.khanacademy.org/math/statistics-probability/summarizing-quantitative-data/other-measures-of-spread/v/range-and-mid-range
- ↑ https://youtu.be/5Tb0v7K1twI?t=31
- ↑ https://youtu.be/PrkarSQzA8M?t=251
- ↑ https://youtu.be/5Tb0v7K1twI?t=75
- ↑ https://youtu.be/BVR2PnpQXP4?t=132
About This Article
Thanks to all authors for creating a page that has been read 1,180 times.
Advertisement
