5+ Simple Methods To Calculate Midrange In Excel

How To Calculate Midrange In Excel

5+ Simple Methods To Calculate Midrange In Excel

The midrange of a dataset is a measure of central tendency that’s calculated by including the minimal and most values within the dataset and dividing the sum by 2. It’s a easy and intuitive measure of central tendency that’s simple to calculate and interpret, however it is usually a much less strong measure of central tendency than the imply or median. It’s because the midrange will be simply skewed by outliers, that are excessive values which can be considerably completely different from the remainder of the information. In consequence, the midrange just isn’t a dependable measure of central tendency when there are outliers within the dataset.

Nonetheless, the midrange is usually a helpful measure of central tendency when there are not any outliers within the dataset. It’s also a comparatively easy measure to calculate, making it a good selection for fast and simple evaluation of knowledge.

Read more