Question
A data analyst is analyzing the following data set:
| Transaction Date | Qty | Item | Item Price |
|---|---|---|---|
| 12/12/12 | 11 | USB Cords | 9.99 |
| 11/11/11 | 3 | Charging Block | 8.89 |
| 10/10/10 | 5 | Headphones | 50.15 |
Which of the following methods should the analyst use to determine the total cost for each transaction?
- A. Parsing
- B. Scaling
- C. Compressing
- D. Deriving Correct
Explanation
The total cost is not in the data set, so the analyst derives a new field by calculating it from existing ones: Qty multiplied by Item Price. Parsing splits a value into parts, scaling changes the range of values, and compressing reduces storage size; none of them creates the needed total.
