KSA Data Analysis & Reporting 3

Question 1

Which Excel function looks up a value in the first column of a table and returns a value from another column in the same row?

Accepted Answer

VLOOKUP

Answer

VLOOKUP searches the leftmost column and returns a value from a specified column in the matching row.

Question 2

In SQL, which clause filters grouped results after aggregation?

Accepted Answer

HAVING

Answer

HAVING applies conditions to aggregated groups, whereas WHERE filters rows before grouping.

Question 3

A dataset has 8% of values missing at random in one column. Which approach is generally most defensible?

Accepted Answer

Document the issue and use an appropriate method such as imputation or exclusion

Answer

Missing data should be handled with a documented, justified method and its limitations disclosed.

Question 4

What is the main purpose of a pivot table?

Accepted Answer

To summarize and cross-tabulate large datasets interactively

Answer

Pivot tables let you quickly aggregate and reorganize data by categories.

Question 5

A p-value of 0.03 in a hypothesis test with alpha 0.05 means you should:

Accepted Answer

Reject the null hypothesis

Answer

Because 0.03 is below the 0.05 threshold, the result is statistically significant.

KSA - Knowledge, Skills, and Abilities Practice Test