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 questionsThe 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.
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.
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.
Keep practicing
Take the free DATABRICKS-DATA-ANALYST-ASSOCIATE practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other DATABRICKS-DATA-ANALYST-ASSOCIATE practice questions
- Question 1Which of the following statements about a refresh schedule is incorrect?
- Question 2A data analyst has been asked to produce a visualization that shows the flow of users thr…
- Question 3A data team has been given a series of projects by a consultant that need to be implement…
- Question 4A data analyst is attempting to drop a table my_table. The analyst wants to delete all ta…
- Question 6Which of the following benefits of using Databricks SQL is provided by Data Explorer?
- Question 7A data analyst runs the following command: INSERT INTO stakeholders.suppliers TABLE stake…
