DEV Community: Sami

Statistics

Sami — Tue, 30 Jun 2026 10:43:20 +0000

Descriptive Statistics Explained

My notes while learning Statistics for Data Science

When I first started learning Data Science, I thought statistics was just another boring mathematics subject with formulas to memorize.

I was completely wrong.

The more I learned, the more I realized that statistics is actually the language of data. Before building Machine Learning models, creating dashboards, or making predictions, we first need to understand what our data is trying to tell us.

This blog is my attempt to explain the concepts in a simple way—the way I understood them while learning.

What is Statistics?

Imagine a company has data of 10 million customers.

Can a human sit and read every row?

Obviously not.

Statistics helps us summarize huge amounts of data into meaningful information so we can make decisions.

Instead of reading every single record, statistics answers questions like:

What is the average customer age?
Which product sells the most?
How much variation exists in customer spending?
Are sales increasing or decreasing?

In simple words,

Statistics is the science of collecting, organizing, analyzing, and understanding data.

This is exactly why statistics is used almost everywhere.

Netflix recommends movies using statistical patterns.
Hospitals test whether a new medicine actually works.
Companies forecast future sales.
Governments conduct surveys before making policies.

Types of Statistics

Statistics is mainly divided into two parts.

1. Descriptive Statistics

This is where every Data Analyst starts.

Descriptive Statistics focuses on understanding the data we already have.

It answers questions like:

What is the average salary?
Which category appears most?
How spread out are the values?
What does the data look like?

It does not predict the future.

It simply describes the present.

Example:

Suppose we have students' marks.

Using descriptive statistics, we can calculate:

Average marks
Highest marks
Lowest marks
Most common marks
Overall distribution

2. Inferential Statistics

This goes one step ahead.

Instead of describing existing data, it tries to make conclusions about a larger population using only a sample.

For example,

Imagine India has more than a billion people.

Surveying every person isn't possible.

Instead, researchers survey a small group and use statistics to estimate what the entire population might think.

Machine Learning heavily depends on Inferential Statistics because models learn patterns from sample data and apply them to unseen data.

Population vs Sample

This was one of the easiest concepts once I stopped overthinking it.

Suppose a college has 12,000 students.

The Population is all 12,000 students.

Now imagine we randomly choose 500 students for a survey.

Those 500 students are called the Sample.

Population
↓

12000 Students

↓

Take 500 Random Students

↓

Sample

Since collecting data from everyone is expensive and time-consuming, most companies work with samples.

The important part is choosing the sample correctly.

A good sample should be:

Large enough
Random
Representative of the entire population

Otherwise, the conclusions may be misleading.

Parameter vs Statistic

This confused me initially because the words sound almost the same.

Here's how I remember it.

A Parameter describes the entire population.

A Statistic describes only the sample.

For example,

Average salary of every employee in a company

→ Parameter

Average salary of 300 surveyed employees

→ Statistic

Simple.

Types of Data

Before doing any analysis, we should understand what kind of data we're working with.

Some data represents categories.

Examples:

Gender
Department
City
Blood Group

Some data represents numbers.

Examples:

Salary
Height
Weight
Age
Marks

Knowing the data type helps us choose the right visualization and statistical method.

Measure of Central Tendency

Suppose your friend asks,

"Can you summarize this dataset in one number?"

That's exactly what central tendency does.

It finds the center of the data.

There are different ways to define this center.

Mean (Average)

The most commonly used measure.

Formula:

Mean = Sum of all values / Number of values

Example

Marks:

80 90 70 60 100

Mean

(80+90+70+60+100)/5

=80

Easy.

But there's a problem.

Mean is affected by extreme values.

Suppose one billionaire enters a room of middle-class people.

Suddenly the average wealth becomes enormous.

That doesn't represent reality.

Median

Median is the middle value after arranging the data.

Example

10 20 25 30 90

Median = 25

Unlike the mean, median ignores extremely high or low values.

That's why salaries, house prices, and income distributions often use the median instead of the average.

Mode

Mode is simply the value that appears most frequently.

Example

2 3 5 3 6 7 3

Mode = 3

This is useful when analyzing customer preferences.

Example:

Most purchased mobile brand.

Most common payment method.

Most selected course.

Weighted Mean

Sometimes every value shouldn't have equal importance.

Example:

Your semester marks.

Maybe:

Assignments = 20%

Mid Exam = 30%

Final Exam = 50%

Here we cannot simply calculate the average.

Each score has a different weight.

That's where Weighted Mean becomes useful.

Trimmed Mean

Imagine a company accidentally records these salaries.

That last value is an extreme outlier.

Instead of letting one unusual value distort the average, we remove a small percentage of the highest and lowest values before calculating the mean.

This gives a more reliable average.

Measure of Dispersion

Knowing only the average isn't enough.

Consider these two classes.

Class A

Class B

Both have the same average.

But clearly, Class B is much more spread out.

Dispersion tells us how scattered the data is.

Range

The simplest measure.

Range = Maximum - Minimum

Example

10 20 30 50

Range = 50 − 10 = 40

Easy to calculate.

But it depends only on two values, so it's very sensitive to outliers.

Variance

Variance measures how far the values are from the average.

Instead of looking only at the highest and lowest values, it considers every observation.

Higher variance means the data is more spread out.

Lower variance means the values stay close to the average.

Standard Deviation

Standard deviation is simply the square root of variance.

It is probably the most important measure of spread in statistics.

A low standard deviation means the data points are tightly packed.

A high standard deviation means the data is widely scattered.

In Data Science, you'll see Standard Deviation almost everywhere—from feature engineering to anomaly detection and probability distributions.

Coefficient of Variation (CV)

Imagine two datasets.

Dataset A

Average = 20

Standard Deviation = 5

Dataset B

Average = 500

Standard Deviation = 20

Looking only at standard deviation isn't fair because the averages are completely different.

Coefficient of Variation solves this by comparing variability relative to the mean.

This makes it easier to compare datasets with different scales.

Visualizing Data

Numbers alone don't always tell the whole story.

Visualizations help us understand patterns much faster.

Some commonly used graphs include:

Frequency Distribution Table

Shows how many times each value appears.

Useful for categorical data.

Histogram

Used for numerical data.

It helps us understand:

Distribution
Skewness
Peaks
Outliers

Whenever I open a new dataset, one of the first charts I create is a histogram.

Scatter Plot

Scatter plots are useful when working with two numerical variables.

For example,

Hours Studied vs Marks

Experience vs Salary

Temperature vs Ice Cream Sales

They help identify relationships and trends.

Contingency Table

Used when comparing two categorical variables.

Example:

Gender vs Purchased Product

Department vs Promotion Status

It helps identify relationships between categories.

My Biggest Takeaway

Earlier, I thought statistics was all about formulas.

Now I see it differently.

Statistics is simply a way of asking better questions about data.

Instead of looking at thousands of rows, we summarize, visualize, compare, and understand what's happening.

Every Machine Learning model, every dashboard, and every business decision starts with this understanding.

Learning descriptive statistics has made me realize that before predicting the future with AI, we first need to understand the present through data.

And that's exactly what statistics teaches us.

What's Next?

In the next blog, I'll explore more about the Statistics, especially Inferential Statistics and explain it the same way—with simple examples, real-world intuition, and practical understanding instead of memorizing formulas.

If you're also starting Data Science, I hope these notes make your learning a little easier.

Database Fundamentals

Sami — Sat, 31 Jan 2026 11:16:19 +0000

📚 Database Fundamentals - Learning Notes

Learn database basics in simple language that anyone can understand!

📖 What You'll Learn

Why Data is Important
What are Databases?
What Makes a Good Database?
Different Types of Databases
Relational Databases Explained
What is DBMS?
What Does DBMS Do?
Understanding Database Keys
Relationships Between Data
Problems with Databases

🎯 Why Data is Important

Think of a database as a smart filing cabinet that stores information in an organized way.

Simple Definition: A database is a place where we keep related information together so everyone in a company can use it easily.

What Can You Do With Databases?

Store Lots of Information

Instead of keeping information in many Excel files or paper documents, you can put everything in one place. You can then easily search and find what you need.

Analyze Your Data

You can ask questions like "How many customers bought products last month?" and get answers quickly. You can also create reports to understand your business better.

Keep Track of Records

Need to remember who paid you money? What items are in your store? Customer phone numbers? A database keeps all this safe and organized.

Run Websites and Apps

Every time you use Facebook, Amazon, or any app, there's a database working behind the scenes to show you the right information.

💾 What are Databases?

Imagine you have a notebook where you write:

Names of your friends
Their phone numbers
Their birthdays

A database is like that notebook, but on a computer. It's organized, you can search it super fast, and many people can use it at the same time.

✨ What Makes a Good Database?

A good database should have these 5 things:

1. Integrity (Correctness)

The information should be accurate. If someone's age is 25, it shouldn't suddenly become 250!

2. Availability (Always Ready)

Whenever you need the data, it should be there. Like 24/7 customer support for your information.

3. Security (Protected)

Only the right people should see the information. Your bank details shouldn't be visible to everyone!

4. Independent of Application (Flexible)

The database should work with any program. Like how a USB drive works with any computer.

5. Concurrency (Multi-user)

Many people should be able to use it at the same time without problems. Like how many people can watch Netflix at once.

🗂️ Different Types of Databases

Just like there are different types of vehicles (car, bike, truck) for different needs, there are different types of databases:

1. Relational Databases (SQL)

This is like an Excel spreadsheet with tables, rows, and columns. Most popular and widely used!

Example: MySQL, PostgreSQL, Oracle

2. NoSQL Databases

Good for storing messy data like photos, videos, social media posts, documents.

Example: MongoDB (used by companies like Uber, eBay)

3. Column Databases

Instead of storing data row by row, it stores column by column. Great for analyzing huge amounts of data.

Example: Google BigQuery, Amazon Redshift

4. Graph Databases

Perfect for showing connections between things - like your friends on Facebook or recommendations on Netflix.

Example: Neo4j, Amazon Neptune

5. Key-Value Databases

Super simple - like a dictionary. You have a word (key) and its meaning (value).

Example: Redis, DynamoDB

Which one to pick? It depends on what you're building. For most beginner projects, start with Relational Databases!

🔄 Relational Databases Explained

Think of a relational database as multiple Excel sheets that are connected to each other.

Example:

Sheet 1: Student names and their ID numbers
Sheet 2: Class names and which students are in them
These sheets are "related" because they both use student IDs

How it looks:

Tables = Excel sheets
Rows = Each line of information (like one student)
Columns = Types of information (like name, age, email)

🖥️ What is DBMS?

DBMS = Database Management System

Think of it as the manager of your database.

Simple Analogy:

Database = Library (where books are stored)
DBMS = Librarian (who helps you find books, add new books, remove old books)

Popular DBMS software: MySQL, PostgreSQL, Oracle, Microsoft SQL Server

⚙️ What Does DBMS Do?

The DBMS is like a super assistant that does these jobs:

Data Management

Helps you save information, find it later, and change it when needed.

Keeps Data Accurate (Integrity)

Makes sure the information stays correct. Like preventing you from entering "ABC" as someone's age.

Multi-user Access (Concurrency)

Lets many people use the database at the same time without conflicts.

Transactions

Ensures that when you do something (like transferring money), it either completes fully or doesn't happen at all. No half-done work!

Security

Only authorized people can see or change the data. Like having passwords for your email.

Useful Tools (Utilities)

Helps with backup (saving copies), importing/exporting data, and managing users.

🔑 Understanding Database Keys

What is a Key?

A key is like a unique ID that helps identify each piece of information in your database.

Real-life example: Your Aadhaar card number is unique to you. No one else has the same number.

Types of Keys (Simplified):

1. Super Key

Any combination of information that can uniquely identify a row.

Example: In a student table, "Roll Number + Name" can identify a student.

2. Candidate Key

The smallest piece of information that can uniquely identify someone. No extra stuff needed.

Example: Just "Roll Number" is enough. You don't need the name too.

3. Primary Key ⭐ (Most Important!)

The ONE key you choose to identify each row. It's the main ID.

Example: Roll Number is the primary key for students.

Rules:

Must be unique (no duplicates)
Cannot be empty (no null values)
Only one primary key per table

4. Alternate Key

Other candidate keys that you didn't choose as the primary key.

Example: Email could also be unique, but you chose Roll Number as primary.

5. Composite Key

When you need TWO or more columns together to uniquely identify a row.

Example: "Class + Seat Number" together identify a student (because seat numbers repeat in different classes).

6. Surrogate Key

An artificial ID you create when there's no natural unique identifier.

Example: Auto-generated customer ID: CUST001, CUST002, CUST003...

7. Foreign Key

A key from another table used to connect two tables together.

Example: Student table has a "Branch_ID" that connects to the Branch table.

Example Table:

Roll No ⭐	Name	Branch	Email
1	Ash	CSE	ash@gmail.com
2	Brock	EEE	brock@gmail.com
3	Tracy	ME	tracy@gmail.com

Here, Roll No is the Primary Key!

🔗 Relationships Between Data

Cardinality sounds complex, but it just means: "How many?"

It tells us how many items in one table can connect to items in another table.

Easy Examples:

1. One Person → One Driving License (One-to-One)

Each person has only one driving license, and each license belongs to only one person.

2. Many Students → One Branch (Many-to-One)

Many students can be in the CSE branch, but each student belongs to only one branch.

3. One Restaurant → Many Orders (One-to-Many)

One restaurant can have many orders, but each order comes from one restaurant.

4. One Restaurant → One Menu (One-to-One)

Each restaurant has one menu (in this simple case).

5. Many Students → Many Courses (Many-to-Many)

Students can take multiple courses, and each course has multiple students.

Quick Summary:

One-to-One (1:1) = Each person has exactly one passport
One-to-Many (1:N) = One teacher teaches many students
Many-to-One (N:1) = Many employees work in one department
Many-to-Many (M:N) = Many students attend many classes

⚠️ Problems with Databases

Nothing is perfect! Here are some challenges with databases:

Complexity

Setting up a database is not easy. It takes time to learn and do it properly, especially for big systems.

Cost

You need to buy software, powerful computers, and hire people who know how to manage it. This can be expensive.

Scalability Issues

When your data grows too big, the database can become slow. Imagine a closet that's too full - hard to find things!

Data Accuracy Problems

When many people update data at the same time, mistakes can happen. Like two people editing the same document simultaneously.

Security Risks

Hackers are always trying to steal data. You need to constantly protect your database from attacks.

Migration Headaches

Moving data from one database to another is like moving houses - difficult and time-consuming!

Rigid Structure

Once you design your database, changing it later is hard. Like trying to add a room to a house after it's built.

💡 Quick Tips for Beginners

✅ Start with relational databases (SQL) - they're the most common

✅ Practice with small projects - like a contact list or to-do app

✅ Learn SQL commands - they're like English sentences

✅ Don't worry about memorizing everything - understanding concepts is more important

✅ Use free databases like MySQL or PostgreSQL to practice

🤝 Want to Contribute?

Found a typo? Want to add more simple examples? Feel free to improve these notes!

📜 License

These notes are free to use for learning. Share with friends!

🌟 Thank You

These notes are from my learning journey. I hope they help you understand databases easily!

Remember: Everyone starts as a beginner. Take it one step at a time! 🚀

Questions? Confused about something? That's normal! Keep reading and practicing - it'll click! 💪

🌱 How I Started My Coding Journey in C (2022)

Sami — Mon, 08 Sep 2025 16:01:09 +0000

When I started my Engineering in Computer Science and Engineering (AIML) in 2022, I honestly had no idea about coding. Programming felt like a completely new world, and I wasn’t sure where to begin.

Then came my very first programming language: C.

⚡ My First Experience with C

The very first program I wrote was a simple one — printing numbers from 1 to 1000.

It might sound small now, but at that moment it felt mind-blowing. The idea that I could give instructions to a machine and see it execute them instantly was something magical.

That was the moment I realized:

> “Computers can do in seconds what would take me hours — if only I learn how to talk to them.”

🔑 What C Taught Me

Even though C was just the beginning, it gave me some valuable lessons:

Logic matters more than syntax.
Small programs can spark big curiosity.
Learning by doing is the best way to grow.

🚀 The Curiosity Spark

That one simple program changed my mindset. I went from:
❌ “Coding looks too hard”
✅ “What else can I make computers do?”

This curiosity became the fuel for my entire journey ahead — from exploring websites, to JavaScript, React, and even AI/ML.

✨ Closing Thoughts

If you’re just starting out, don’t underestimate the power of small beginnings. Writing a basic program in C might feel simple, but it can ignite a journey that takes you much further than you imagine.

For me, it all started in 2022, with a few lines of C code that printed numbers — and it completely changed how I look at technology.

👉 This is Part 1 of my journey. In the next blog, I’ll share how my curiosity about the web led me to HTML, CSS, and the world of Web Development.