Data Statistics Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering Profile and Clean the Data

What you'll be asked

  1. What is the primary purpose of profiling data in the 'Prepare the Data' phase?
  2. You are examining a 'customer_age' column. The data contains values like '25', '30', '40', 'eighteen', and 'unknown'. Which data statistic or characteristic would immediately highlight 'eighteen' and 'unknown' as potential issues for numerical analysis?
  3. For a 'transaction_amount' column, you calculate the mean as $150 and the median as $80. What does this difference primarily suggest about the distribution of transaction amounts?
  4. You are profiling a 'delivery_time_minutes' column. The 25th percentile is 15, the 50th percentile (median) is 30, and the 75th percentile is 45. However, the maximum value is 1800 minutes. What does this combination of statistics strongly indicate?
  5. A 'product_category' column in an e-commerce dataset has 5000 entries. A frequency distribution shows 'Electronics' (1500), 'Apparel' (1200), 'Home & Garden' (1000), 'Books' (800), and 'Eletronics' (500). What data quality issue is most evident here?

Answers and explanations come after you submit.