A company's human resources department has asked a data analyst to categorize the income of all employees into five salary bands: Which of the following types of functions would be the most…

The correct answer is C. Logical. 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…

Data Analysis

Question

A company's human resources department has asked a data analyst to categorize the income of all employees into five salary bands:

Which of the following types of functions would be the most appropriate to use?

Options

AStatistical
BAggregate
CLogical
DMathematical

How the community answered

(43 responses)

A
2% (1)
B
7% (3)
C
81% (35)
D
9% (4)

Explanation

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 IFERROR.

Topics

#Logical functions#Data categorization#Conditional statements#Data transformation

Community Discussion

No community discussion yet for this question.

Full DA0-001 Practice