Range Calculator
Range is evaluated from Number 1, Number 2 and Number 3. The calculation reports Minimum, Maximum and Range.
Results
About the Range Calculator
The calculator uses a multi formula configuration. Each reported value is read as a direct evaluation of the stored rules with the declared field formats and units.
Formula basis:
Range = maximum value - minimum value
Interpret the outputs in the order shown by the result fields. Optional inputs affect only the outputs that depend on those variables.
Formula & How It Works
The calculation applies the following relations exactly as recorded in the metadata: Range = maximum value - minimum value Each output field is produced by substituting the supplied inputs into the relevant relation and then applying the declared rounding or text format.
Worked Examples
Example 1: Temperature readings (°F): 72, 85, 68, 91, 74, 88, 79
Inputs
With Number 1 = 72, Number 2 = 85, Number 3 = 68 and Number 4 = 91 as the stated inputs, the result is Minimum = 10, Maximum = 91 and Range = 81. Each value corresponds to the declared output fields.
Example 2: Sales data ($K): 120, 145, 98, 312, 110, 135
Inputs
With Number 1 = 120, Number 2 = 145, Number 3 = 98 and Number 4 = 312 as the stated inputs, the result is Minimum = 10, Maximum = 312 and Range = 302. Each value corresponds to the declared output fields.
Example 3: Student heights (inches): 62, 71, 58, 74, 65, 69, 67
Inputs
With Number 1 = 62, Number 2 = 71, Number 3 = 58 and Number 4 = 74 as the stated inputs, the result is Minimum = 10, Maximum = 74 and Range = 64. Each value corresponds to the declared output fields.
Example 4: Bowling scores: 145, 178, 203, 112, 189, 167, 155
Inputs
With Number 1 = 145, Number 2 = 178, Number 3 = 203 and Number 4 = 112 as the stated inputs, the result is Minimum = 10, Maximum = 203 and Range = 193. Each value corresponds to the declared output fields.
Common Use Cases
- Calculate the range of a dataset
- Find minimum and maximum values
- Measure data spread as a quick summary