Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Databricks Certified Data Analyst Associate Exam - Topic 3 Question 51 Discussion

In which circumstance will there be a substantial difference between the variable's mean and median values?
D) When the variable contains a lot of extreme outliers
A) When the variable is of the categorical type
B) When the variable is of the boolean type
C) When the variable contains no outliers

Databricks Certified Data Analyst Associate Exam - Topic 3 Question 51 Discussion

Actual exam question for Databricks's Databricks Certified Data Analyst Associate exam
Question #: 51
Topic #: 3
[All Databricks Certified Data Analyst Associate Questions]

In which circumstance will there be a substantial difference between the variable's mean and median values?

Show Suggested Answer Hide Answer
Suggested Answer: D

The mean is sensitive to extreme values, often called outliers, which can significantly skew the average away from the true center of the data. The median, however, is a measure of central tendency that is resistant to such outliers because it only considers the middle value(s) when the data is ordered. Therefore, when a variable contains many extreme outliers, there will be a substantial difference between the mean and the median. According to Databricks data analysis materials, this is a fundamental concept when choosing summary statistics for reporting.


by Luz at May 06, 2026, 10:07 AM

Limited Time Offer

25%

Off

Get Premium Databricks Certified Data Analyst Associate Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Ming
1 day ago
Exactly! C is definitely wrong. No outliers means mean and median are close.
upvoted 0 times
...
Vivan
6 days ago
A and B don't really apply here. They won't affect mean vs. median much.
upvoted 0 times
...
Murray
12 days ago
Agreed! The mean gets pulled by those outliers.
upvoted 0 times
...
Dan
17 days ago
I think D is the right choice. Extreme outliers can skew the mean.
upvoted 0 times
...
Christene
22 days ago
I feel confident about this question.
upvoted 0 times
...
Whitley
27 days ago
Right! D shows a clear difference.
upvoted 0 times
...
Leonard
1 month ago
Exactly! C is definitely wrong. No outliers means mean and median are close.
upvoted 0 times
...
Marylyn
1 month ago
A and B don't really apply here. They won't affect mean vs. median much.
upvoted 0 times
...
Christene
1 month ago
Agreed! The mean gets pulled by those outliers.
upvoted 0 times
...
Whitley
2 months ago
I think D is the right choice. Extreme outliers can skew the mean.
upvoted 0 times
...
Wei
2 months ago
Yeah, D makes the most sense!
upvoted 0 times
...
Christiane
2 months ago
A and B don't really apply here, right?
upvoted 0 times
...
Lindsey
2 months ago
Wait, are you sure? I thought it was about the distribution shape.
upvoted 0 times
...
Honey
2 months ago
Totally agree, outliers can mess things up big time.
upvoted 0 times
...
Dona
2 months ago
D is the right answer! Extreme outliers really skew the mean.
upvoted 0 times
...
Theola
3 months ago
I wonder if B could be a trick option since boolean variables are just 0s and 1s, but I think outliers are definitely the key here.
upvoted 0 times
...
Antonio
4 months ago
I'm not entirely sure, but I feel like categorical variables wouldn't really have a mean or median, so A seems unlikely.
upvoted 0 times
...
Clarence
4 months ago
I remember practicing a question about means and medians, and it mentioned that outliers really affect the mean more than the median.
upvoted 0 times
...
Jaime
5 months ago
I think the mean and median can differ a lot when there are extreme outliers, so maybe D is the right answer?
upvoted 0 times
...

Save Cancel