How do you compute the range of a numeric column?

How do you compute the range of a numeric column?

• A. Subtract the Maximum Value from the Minimum Value
• B. Subtract the Minimum Value from the Maximum Value Among Valid Records
• C. Add the Minimum Value to the Maximum Value
• D. Multiply the Minimum Value by the Maximum Value

Answer: (B)

Range is about how spread out the values are by looking at the smallest and largest numbers in the column. To compute it, find the largest valid value and the smallest valid value, then subtract the smallest value from the largest value. Using only valid records ensures missing or invalid data don’t skew the result. Subtracting the reverse would give a negative number, which doesn’t represent spread, and adding or multiplying the two values doesn’t measure how wide the data range is.

Range is about how spread out the values are by looking at the smallest and largest numbers in the column. To compute it, find the largest valid value and the smallest valid value, then subtract the smallest value from the largest value. Using only valid records ensures missing or invalid data don’t skew the result. Subtracting the reverse would give a negative number, which doesn’t represent spread, and adding or multiplying the two values doesn’t measure how wide the data range is.