An analyst needs to provide a chart to identify the composition between the categories of the survey response data set:

Which of the following charts would be BEST to use?

• A.Histogram
• B.Pie
• C.Line
• D.Scatter pot
• E.Waterfall

Comment: *

Name: *

Email: *

Verification: *

Which of the following describes a programming language and free software environment for statistical computing and graphics?

• A.Microsoft Power BI.
• B.SAS.
• C.Microsoft Excel.
• D.R.

Comment: *

Name: *

Email: *

Verification: *

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?

• A.Aggregate
• B.Logical
• C.Date
• D.Sort

Correct Answer: B

Explanation
This is because a logical function is a type of function that returns a value based on a condition or a set of conditions. A logical function can be used to generate the data in the Sales_indicator column by comparing the values in the Sales column with a threshold of $50,000 and returning either "Exceeded $50,000" or "Not exceeded $50,000" accordingly. For example, a logical function in Excel that can achieve this is:

The other functions are not suitable for generating the data in the Sales_indicator column. Here is why:
Aggregate is a type of function that performs a calculation on a group of values, such as sum, average, count, etc. An aggregate function cannot generate the data in the Sales_indicator column because it does not compare the values in the Sales column with a threshold or return a text value based on a condition.
Date is a type of function that manipulates or extracts information from dates, such as year, month, day, etc. A date function cannot generate the data in the Sales_indicator column because it does not use the values in the Sales column or return a text value based on a condition.
Sort is a type of function that arranges the values in a column or a range in ascending or descending order. A sort function cannot generate the data in the Sales_indicator column because it does not create a new column or return a text value based on a condition.

Comment: *

Name: *

Email: *

Verification: *

Which of the following data types would a telephone number formatted as XXX-XXX-XXXX be considered?

• A.Numeric
• B.Date
• C.Float
• D.Text

Comment: *

Name: *

Email: *

Verification: *

What technique is used to swap the values in rows and columns of tabular data?

• A.Regression.
• B.Association.
• C.Transposition.
• D.Classification.

Comment: *

Name: *

Email: *

Verification: *