How To Calculate

Learn how to calculate anything
Menu
  • bmi
Home
statistics
How to Calculate Range in Excel.
statistics

How to Calculate Range in Excel.

Rosemary Njeri

We can define range of a list of numbers as the difference between the largest and smallest values in a data set. We calculate range to know how far apart numbers in a data set.

If the range is a high number, then the values in the series are spread far apart, if the range is a small number, then the values in the series are close to each other.

Formula to calculate range in excel.

We begin by finding the upper ad lowest value in the data set using the maximum and minimum functions.

Then subtract the two.

Example:

Calculate the range of the following data set.

42, 58, 53, 67, 78, 89, 28, 51.

We’ll begin by transferring the data to an excel spreadsheet.

 Calculate Range in Excel.

Then continue by finding the highest and lowest values in the data set using the MAX and MIN function.

 Calculate Range in Excel.

And finally calculate the difference of the two values using =(B9-B10)

Calculate Range in Excel.

Therefore, the range is 61.

Share
Tweet
Reddit
Pinterest
Email
Prev Article
Next Article

Related Articles

How to Calculate P value in Excel.
Ahead of discussing how to calculate p value in excel, …

How to Calculate P value in Excel.

How to Calculate T-Statistic.
T-statistic is the ratio of the departure of the estimated …

How to Calculate T-Statistic.

Popular Posts

    Categories

    learntocalculate.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to amazon.com.

    How To Calculate

    Learn how to calculate anything

    Pages

    • About Us
    • Contact Us
    • Privacy Policy
    Copyright © 2025 How To Calculate

    Ad Blocker Detected

    Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker.

    Refresh