Which of the following functions would the analyst consider appropriate to flag “Yes” for every salesperson who has a number above 1,000,000 in the Quantity_sold column?

A data analyst has been asked to derive a new variable labeled “Promotion_flag” based on the total quantity sold by each salesperson.

Given the table below:

Which of the following functions would the analyst consider appropriate to flag “Yes” for every salesperson who has a number above 1,000,000 in the Quantity_sold column?
A . Date
B . Mathematical
C . Logical
D . Aggregate

View Answer

Answer: C

Explanation:

A logical function is a type of function that returns a value based on a condition or a set of conditions. For example, the IF function in Excel can be used to check if a certain condition is met, and then return one value if true, and another value if false. In this case, the data analyst can use a logical function to check if the Quantity_sold column is greater than 1,000,000, and then return “Yes” if true, and “No” if false. This would create a new variable called Promotion_flag that indicates whether the salesperson has sold more than 1,000,000 units or not.

Reference: CompTIA Data+ Certification Exam Objectives, Logical functions (reference)