CompTIA Data+ (DA0-001) — Question 357

A retail data analyst needs to create a new variable that represents the total purchase amount for each customer. Which of the following data manipulation techniques should the analyst use?

Answer options

• A. Derived variables
• B. Normalize data
• C. Recoding data
• D. Data aggregation

Correct answer: A

Explanation

The correct answer is A, as derived variables allow the creation of new data points based on existing data, which is essential for calculating total purchase amounts. Options B and C pertain to different processes such as adjusting data scales and changing data formats, while D refers to summarizing data rather than creating new variables.