MLS-C01 Exploratory Data Analysis Practice Question

Exhibit

Refer to the exhibit. Consider the following output from an Amazon SageMaker Data Wrangler data quality report:

Column: 'age'
Missing: 2.3%
Mean: 38.5
Median: 37.0
StdDev: 15.2
Min: 0
Max: 120
Unique: 85

The exhibit shows a data quality report for a column named 'age'. Which potential data issue should be investigated further?

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

✓

The minimum age of 0 and maximum age of 120 may be outliers

A minimum age of 0 and maximum age of 120 are potential data entry errors or outliers that warrant further investigation, as extreme values can skew analysis. Option A is incorrect because the mean and median being close suggests the distribution is relatively symmetric and not a data quality issue. Option C is incorrect because a missing value rate of 2.3% is generally considered low and may be handled without major concern. Option D is incorrect because 85 unique values for age is reasonable given the possible age range; it does not indicate a problem.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

✗
The mean and median are significantly different
Why it's wrong here
Mean 38.5 and median 37.0 are close.
✓
The minimum age of 0 and maximum age of 120 may be outliers
Why this is correct
Age 0 and 120 are likely data errors.
✗
The missing value rate of 2.3% is too high
Why it's wrong here
2.3% missing is relatively low.
✗
The number of unique values (85) is too high
Why it's wrong here
85 unique ages is reasonable for a dataset.

Go deeper

MLS-C01 Exploratory Data Analysis Practice Question

Exhibit

Why each option matters

Option-by-option breakdown

Related to this question