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 MPC.
MPC is short for marginal propensity to consume. Marginal propensity …

How to Calculate MPC.

Calculate Relative Error.
Relative error or relative uncertainty is a measure of the …

How to Calculate Relative Error.

Leave a Reply

Cancel reply

Popular Posts

  • How to Calculate Degrees of Unsaturation.
    January 6, 2021 0
  • How to Calculate Buoyant Force.
    January 6, 2021 0
  • How to Calculate Stairs.
    January 6, 2021 0

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 © 2021 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