How to Calculate Midrange with a Formula or in Excel

PDF download Download Article
Find the midpoint of the upper and lower boundaries of a dataset
PDF download 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.

Section 1 of 3:

Finding the Midrange of a Dataset

PDF download Download Article
  1. 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]
    • 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.
  2. To get the midrange, add the lowest and highest values together and divide them by two. [2] 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.
    3. Advertisement
Section 2 of 3:

Finding Midrange on Excel

PDF download Download Article
  1. Start by typing each value into a separate cell in one column or row on your sheet.
  2. 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] 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.
  3. 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]
    • 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]
    4. Advertisement
Section 3 of 3:

Midrange Versus Median

PDF download Download Article
  1. If you want to be able to divide the “field” in which the values fall, find the midrange. By dividing the range in half, you create two categories that data can fall into, the upper and lower half.
    • For example, if a class had the test scores 100, 86, 90, 77, 85, and 91, the midrange would be = 88.5. Now you can see who scored in the upper half of the range and who scored in the lower half.
    • The more evenly spaced your range, the more meaningful the midpoint. If the scores had been 100, 86, 90, 77, 85, 91, and 10, for example, the midrange would be 55. Since there was an extreme outlier (10), the midrange is less helpful for contextualizing the other scores.
  2. While the midrange marks a boundary within a set (the middle point), the median is the actual middle value , so it’s more helpful for sets with outliers. [6]
    • While the median may not be in the exact middle of a range, it can more accurately represent the middle of the data, since an equal amount of data points are on each side of it.
    • Find the median by listing the numbers from lowest to highest and finding the middle value. If there are an even number of values, take the average of the middle two.
    • Looking at the second set of test scores again—100, 86, 90, 77, 85, 91, 10—you can get a better idea of the middle of where people are scoring by taking the median instead of the midrange. In this case, the median is 86, while the midrange is 55.
      • In the first set of data (that doesn’t have the outlier score “10”) the median and the midrange are almost exactly the same, 88 and 88.5.
    3. 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
      Name
      Please provide your name and last initial
      Submit
      Thanks for submitting a tip for review!

      You Might Also Like

      How to
      Unhide All Rows and Columns in Microsoft Excel
      How to
      Merge Cells in Microsoft Excel: A Quick Guide
      How to
      Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
      How to
      Unprotect an Excel Sheet
      The Best Ways to Make & Format Lists in Excel
      How to
      Make a Spreadsheet in Excel
      How to
      Create a Mortgage Calculator With Microsoft Excel
      How to
      Show Hidden Columns in Microsoft Excel & Unhide Column A
      How to
      Create a Chart in Microsoft Excel: Step-by-Step Guide
      How to
      Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
      How to
      Create a Pie Chart in Microsoft Excel
      How to
      Insert Pictures in Excel That Automatically Size to Fit Cells
      How to
      Change a Comma to Dot in Excel
      How to
      Use Macros in Excel
      Advertisement

      References

      1. ↑ https://youtu.be/1_IE1iFbiq8?t=78
      2. ↑ https://www.khanacademy.org/math/statistics-probability/summarizing-quantitative-data/other-measures-of-spread/v/range-and-mid-range
      3. ↑ https://youtu.be/5Tb0v7K1twI?t=31
      4. ↑ https://youtu.be/PrkarSQzA8M?t=251
      5. ↑ https://youtu.be/5Tb0v7K1twI?t=75
      6. ↑ https://youtu.be/BVR2PnpQXP4?t=132

      About This Article

      Thanks to all authors for creating a page that has been read 3,994 times.

      Is this article up to date?

      Advertisement