DATABRICKS-DATA-ANALYST-ASSOCIATE practice question 5 of 15

In which of the following situations will the mean value and median value of variable be meaningfully different?

Full set: 117 questions
Answer options
A: When the variable contains no outliers
B: When the variable contains no missing values
C: When the variable is of the boolean type
D: When the variable is of the categorical type
E: When the variable contains a lot of extreme outliers Correct answer
Correct Answer:
E. When the variable contains a lot of extreme outliers
Explanation

The mean is the arithmetic average of all data points, making it highly sensitive to the magnitude of each value. Extreme outliers, which are values far from the central tendency, will disproportionately pull the mean towards them. In contrast, the median is the middle value of a sorted dataset and is not affected by the specific values of outliers, only their position. This property makes the median a "robust" measure of central tendency. Consequently, in a dataset with significant outliers (a skewed distribution), the mean and median will diverge, with the mean being pulled in the direction of the outliers.

Why Incorrect

A: In the absence of outliers, a distribution is often symmetric, causing the mean and median to be nearly identical. B: The absence of missing values ensures data completeness for calculation but does not inherently cause a difference between the mean and median. C: For boolean data (0s and 1s), the mean and median can be calculated, but this data type does not typically exhibit the kind of extreme outliers that cause a meaningful divergence. D: The mean is generally not a meaningful measure for nominal categorical data, and the median is only applicable to ordinal data.

References

1. Databricks Documentation, Exploratory data analysis in Databricks: Tools and techniques. This guide discusses using summary statistics to understand data. It states, "Summary statistics provide a high-level overview of your data... Key statistics include... mean, median... These statistics can help you understand the distribution of your data, identify outliers, and detect skewness." The difference between mean and median is a primary indicator of skewness caused by outliers.

2. Databricks Blog, A Gentle Introduction to Data Distributions (May 26, 2021). In the section on Skewed Distributions, the article explains: "In the presence of outliers... the mean can be pulled by these outliers... The median, on the other hand, is known to be robust to outliers. That is, the value of the median is not affected by the presence of outliers." This directly supports that outliers cause a divergence.

3. PennState, STAT 200: Elementary Statistics, Lesson 2: Measures of Center. The course material explicitly states: "The mean is not a resistant measure of center because it is influenced by outliers. The median and mode are resistant measures of center." This academic source confirms the fundamental statistical principle behind the correct answer.

Scroll to Top