DA0-002 · Question #72
A data analyst calculated the average score per student without making any changes to the following table: Which of the following exploration techniques should the analyst have considered before calcu
The correct answer is A. Duplication. Before calculating an average, it is crucial to address data quality issues such as duplicate records to ensure accuracy.
Question
A data analyst calculated the average score per student without making any changes to the following table:
Which of the following exploration techniques should the analyst have considered before calculating the average?
Options
- ADuplication
- BRedundancy
- CBinning
- DGrouping
How the community answered
(23 responses)- A87% (20)
- B4% (1)
- C4% (1)
- D4% (1)
Why each option
Before calculating an average, it is crucial to address data quality issues such as duplicate records to ensure accuracy.
Duplication can inflate the count and sum of values, leading to an inaccurate or skewed average by counting the same entry multiple times.
Redundancy is a broader concept that may include duplication but is not the most precise data exploration technique to address before averaging.
Binning is a data transformation technique used to group data into intervals, not a pre-calculation cleaning step for averages.
Grouping is an aggregation technique to summarize data by categories, not a technique to address data quality issues before calculating an overall average.
Concept tested: Data quality and preprocessing-duplication
Source: https://learn.microsoft.com/en-us/power-query/remove-duplicates
Topics
Community Discussion
No community discussion yet for this question.