データ アナリストは、各販売員が販売した合計数量に基づいて、「Promotion_flag」というラベルの付いた新しい変数を導き出すように依頼されました。以下の表を考えると:

Quantity_sold 列の数値が 1,000,000 を超えるすべての営業担当者に「はい」のフラグを立てるのに適切だとアナリストが考える関数は次のうちどれですか?
正解:C
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. References: CompTIA Data+ Certification Exam Objectives, Logical functions (reference)