Exam DA0-001 topic 1 question 9 discussion

Aggregate combines the data in some way. Logical uses IF functions as in if greater than a million which is what is required here

C. Logical functions would be appropriate to flag “Yes” for every salesperson who has a number above 1,000,000 in the Quantity_sold column. Logical functions in data analysis are used to make decisions based on a set of conditions. In this case, the analyst can use a logical function such as an IF statement, where the condition is that the salesperson's Quantity_sold is above 1,000,000. If the condition is met, then the Promotion_flag is set to “Yes,” otherwise it is set to “No.” For example, the formula could be something like: IF(Quantity_sold > 1000000, "Yes", "No") This formula would then be applied to the entire column of Quantity_sold values, and the resulting Promotion_flag column would indicate whether each salesperson is eligible for a promotion based on the number of items they have sold. Logical functions are an essential tool in data analysis, as they allow analysts to make decisions based on specific criteria and automate certain processes in the data analysis process.

C. A logical function would be appropriate for creating a new variable called "Promotion_flag" that is based on the values in the "Quantity_sold" column. A logical function allows you to perform a logical test and returns a value of TRUE or FALSE based on the test. In this case, the analyst could use a logical function to flag "Yes" for every salesperson who has a quantity sold above 1,000,000. For example, the analyst could use the IF function, which has the following syntax: IF(logical_test, value_if_true, value_if_false). The logical_test would be a comparison of the "Quantity_sold" column to 1,000,000, and the value_if_true would be "Yes" and the value_if_false would be "No". The other options (Date, Mathematical, and Aggregate) are not related to logical functions.