Exam DA0-001 topic 1 question 108 discussion

Logical -

The most appropriate type of function to use for categorizing salaries into bands is logical functions, as they allow the analyst to apply conditions to determine the appropriate salary band for each employee.

The most appropriate type of functions to use in this scenario would be A. Statistical. Here's why: Categorization into salary bands often involves dividing the data into groups based on statistical measures like percentiles or standard deviations. Statistical functions like percentile() or quantile() can be used to determine the salary boundaries for each band. While aggregate functions might be used to calculate summary statistics for each band after they are created, they are not the primary tools for creating the bands themselves.

C. Logical functions are the most appropriate to use for categorizing data into bands, because they allow the data analyst to apply conditional statements and criteria to the data values. For example, the IF function can be used to assign a band name based on whether a value meets a certain condition or not. Other logical functions that can be useful for categorizing data are AND, OR, NOT, and IFERROR12.