Lesson 5.5 – Basic Statistics (AVERAGE, MEDIAN, MODE)

Basic statistical functions help you understand the central tendency of your data. Excel provides simple functions to calculate the average value, the middle value, and the most frequent value in a dataset. These functions are widely used in business, finance, education, and data analysis.

---

1. What Are Basic Statistics?

Basic statistics summarize your data and help you understand its general behavior. The three most common measures are:

• AVERAGE – The arithmetic mean
• MEDIAN – The middle value
• MODE – The most frequent value

These functions are essential for analyzing trends, comparing groups, and making decisions.

---

2. AVERAGE Function

The AVERAGE function calculates the mean of a group of numbers.

Syntax:

=AVERAGE(range)

Example:

=AVERAGE(B2:B10)

Use AVERAGE when you want a general idea of the typical value in your dataset.

---

3. MEDIAN Function

The MEDIAN function returns the middle value in a sorted list of numbers.

Syntax:

=MEDIAN(range)

Example:

=MEDIAN(B2:B10)

MEDIAN is useful when your data contains outliers, because it is not affected by extreme values.

---

4. MODE Function

The MODE function returns the most frequently occurring value in a dataset.

Syntax:

=MODE.SNGL(range)

Example:

=MODE.SNGL(B2:B10)

MODE is helpful when analyzing repeated values, such as product codes or survey responses.

---

5. When to Use Each Function

• Use AVERAGE when your data is balanced and has no extreme values.
• Use MEDIAN when your data contains outliers or is skewed.
• Use MODE when you want to identify the most common value.

---

6. Combining Statistics for Better Insights

Using all three functions together gives you a clearer picture of your data. For example:

• If AVERAGE and MEDIAN are very different → your data is skewed.
• If MODE is far from AVERAGE → your data has clusters or repeated values.

---

7. Practical Exercise

1. Create a worksheet named Lesson_5_5_Practice.
2. Enter at least 20 numeric values.
3. Calculate AVERAGE, MEDIAN, and MODE.
4. Change some values and observe how the results change.
5. Identify whether your dataset is balanced or skewed.

---

Internal Links

• Lesson 5.3 – Introduction to PivotTables
• Lesson 5.4 – Sorting and Filtering for Analysis
• Lesson 5.1 – Basic Charts

---

Next Module

Module 6 – Productivity and Shortcuts