🚀 Data Science Roadmap 2026

📘 Phase 2: Mathematics for Data Science

📖 Topic 6: Probability Distributions — Discrete, Continuous, PMF, PDF & CDF

Welcome back! 👋

In the previous lesson, you learned Bayes' Theorem, which helps us update probabilities when new evidence becomes available.

Now we'll learn Probability Distributions.

Probability distributions are extremely important in Data Science because they help us understand how values are distributed and how likely different outcomes are.

They are used in:

✅ Statistical analysis

✅ Machine Learning

✅ Hypothesis testing

✅ A/B testing

✅ Forecasting

✅ Risk analysis

✅ Data simulation

🔹 1. What is a Probability Distribution?

A probability distribution describes how the probabilities of different possible outcomes are distributed.

For example, when rolling a fair die:

1 → 1/6

2 → 1/6

3 → 1/6

4 → 1/6

5 → 1/6

6 → 1/6

Every possible outcome has an associated probability.

The sum of all probabilities must equal: 1 = 100%

🔹 2. Two Main Types of Probability Distributions

Probability distributions can broadly be divided into:

1️⃣ Discrete Distribution

Used when outcomes are countable.

Examples: Number of customers, Number of defective products, Number of emails, Number of heads in coin tosses

2️⃣ Continuous Distribution

Used when values can take any value within a range.

Examples: Height, Weight, Temperature, Time, Salary

🔹 3. Discrete Random Variable

A discrete random variable takes countable values.

Example: Number of customers arriving at a store: 0, 1, 2, 3, 4, 5, ...

Another example: Number of defective products in a batch.

🔹 4. Continuous Random Variable

A continuous random variable can take infinitely many possible values within a range.

For example: someone's height could be: 170 cm, 170.1 cm, 170.15 cm, 170.157 cm...

There are infinitely many possible values.

🔹 5. PMF — Probability Mass Function ⭐

PMF stands for: Probability Mass Function

It is used for discrete random variables.

PMF tells us the probability of a specific outcome.

For example, when rolling a fair die:

P(X=3) = 1/6

Important Rule:

The probabilities of all possible outcomes must add up to 1:

∑P(X=x) = 1

🔹 6. PDF — Probability Density Function ⭐

PDF stands for: Probability Density Function

It is used for continuous random variables.

Unlike PMF, the PDF does not directly give the probability of a single exact value.

Instead, the area under the PDF curve over an interval represents probability.

For example: P(170 < Height < 180) is represented by the area under the PDF between 170 and 180.

Important Point:

For a continuous variable:

P(X=x) = 0

for any exact single value under the usual continuous probability model.

This doesn't mean the value is impossible. It means probability is assigned to intervals, not individual points.

🔹 7. CDF — Cumulative Distribution Function ⭐

CDF stands for: Cumulative Distribution Function

It tells us the probability that a random variable is less than or equal to a particular value.

Formula:

F(x) = P(X ≤ x)

Example: Suppose X = Test Score

Then: F(80) = P(X ≤ 80)

This tells us the probability that the score is 80 or less.

🔹 8. PMF vs PDF vs CDF

PMF: Used for Discrete data. Represents Probability of an exact outcome

PDF: Used for Continuous data. Represents Probability density

CDF: Used for Discrete & continuous. Represents Probability up to a value

A simple way to remember:

PMF → Exact probability for discrete outcomes

PDF → Density across continuous values

CDF → Cumulative probability up to a value

🔹 9. Example: Discrete Distribution

Suppose a machine produces defective products.

Let: X = Number of defective products

Possible values: 0, 1, 2, 3

Suppose:

P(X=0) = 0.50

P(X=1) = 0.30

P(X=2) = 0.15

P(X=3) = 0.05

Check: 0.50 + 0.30 + 0.15 + 0.05 = 1.00

Therefore, this is a valid probability distribution.

🔹 10. Example: Continuous Distribution

Suppose: X = Customer waiting time

Waiting time could be: 2.1 minutes, 2.15 minutes, 2.157 minutes, 2.1578 minutes...

Because there are infinitely many possible values, we treat it as a continuous random variable.

A PDF can describe how densely the waiting times are distributed.

🔹 11. Normal Distribution ⭐

One of the most important probability distributions in Data Science is the Normal Distribution.

It is often called the bell curve because of its shape.

A normal distribution is characterized by: Mean, Standard deviation

Many natural and measurement-related variables can be approximately normally distributed under suitable conditions.

Examples: Measurement errors, Certain biological measurements, Standardized test scores

🔹 12. Properties of Normal Distribution

For a perfectly symmetric normal distribution: Mean = Median = Mode

The distribution is symmetric around its mean.

A common rule of thumb is the 68–95–99.7 rule:

Within 1 Standard Deviation: Approximately 68%

Within 2 Standard Deviations: Approximately 95%

Within 3 Standard Deviations: Approximately 99.7%

🔹 13. Binomial Distribution

The Binomial Distribution is a discrete probability distribution used when:

There are a fixed number of trials, Each trial has two possible outcomes, The probability of success is constant, Trials are independent.

Examples: Number of successful predictions, Number of heads in coin tosses, Number of defective products in a fixed sample

Example: 10 coin tosses. X = Number of Heads. Possible values: 0, 1, 2, ..., 10

🔹 14. Poisson Distribution

The Poisson Distribution is commonly used to model the number of events occurring within a fixed interval when events occur at a certain average rate under appropriate assumptions.

Examples: Number of customer calls per hour, Number of website visits per minute, Number of machine failures per month, Number of support tickets per day

🔹 15. Why Probability Distributions Matter in Data Science?

Probability distributions help Data Scientists:

✅ Understand data patterns

✅ Detect unusual observations

✅ Model uncertainty

✅ Perform statistical tests

✅ Build predictive models

✅ Simulate data

✅ Estimate probabilities

🔹 16. Python Example

import numpy as np

data = np.random.normal(
    loc=50,
    scale=10,
    size=1000
)

print(data[:5])

Here: loc = 50 represents the mean. scale = 10 represents the standard deviation.

🔹 17. Common Mistakes

❌ Confusing PMF and PDF → Remember: PMF → Discrete, PDF → Continuous

❌ Thinking PDF value is probability → For a continuous distribution, the PDF value at a point is a density, not the probability of that exact value. Probability comes from the area over an interval.

❌ Forgetting that CDF is cumulative → CDF always represents: P(X ≤ x)

🎯 Practice Questions

1. What is the difference between a discrete and continuous random variable?

2. What is PMF used for?

3. What does a PDF represent?

4. What does CDF calculate?

5. Name three probability distributions commonly used in Data Science.

🎯 Key Takeaways

✅ Probability distributions describe how probabilities are distributed across possible outcomes.

✅ Discrete variables have countable outcomes.

✅ Continuous variables can take infinitely many values within a range.

✅ PMF is used for discrete random variables.

✅ PDF is used for continuous random variables.

✅ CDF gives the cumulative probability up to a particular value.

✅ Normal, Binomial, and Poisson distributions are important distributions for Data Scientists.

Understanding probability distributions gives you the foundation needed for statistical inference, hypothesis testing, machine learning, and advanced Data Science.

👉 Double Tap ❤️ For More

💻 𝗠𝗮𝘀𝘁𝗲𝗿 𝗦𝗤𝗟 𝗳𝗼𝗿 𝗙𝗥𝗘𝗘 | 𝟱 𝗕𝗲𝘀𝘁 𝗬𝗼𝘂𝗧𝘂𝗯𝗲 𝗖𝗵𝗮𝗻𝗻𝗲𝗹𝘀 🚀

Want to learn SQL from scratch to advanced level without spending anything? These 5 YouTube channels offer tutorials, practical examples and problem-solving content.

🔥 Learn → Practice → Build Projects → Prepare for SQL Interviews

🔗 𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇:- 

https://pdlink.in/4wCjU6x

📊 Perfect for Students | Freshers | Data Analyst Aspirants | SQL Beginners

𝗙𝗥𝗘𝗘 𝗠𝗮𝘀𝘁𝗲𝗿𝗰𝗹𝗮𝘀𝘀 𝗢𝗻 𝗟𝗮𝘁𝗲𝘀𝘁 𝗧𝗲𝗰𝗵𝗻𝗼𝗹𝗼𝗴𝗶𝗲𝘀 😍
- AI
- Data Analytics
- Data Science
- CloudComputing
- Cyber Security
​
💫Build a Future Ready Career in the AI Era
​
💫Learn the Skills, Hiring Trends, and Preparation Strategies That Matter
​
𝗥𝗲𝗴𝗶𝘀𝘁𝗲𝗿 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘 👇:-
​
https://pdlink.in/45w4ztg
​
(Only few slots left )
​
Date & Time :- 18th August 2026 & 7PM

✅ SQL for Data Science 🗄️📊

👉 SQL is one of the most important skills for Data Scientists and Data Analysts.

Almost every company stores data inside databases, and SQL helps retrieve and analyze that data.

🔹 1. What is SQL?
SQL = Structured Query Language

👉 Used to:
✔ Store data
✔ Retrieve data
✔ Filter data
✔ Analyze data

🔥 2. Common Database Systems
✔ MySQL
✔ PostgreSQL
✔ SQLite
✔ Microsoft SQL Server

🔹 3. Basic SQL Query

✅ SELECT Statement
Used to retrieve data from a table.

SELECT * FROM employees;

👉 ** means all columns.

🔹 4. Select Specific Columns
SELECT name, salary FROM employees;

🔹 5. WHERE Clause ⭐
Used for filtering data.

SELECT * FROM employees
WHERE salary > 50000;

🔹 6. ORDER BY
Sort data.

SELECT * FROM employees
ORDER BY salary DESC;

✔ ASC → Ascending
✔ DESC → Descending

🔹 7. Aggregate Functions ⭐
Used for calculations.

Function: COUNT()
Purpose: Count rows

Function: SUM()
Purpose: Total

Function: AVG()
Purpose: Average

Function: MAX()
Purpose: Highest value

Function: MIN()
Purpose: Lowest value

✅ Example
SELECT AVG(salary)
FROM employees;

🔹 8. GROUP BY ⭐
Used to group data.
SELECT department, AVG(salary)
FROM employees
GROUP BY department;

🔹 9. Why SQL is Important?
✔ Most asked interview skill
✔ Used daily by analysts & data scientists
✔ Essential for working with databases

🎯 Today’s Goal
✔ Learn SELECT queries
✔ Filter using WHERE
✔ Use aggregate functions
✔ Understand GROUP BY

👉 SQL Resources: https://whatsapp.com/channel/0029VanC5rODzgT6TiTGoa1v 🗄️🔥

💬 Tap ❤️ for more!

📊 𝟱 𝗕𝗲𝘀𝘁 𝗟𝗲𝗮𝗿𝗻𝗶𝗻𝗴 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀 𝗧𝗼 𝗠𝗮𝘀𝘁𝗲𝗿 𝗠𝗦 𝗘𝘅𝗰𝗲𝗹 𝗳𝗼𝗿 𝗙𝗥𝗘𝗘

Excel is one of the most valuable workplace skills — start learning for FREE today!

✅ Beginner Friendly
✅ Learn at Your Own Pace
✅ Improve Excel & Data Analysis Skills
✅ Useful for Jobs & Interviews
✅ Completely FREE Resources

🔗 𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇:- 

https://pdlink.in/3UkOmoa

🎓 Perfect for Students | Freshers | Data Analyst Aspirants | Working Professionals

🚀 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲 📊🔥

𝗕𝘂𝗶𝗹𝗱 𝗝𝗼𝗯-𝗥𝗲𝗮𝗱𝘆 𝗦𝗸𝗶𝗹𝗹𝘀 & Learn the tools companies actually use and prepare for high-growth Data Analyst opportunities.

💼 60+ Hiring Drives Every Month
🤝 500+ Hiring Partners
👨‍🏫 1-on-1 Expert Mentorship
📝 Resume & Interview Preparation
🚀 Dedicated Placement Assistance

🔗 𝗕𝗼𝗼𝗸 𝗮 𝗙𝗥𝗘𝗘 𝗖𝗮𝗿𝗲𝗲𝗿 𝗖𝗼𝘂𝗻𝘀𝗲𝗹𝗹𝗶𝗻𝗴👇:-

https://pdlink.in/45vk5ph

🎓 Perfect for Students | Freshers | Working Professionals | Career Switchers

🚀 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲 📊🔥

𝗕𝘂𝗶𝗹𝗱 𝗝𝗼𝗯-𝗥𝗲𝗮𝗱𝘆 𝗦𝗸𝗶𝗹𝗹𝘀 & Learn the tools companies actually use and prepare for high-growth Data Analyst opportunities.

💼 60+ Hiring Drives Every Month
🤝 500+ Hiring Partners
👨‍🏫 1-on-1 Expert Mentorship
📝 Resume & Interview Preparation
🚀 Dedicated Placement Assistance

🔗 𝗕𝗼𝗼𝗸 𝗮 𝗙𝗥𝗘𝗘 𝗖𝗮𝗿𝗲𝗲𝗿 𝗖𝗼𝘂𝗻𝘀𝗲𝗹𝗹𝗶𝗻𝗴👇:-

https://pdlink.in/45vk5ph

🎓 Perfect for Students | Freshers | Working Professionals | Career Switchers

📊 𝗪𝗮𝗻𝘁 𝘁𝗼 𝗕𝗲𝗰𝗼𝗺𝗲 𝗮 𝗣𝗿𝗼 𝗶𝗻 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀? 🚀

Learning Excel, SQL and Power BI is only the beginning. To stand out as a Data Analyst, focus on practical experience, visibility and networking.

🔥 4 Ways to Level Up Your Data Analytics Career:

💡 Master the Skills → Build Projects → Create Your Portfolio → Get Noticed

🔗 𝗖𝗵𝗲𝗰𝗸 𝘁𝗵𝗲 𝗖𝗼𝗺𝗽𝗹𝗲𝘁𝗲 𝗚𝘂𝗶𝗱𝗲 👇

https://pdlink.in/4cIfLqn

🎯 Perfect for Students | Freshers | Data Analyst Aspirants | Career Switchers

🎓 𝟰 𝗙𝗥𝗘𝗘 𝗖𝗲𝗿𝘁𝗶𝗳𝗮𝘁𝗶𝗼𝗻𝘀 𝗧𝗼 𝗠𝗮𝘀𝘁𝗲𝗿 𝗜𝗻 𝟮𝟬𝟮𝟲 🚀

Want to build job-ready skills and strengthen your resume? Start learning these in-demand technologies for FREE! 🔥

📊 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 :- https://pdlink.in/4qn5q94

💫 𝗔𝗜 & 𝗠𝗮𝗰𝗵𝗶𝗻𝗲 𝗟𝗲𝗮𝗿𝗻𝗶𝗻𝗴 :- https://pdlink.in/4zrkYNg

☁️ 𝗖𝗹𝗼𝘂𝗱 𝗖𝗼𝗺𝗽𝘂𝘁𝗶𝗻𝗴 :- https://pdlink.in/4wzy6Ny

🛡️ 𝗖𝘆𝗯𝗲𝗿 𝗦𝗲𝗰𝘂𝗿𝗶𝘁𝘆 :- https://pdlink.in/4xMJNl5

🔁 𝗦𝗵𝗮𝗿𝗲 this with your friends and classmates!

𝗗𝗮𝘁𝗮 𝗦𝗰𝗶𝗲𝗻𝗰𝗲 𝗙𝗥𝗘𝗘 𝗢𝗻𝗹𝗶𝗻𝗲 𝗠𝗮𝘀𝘁𝗲𝗿𝗰𝗹𝗮𝘀𝘀 😍

💫Kickstart Your Data Science Career

💫Join this Masterclass for an expert-led session on Data Science

Eligibility :- Students ,Freshers & Working Professionals

𝗥𝗲𝗴𝗶𝘀𝘁𝗲𝗿 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘 👇:-

https://pdlink.in/4xOh5jA

(Only few slots left )

Date & Time :- 21st August 2026 & 7PM

🚀 Data Science Roadmap 2026

📘 Phase 2: Mathematics for Data Science

📖 Topic 7: Descriptive Statistics — Range, Percentiles, Quartiles, IQR & Five-Number Summary

Welcome back! 👋

In the previous lesson you covered Probability Distributions.

Now we’re moving to Descriptive Statistics — how we summarize data without predicting the population.

Today we’ll cover: Range, Percentiles, Quartiles, IQR, Five-number summary, Outlier detection

These are core for EDA.

🔹 1. What is Descriptive Statistics?

Summarizes key characteristics of a dataset.

Example: Salaries: 30000, 35000, 40000, 45000, 50000

Instead of checking each value, use: Min, Max, Mean, Median, Quartiles, Percentiles, Std Dev

🔹 2. Range

Formula:

Range = Maximum − Minimum

Example: 10, 20, 30, 40, 50 → Range = 50 − 10 = 40

Note: Very sensitive to outliers. 50 → 500 makes range jump to 490.

🔹 3. Percentiles ⭐

Value below which X% of observations fall.

50th Percentile = Median

25th Percentile = 25% at or below

90th Percentile = 90% at or below

🔹 4. Real-World Example

90th percentile score ≠ 90% marks. It means you did better than ∼90% of people.

🔹 5. Quartiles

Divide data into 4 equal parts:

Q1 = 25th percentile

Q2 = 50th percentile = Median

Q3 = 75th percentile

🔹 6. Visualizing Quartiles

0% ---- Q1 ---- Q2 ---- Q3 ---- 100%

25% 50% 75%

🔹 7. Interquartile Range (IQR) ⭐

Formula: IQR = Q3 − Q1

Example: Q1=20, Q3=60 → IQR = 40. Middle 50% spans 40 units.

🔹 8. Why IQR Matters

Less affected by outliers than Range.

Data: 10,20,30,40,50,1000 → Range=990 but IQR ignores the 1000.

🔹 9. Detecting Outliers Using IQR ⭐

Lower Bound = Q1 − 1.5 × IQR

Upper Bound = Q3 + 1.5 × IQR

Values outside = potential outliers

🔹 10. Outlier Example

Q1=20, Q3=60 → IQR=40

Lower = 20-60 = -40

Upper = 60+60 = 120

So < -40 or > 120 are outliers

🔹 11. Five-Number Summary ⭐

1. Minimum 2. Q1 3. Median 4. Q3 5. Maximum

Ex: 10, 20, 30, 40, 50

🔹 12. Box Plot

Visualizes the 5-number summary.

Box = Q1 to Q3. Line inside = Median. Whiskers = range without outliers.

🔹 13. Python Example

import numpy as np

data = [10, 20, 30, 40, 50, 60, 70]
q1 = np.percentile(data, 25)
median = np.percentile(data, 50)
q3 = np.percentile(data, 75)
iqr = q3 - q1
print("Q1:", q1, "Median:", median, "Q3:", q3, "IQR:", iqr)

🔹 14. Descriptive Statistics in Pandas

import pandas as pd

df = pd.DataFrame({"Salary": [30000, 35000, 40000, 45000, 50000]})
print(df["Salary"].describe())

describe() gives Count, Mean, Std, Min, 25%, 50%, 75%, Max

🔹 15. Real-World Example

Transactions: Q1=₹500, Median=₹1000, Q3=₹2000 → IQR=₹1500

Use IQR to flag fraud, bulk orders, errors, or VIP customers. Investigate before deleting.

🔹 16. Range vs IQR

Range: Easy but outlier-sensitive

IQR: Middle 50% only, robust to outliers

🔹 17. Percentile vs Percentage

Percentage = out of 100.

Ex: 80% marks

Percentile = relative position.

Ex: 90th percentile

🔹 18. Common Mistakes

❌ 90th percentile = 90% score

❌ Deleting all outliers blindly

❌ Thinking IQR covers all data

🎯 Practice Questions

1. Range of 10, 20, 30, 40, 50 = ?

2. Median = which percentile?

3. Q1=25, Q3=75 → IQR = ?

4. Upper outlier boundary formula?

5. 5 components of five-number summary?

🎯 Key Takeaways

✅ Range = Max - Min

✅ Q1=25th, Q2=50th=Median, Q3=75th

✅ IQR = Q3 - Q1

✅ 5-number summary = Min, Q1, Median, Q3, Max

✅ Percentile ≠ Percentage

👉 Double Tap ❤️ For More

𝗪𝗢𝗥𝗞 𝗙𝗥𝗢𝗠 𝗛𝗢𝗠𝗘 𝗝𝗢𝗕 𝗢𝗣𝗣𝗢𝗥𝗧𝗨𝗡𝗜𝗧𝗬 😍

Company Name :- AI InsurTech Company

💼 𝗥𝗼𝗹𝗲: Backend Developer
💰 𝗦𝗮𝗹𝗮𝗿𝘆: ₹5 LPA
🏠 𝗪𝗼𝗿𝗸 𝗠𝗼𝗱𝗲: Work From Home
📍 𝗟𝗼𝗰𝗮𝘁𝗶𝗼𝗻: Hyderabad / Remote

🎓 𝗪𝗵𝗼 𝗖𝗮𝗻 𝗔𝗽𝗽𝗹𝘆?
✅ BTech/BE graduates
✅ Branches: CS, IT, AI, ML and Data-related streams
✅ Graduation Years: 2025 and 2026

🔗 𝗔𝗽𝗽𝗹𝘆 𝗡𝗼𝘄 👇:-

https://pdlink.in/4xIfsE4

⚡ Apply early and share this opportunity with your friends!

☁️ 𝟰 𝗙𝗥𝗘𝗘 𝗚𝗼𝗼𝗴𝗹𝗲 𝗖𝗹𝗼𝘂𝗱 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 | 𝗕𝘂𝗶𝗹𝗱 𝗜𝗻-𝗗𝗲𝗺𝗮𝗻𝗱 𝗖𝗹𝗼𝘂𝗱 𝗦𝗸𝗶𝗹𝗹𝘀

Explore these Google Cloud learning resources covering cloud fundamentals, infrastructure, networking, security, data and AI/ML.

🔥 4 Courses to Explore:
1️⃣ Cloud Computing Fundamentals
2️⃣ Infrastructure in Google Cloud
3️⃣ Networking & Security in Google Cloud
4️⃣ Data, ML & AI in Google Cloud

🔗 𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇:- 

https://pdlink.in/4zrksPn

🎯 Perfect for Students | Freshers | Developers | Cloud & DevOps Aspirants

🚀 𝗔𝗜 & 𝗠𝗮𝗰𝗵𝗶𝗻𝗲 𝗟𝗲𝗮𝗿𝗻𝗶𝗻𝗴 𝗙𝗥𝗘𝗘 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲

🔥 Upgrade your skills and prepare for exciting career opportunities in AI!

✅ Beginner-friendly course
✅ Learn AI & Machine Learning fundamentals
✅ Gain practical, job-ready skills
✅ Earn a FREE certificate
✅ Boost your resume and LinkedIn profile
✅ Ideal for students, freshers and professionals

🔗 𝗘𝗻𝗿𝗼𝗹𝗹 𝗳𝗼𝗿 𝗙𝗥𝗘𝗘 👇:-

https://pdlink.in/4zrkYNg

⚡ Limited opportunity—start learning today!

Essential Excel Functions for Data Analysts 🚀

1️⃣ Basic Functions

SUM() – Adds a range of numbers. =SUM(A1:A10)

AVERAGE() – Calculates the average. =AVERAGE(A1:A10)

MIN() / MAX() – Finds the smallest/largest value. =MIN(A1:A10)


2️⃣ Logical Functions

IF() – Conditional logic. =IF(A1>50, "Pass", "Fail")

IFS() – Multiple conditions. =IFS(A1>90, "A", A1>80, "B", TRUE, "C")

AND() / OR() – Checks multiple conditions. =AND(A1>50, B1<100)


3️⃣ Text Functions

LEFT() / RIGHT() / MID() – Extract text from a string.

=LEFT(A1, 3) (First 3 characters)

=MID(A1, 3, 2) (2 characters from the 3rd position)


LEN() – Counts characters. =LEN(A1)

TRIM() – Removes extra spaces. =TRIM(A1)

UPPER() / LOWER() / PROPER() – Changes text case.


4️⃣ Lookup Functions

VLOOKUP() – Searches for a value in a column.

=VLOOKUP(1001, A2:B10, 2, FALSE)


HLOOKUP() – Searches in a row.

XLOOKUP() – Advanced lookup replacing VLOOKUP.

=XLOOKUP(1001, A2:A10, B2:B10, "Not Found")



5️⃣ Date & Time Functions

TODAY() – Returns the current date.

NOW() – Returns the current date and time.

YEAR(), MONTH(), DAY() – Extracts parts of a date.

DATEDIF() – Calculates the difference between two dates.


6️⃣ Data Cleaning Functions

REMOVE DUPLICATES – Found in the "Data" tab.

CLEAN() – Removes non-printable characters.

SUBSTITUTE() – Replaces text within a string.

=SUBSTITUTE(A1, "old", "new")



7️⃣ Advanced Functions

INDEX() & MATCH() – More flexible alternative to VLOOKUP.

TEXTJOIN() – Joins text with a delimiter.

UNIQUE() – Returns unique values from a range.

FILTER() – Filters data dynamically.

=FILTER(A2:B10, B2:B10>50)



8️⃣ Pivot Tables & Power Query

PIVOT TABLES – Summarizes data dynamically.

GETPIVOTDATA() – Extracts data from a Pivot Table.

POWER QUERY – Automates data cleaning & transformation.


You can find Free Excel Resources here: https://t.me/excel_data

Hope it helps :)

#dataanalytics

🚀 𝗪𝗶𝗽𝗿𝗼 𝗘𝗹𝗶𝘁𝗲 𝗡𝗧𝗛 & 𝗧𝘂𝗿𝗯𝗼 𝗙𝗥𝗘𝗘 𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄 𝗞𝗶𝘁 💻🔥

Get access to a FREE interview preparation kit and prepare smarter for your upcoming assessment & interview rounds.

📚 Prepare For:-
✅ Technical Interview Questions
✅ Software Engineer Interview Rounds
✅ Interview Preparation Resources

🎯 Perfect for Students | Freshers | Engineering Graduates | Wipro Aspirants

🔗 𝗚𝗲𝘁 𝗙𝗥𝗘𝗘 𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄 𝗞𝗶𝘁 👇:-

https://pdlink.in/4zh9E6g

🔥 Start preparing early and improve your chances of cracking the Wipro hiring process!