An analyst has generated a report that includes the number of months in the first two quarters of 2019 when sales exceeded $50,000: Which of the following functions did the analyst use to generate…

The correct answer is B. Logical. The function that the analyst used to generate the data in the Sales_indicator column is likely a Logical function. The function likely uses a logical comparison between the sales data and a fixed value of $50,000 to determine whether each month's sales exceeded the threshold…

Data Analysis

Question

An analyst has generated a report that includes the number of months in the first two quarters of 2019 when sales exceeded $50,000:

Which of the following functions did the analyst use to generate the data in the Sales_indicator column?

Exhibit

Options

AAggregate
BLogical
CDate
DSort

How the community answered

(44 responses)

A
7% (3)
B
89% (39)
C
2% (1)
D
2% (1)

Explanation

The function that the analyst used to generate the data in the Sales_indicator column is likely a Logical function. The function likely uses a logical comparison between the sales data and a fixed value of $50,000 to determine whether each month's sales exceeded the threshold. For example, the formula may look like =IF(sales > 50000, "Exceeded", "Not Exceeded").

Topics

#Data Analysis Functions#Logical Functions#Conditional Statements

Community Discussion

No community discussion yet for this question.

Full DA0-001 Practice