ExamGecko
Question list
Search
Search

List of questions

Search

Question 189 - DA0-001 discussion

Report
Export

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?

A.
Statistical
Answers
A.
Statistical
B.
Aggregate
Answers
B.
Aggregate
C.
Logical
Answers
C.
Logical
D.
Mathematical
Answers
D.
Mathematical
Suggested answer: C

Explanation:

Short 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 IFERROR12

asked 02/10/2024
Brent Varona
25 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first