In Data Analytics FULL Course 2026 – Part 08, you focus on Excel Statistical Functions, which are extremely important for data analysis, reporting, business decision-making, and interviews.
This lecture helps you understand how data analysts summarize, analyze, and interpret data, instead of just writing formulas.
This Lecture Focuses on One Major Category:
Statistical & Analytical Functions in Excel
These functions are used to:
- Understand data distribution
- Analyze business performance
- Support data-driven decisions
- Prepare for analytics interviews
Download Dataset
📥 (Provide dataset link here if available)
Functions Covered in Part 08
In this lecture, you learn core statistical functions used by Data Analysts:
🔹 Statistical Functions
- AVERAGE
- MEDIAN
- MODE
- STDEV
- VAR
- PERCENTILE
- QUARTILE
These functions are commonly used in:
- Business performance analysis
- Sales & revenue reporting
- HR analytics
- Finance & operations dashboards
- Interview case studies
AVERAGE – Mean of the Data
What Does AVERAGE Do?
The AVERAGE function calculates the mean value of a dataset.
Syntax:
=AVERAGE(range)
Example:
=AVERAGE(B2:B10)
📌 Used to understand overall performance, but sensitive to outliers.
MEDIAN – Middle Value of Data
What Does MEDIAN Do?
The MEDIAN function returns the middle value after sorting the data.
Syntax:
=MEDIAN(range)
Example:
=MEDIAN(B2:B10)
📌 Best used when data contains outliers (e.g., salary analysis).
MODE – Most Frequent Value
What Does MODE Do?
The MODE function returns the value that appears most frequently.
Syntax:
=MODE(range)
Example:
=MODE(B2:B10)
📌 Commonly used in demand analysis and customer behavior studies.
STDEV – Measure Data Spread
What Does STDEV Do?
The STDEV function measures how much the data varies from the mean.
Syntax:
=STDEV(range)
📌 Helps understand risk, consistency, and volatility in data.
VAR – Variance of Data
What Does VAR Do?
The VAR function calculates variance, which is the square of standard deviation.
Syntax:
=VAR(range)
📌 Used heavily in finance, operations, and quality analysis.
PERCENTILE – Position-Based Analysis
What Does PERCENTILE Do?
The PERCENTILE function returns a value at a given percentage position.
Syntax:
=PERCENTILE(range, k)
Example:
=PERCENTILE(B2:B100, 0.9)
📌 Used for salary bands, performance cutoffs, and ranking.
QUARTILE – Divide Data into 4 Parts
What Does QUARTILE Do?
The QUARTILE function divides data into four equal parts.
Syntax:
=QUARTILE(range, quart)
📌 Commonly used in box plots and performance segmentation.
Why Statistical Functions Are Important for Data Analysts
Statistical functions help you:
- Summarize large datasets
- Identify trends and patterns
- Detect outliers
- Support business decisions
- Answer interview questions confidently
📌 Tip:
Data Analysts are valued not for formulas, but for interpreting results correctly.
Mean vs Median vs Mode (Quick Comparison)
| Function | Purpose |
|---|---|
| AVERAGE | Overall mean |
| MEDIAN | Middle value |
| MODE | Most frequent value |
📌 Use Median when data has outliers, Average when data is balanced.
What’s Coming Next?
In the next lecture, you’ll learn:
- Advanced Statistical Use Cases
- Data Cleaning Techniques
- Handling missing & incorrect data
- Real-world business scenarios
After that:
- Charts & Dashboards
- Power BI basics
- SQL starts soon