🎯 Central Tendency

Goal: Analyze the dataset: { 3, 8, 3, 5, 10 }.
MEDIAN: The middle number (after sorting).
MODE: The most frequent number (Popularity).

Ready...

💻 Formula Structure

=MEDIAN(number1, [number2], ...)
  • Logic: Sorts values, finds the middle.
  • Even Count: If there are 2 middle numbers, it averages them.
-- Select a function...
...
Result:
-

⚠️ Common Pitfalls

🚫 MODE Errors (#N/A)
If all numbers are unique (e.g., 1, 2, 3), MODE returns an #N/A error because no number is "most frequent."
🚫 Median vs Average
Median is better for Salary/House Price data because it ignores Outliers (extreme values) that skew the Average.