ExamGecko
Question list
Search
Search

List of questions

Search

Question 9 - DA0-001 discussion

Report
Export

A data analyst has been asked to derive a new variable labeled "Promotion_flag" based on the total quantity sold by each salesperson. Given the table below:

Which of the following functions would the analyst consider appropriate to flag "Yes" for every salesperson who has a number above 1,000,000 in the Quantity_sold column?

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

Explanation:

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. Reference: CompTIA Data+ Certification Exam Objectives, Logical functions (reference)

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

Leave a comment first