CPA Data Analytics 2

Question 1

Which measure of central tendency is most resistant to the effect of outliers?

Accepted Answer

Median

Answer

The median is resistant to outliers because it depends only on the middle value(s), not the magnitude of extreme values.

Question 2

In a dataset with values [2, 4, 4, 6, 8, 10], what is the interquartile range (IQR)?

Accepted Answer

4

Answer

Q1=4, Q3=8, so IQR = Q3 - Q1 = 8 - 4 = 4.

Question 3

What does a correlation coefficient of -0.95 indicate?

Accepted Answer

Strong negative relationship

Answer

A correlation coefficient close to -1 indicates a strong negative linear relationship between two variables.

Question 4

Which Python library is most commonly used for data manipulation and analysis using DataFrames?

Accepted Answer

pandas

Answer

pandas provides the DataFrame structure and extensive data manipulation tools, making it the primary library for data analysis in Python.

Question 5

What is the purpose of the GROUP BY clause in SQL?

Accepted Answer

Aggregate rows sharing the same column values

Answer

GROUP BY groups rows with the same values in specified columns so aggregate functions like SUM or COUNT apply per group.

(CPA) Certified Associate Programmer Practice Test