RANGE(numeric_exp)

Returns the Range of the population of numeric_exp.

 

Description

The range is the simplest measure of the spread or dispersion of a data set. The range is the difference between the highest and lowest values in a Set. The range reflects information about extreme values but not necessarily about typical values. Only when the range is narrow (meaning that there are no outliers) does it tell us about typical values in the data. The higher the range, the greater the amount of variation in a data set.

Range = Max - Min

Where:

Max = Highest observed value in the data set

Min  = Lowest observed value in the data set

 

Parameters

numeric_exp must be a number, or a numeric expression.