Practice Test Geeks(CPA) Certified Associate Programmer Practice Test
← All CPA Flashcard Decks

Data Analytics Flashcards

7 cards from real CPA practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 7 Data Analytics flashcards as text

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

    Answer: Median

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

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

    Answer: 4

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

  3. What does a correlation coefficient of -0.95 indicate?

    Answer: Strong negative relationship

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

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

    Answer: pandas

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

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

    Answer: Aggregate rows sharing the same column values

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

  6. In data analytics, what is 'data wrangling'?

    Answer: Cleaning and transforming raw data into a usable format

    Data wrangling (also called data munging) involves cleaning, structuring, and enriching raw data to make it suitable for analysis.

  7. Which type of chart is best suited for showing the distribution of a single continuous variable?

    Answer: Histogram

    A histogram divides a continuous variable into bins and shows the frequency of values within each bin, revealing the distribution shape.