How to Calculate Range using the SMALL and LARGE Functions
Step 1: Open MS Excel and Select a Cell
To calculate the range of your particular dataset using the SMALL and LARGE function, open MS Excel on your desktop and select a cell to store the output of the formula.
Select a Cell
Step 2: Find SMALL and LARGE VALUES
First you need to find the small and large values of your dataset, to do so enter the formula “=SMALL (A1:A10, 1)” to find the smallest value and “=LARGE (A1:A10, 1)” to find the larger value in the dataset.
For the Large value:
Use Large function
For Small Value: Use “=SMALL (“A1″A10,1) to calculate the smallest number in your dataset.
Use Small Function
Step 3: Subtract the Values
Now to find the range of the number subtract the larger value from the smallest value and then you will be able to find the range of the dataset.
Preview Result
How to Find Range in Microsoft Excel
Understanding the range of a dataset is key to grasping data spread and is essential for interpreting and making data-driven decisions. Excel offers various methods to calculate ranges, enhancing your data analysis skills. This article explains the concept of range in statistics, explores Excel functions for calculating it, and demonstrates practical applications with real-world examples.
How to Find Range in Microsoft Excel
Table of Content
- What is the Range?
- Excel Functions Related to a Range
- How to Calculate Range in MS Excel
- How to Find Range in Microsoft Excel Using MAX and MIN
How to Calculate Range using the SMALL and LARGE Functions- How to Calculate Range using the conditional MIN and MAX formulas
- Conclusion
- How to Calculate Range in Microsoft Excel – FAQs