AQA Large Data Set Practice Test

How do you compute the range of a numeric column?

Subtract the Maximum Value from the Minimum Value Subtract the Minimum Value from the Maximum Value Among Valid Records Add the Minimum Value to the Maximum Value Multiply the Minimum Value by the Maximum Value

Correct Answer:

Subtract the Minimum Value from the Maximum Value Among Valid Records

Explanation:

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.

Access more questions from this quiz

Continue to AQA Large Data Set Practice Test for more practice questions and the full quiz experience.

Access More Questions