Grouping Records Before Calculating Averages in Data Exploration
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?
Community Insight
The question tests whether you recognize that a per-category statistic (average per student) is only meaningful after grouping records by that category; the trap is picking duplication, redundancy, or binning, which solve unrelated data-quality problems.
In data exploration, computing an average score per student requires first grouping records by the student identifier so the aggregate is calculated within each category. This question establishes that grouping is the appropriate exploration technique, because duplication and redundancy address repeated data and binning discretizes continuous values into ranges.
The most common wrong answers are duplication and redundancy, since learners associate any table that repeats student names with duplicate data — but repeated rows per student are legitimate records (multiple scores), not errors to remove. Binning is also mis-picked, though it converts numeric values into intervals rather than enabling per-student aggregation.
Community Discussion (1 comments)
Comments & Corrections
No comments yet — spotted an error or have a note? Share it below.
Expert Analysis
Why the Answer Is Correct
Grouping (option D) partitions the table by the student key so that each student's rows are aggregated together, which is the only way an "average score per student" can be computed at all. Exploration techniques such as grouping let the analyst inspect the structure of the data — one row per score, several rows per student — before applying aggregations. As Amelia233 noted, "the analyst needs to calculate the score for each student separately," and grouping by student then averaging produces an accurate individual result. Without grouping, an average over the raw table yields one single overall mean, which is not the requested per-student statistic.
Why the Other Options Are Wrong
Duplication (A) and redundancy (B) are data-quality checks that detect duplicate records or unnecessary overlapping columns; a student appearing on multiple rows with different scores is not duplicate or redundant data, so removing those rows would corrupt the dataset. Binning (C) is an exploration technique that segments continuous values into intervals (for example, score bands of 0–59, 60–79, 80–100) for histogram-style analysis, and it does nothing to aggregate records by student. None of these three techniques establishes the category boundaries required for a per-student average; only grouping does.
Community Comment Notes
The lone community comment argues for option D, explaining that "Grouping should be considered before calculating the average" and explicitly rejecting duplication, redundancy, and binning for the same reasons given above. That reasoning aligns with the exam blueprint's data exploration guidance and with the question's wording that no changes were made to the table before the average was calculated. No dissenting comments appear, so the vote record is not available to cross-check, but the technical justification is sound.
Exam Strategy
On DA-002 aggregation questions, identify the grouping key implied by the phrasing ("per student," "per region") and choose the option that partitions by that key. Read carefully whether an option removes data (duplication, redundancy) or reshapes values (binning) — neither enables a per-category average.
Frequently Asked Questions
Why isn't binning the right exploration technique before calculating an average?
Binning converts continuous values into ranges, such as score bands, for distribution analysis. It does not aggregate multiple rows per student, so it cannot produce a per-student average.
Why is duplication not an issue when a student appears on several rows?
Each row represents a distinct score for that student, so repeated student names are legitimate records rather than duplicate data. Removing them would delete valid observations and skew the average.
Related Analysis
Practice All DA0-002 Questions
Access 100 questions with complete answers and detailed explanations.
View Full DA0-002 Practice Test →