Menu
Menu

    LIVE Classes

    VLSI Design Programme
    VLSI Design Programme New

    IIT Delhi certified

    AI & Machine Learning
    AI & Machine Learning New

    Intel & IIT-M Pravartak certified

    Data Science
    Data Science

    IIT-M Pravartak certified

    Full Stack Development
    Full Stack Development

    IIT-M Pravartak certified

    UI/UX Design
    UI/UX Design

    HCL GUVI certified

    AI DevOps Program
    AI DevOps Program

    HCL GUVI certified

    Courses

    Practice

    CodeKata

    CodeKata

    Sharpen your coding skills, prepare for interviews

    WebKata

    WebKata

    Build basic frontend & backend development skills

    SQLKata

    SQLKata

    Master SQL concepts in relational database management

    FixTheCode

    FixTheCode

    A series of programs curated by industry experts

    IDE - Online Compiler

    IDE - Online Compiler

    Run & test your code in any programming language

    Resources

    Free Resources

    Free Resources

    Referral

    Referral

    Success Stories

    Success Stories

    Blogs

    Blogs

    Learn Hub

    Learn Hub

    Get The App

    Get The App

    Rewards

    Rewards

    Become an Affiliate

    Become an Affiliate

    Leaderboard

    Leaderboard

    What's New?
    Resume Builder

    Resume Builder

    Community Hub

    Community Hub

    Our Products

    HackerKID

    HackerKID

    Coding classes platform for K-12 children

    GUVI For Corporates

    GUVI For Corporates

    Meet your Hiring & Training Needs

    Placement Preparation

    Placement Preparation

    Ace Up your Aptitude

    Play StoreApp Store
Still Confused?WhatsApp

Welcome to HCL GUVI

Hey there! Welcome to HCL GUVI—Grab Your Vernacular Imprint—where tech learning is easy, fun, and curated specially for you. Incubated by IIT Madras & IIM Ahmedabad in 2014 and now part of HCL Group, we're making quality tech education accessible to all.

Join 3M+ learners breaking barriers and upskilling for a brighter future. We're here to guide you every step of the way! 🚀

LIVE Classes

Zen Classes are HCL GUVI's most refined and flagship product—live, expert-led tech programs for beginners and pros. With IITM Pravartak affiliations, master Full-Stack, Data Science, DevOps, UI/UX, and more in multiple languages!

Explore More

Courses

Looking for flexibility? HCL GUVI's 200+ self-paced courses let you learn anytime, anywhere! From free lessons to IIT-M & Autodesk-certified programs, gain in-demand skills in your preferred language.

Explore More

Practice Platforms

Enhance your coding skills with HCL GUVI's Practice Platforms—interactive, structured, and designed to help you master programming effortlessly.

CodeKata:

A structured coding practice platform with 1500+ coding problems designed by industry experts. Ideal for beginners and professionals preparing for tech interviews with real-world coding challenges.

Try Now >

WebKata:

An interactive platform to master HTML, CSS, JavaScript, and Bootstrap with a live coding environment. Perfect for hands-on web development practice without any setup.

Try Now >

SQLKata:

A practice ground for mastering SQL queries used in real-world applications. Write, optimize, and refine your queries to build strong database skills.

Try Now >

FixTheCode:

Hone your bug-fixing skills with real-world debugging challenges in Python, C++, JavaScript, and Golang. More languages coming soon!

Try Now >

IDE:

A free online compiler supporting 20+ programming languages with auto-complete, debugging, and AI-powered code generation—all in the cloud!

Try Now >

Leaderboard

Climb the leaderboard as you earn Geekoins by learning and practicing! The top scorers get featured, making learning competitive and rewarding. Keep going—you could be next!

Explore More

Rewards

Earn Geekoins by watching videos and practicing problems, then redeem them for exciting rewards. The more you engage, the more you win!

Explore More

Referral

Love learning with HCL GUVI? Share it with friends! Invite them using your unique link or code and unlock exciting rewards—Amazon vouchers, iPhones, and more. A Win-Win.

Explore More

Profile

Your HCL GUVI profile is your digital portfolio! Track progress, showcase skills, add projects, and build a resume. Keep it updated—opportunities await!

Explore More

That's It! You Are Ready!

You're all set to dive into your learning journey with HCL GUVI. Explore, upskill, and make each step count—exciting possibilities awaits!

Thank you for Reaching us out

Our team will reach you out
within the next 24 hours.

Explore all Programs

Descriptive Statistics

Lesson 1: Descriptive Statistics

What are descriptive statistics?

Descriptive statistics summarise the main features of a dataset.

Category

Question

Measures

CentreWhat is a typical value?Mean, median, mode
SpreadHow much do values differ?Range, variance, standard deviation, IQR
ShapeHow are values distributed?Skewness, histograms
PositionWhere does a value sit?Percentiles, quartiles

Use them to understand data before comparing groups or building models.

Mean, median, and mode

Measure

Definition

Strength

Weakness

Best for

MeanSum ÷ countUses every valuePulled by extreme valuesSymmetric numeric data
MedianMiddle value after sortingResistant to outliersIgnores the size of extremesSkewed data (income, prices, delivery time)
ModeMost frequent valueWorks for categoriesMay be several modes, or noneCategories, common sizes

Example

Monthly spending: 100, 110, 120, 130, 900

Measure

Calculation

Result

Mean(100 + 110 + 120 + 130 + 900) ÷ 5 = 1,360 ÷ 5272
MedianMiddle of sorted values120
Range900 − 100800
  • The single value of 900 raises the mean far above what most people spend.
  • Reporting only the mean would mislead readers about typical spending.

Spread

Measure

Meaning

Notes

RangeMax − minSimple, but driven by the two most extreme values
VarianceAverage squared distance from the meanIn squared units, so hard to interpret directly
Standard deviation (SD)Square root of varianceSame units as the data; "typical distance from the mean"
Interquartile range (IQR)Q3 − Q1Spread of the middle 50%; resistant to outliers
  • Sample variance and SD divide by n − 1 rather than n, to avoid underestimating population spread.
  • Two datasets can share the same mean but have very different spreads:

Dataset

Values

Mean

SD (sample)

A48, 50, 52502
B10, 50, 905040

Key takeaways

  • Choose summary measures based on the shape and purpose of the data.
  • For skewed numeric data, report both median and mean to make the effect of extreme values visible.
  • Always pair a measure of centre with a measure of spread.

Try it: Calculate the mean and median for five values, then add one unusually large value and compare how the measures change.

Share

You can share this topic with your family and friends on Social Media.

Share in

Data Analytics Tutorial

Data Analytics Tutorial

MODULE 1 : Foundations of Data Analytics
lessonIntroduction - Foundations of Data Analytics
lessonWhat is Data Analystics
lessonTypes of Data Analytics
lessonThe Data Analytics Workflow
lessonData Types, Sources, and Structure
lessonTurning a Business Request into an Analytical Question
MODULE 2 : Spreadsheets and Practical Data Handling
lessoniIntroduction - Spreadsheets and Practical Data Handling
lessonUnderstanding Spreadsheet Structure
lessonFormulas and Cell References
lessonEssential Functions for Analysis
lessonSorting, Filtering, and Data Validation
lessonLookups and Pivot Tables
MODULE 3 : SQL for Data Analytics
lessonSQL for Data Analytics - Introduction
lessonDatabases and Your First SQL Query
lessonFiltering, Sorting, and Limiting Results
lessonAggregate Functions and GROUP BY
lessonJoining Related Tables
lessonCASE, Subqueries, and CTEs
MODULE 4 : Python for Data Analytics
lessonPython for Data Analytics Introduction
lessonPython Basics for Analysts
lessonConditions, Loops, and Functions
lessonReading and Inspecting Data with pandas
lessonCleaning and Transforming Data
lessonGrouping, Summaries, and Visualisation
MODULE 5 : Statistics for Data Analytics
lessonStatistics for Data Analytics Introduction
lessonDescriptive Statistics
lessonDistributions, Percentiles, and Outliers
lessonSampling and Uncertainty
lessonHypothesis Testing and Confidence Intervals
lessonCorrelation, Regression, and Causation
MODULE 6 : Data Visualization Reporting and Dashboards
lessonData Visualisation, Reporting, and Dashboards Introduction
lessonChoosing the Right Chart
lessonVisual Design and Avoiding Misleading Charts
lessonKPIs and Dashboard Planning
lessonBuilding Reports in BI Tools
lessonPresenting an Insight and Recommendation
MODULE 7 : Exploratory Data Analysis and Data Cleaning
lessonExploratory Data Analysis and Data Cleaning - Introduction
lessonStarting an Exploratory Data Analysis
lessonMissing Values and Their Meaning
lesson Duplicates, Inconsistent Labels, and Data Types
lesson Outliers and Validation Rules
lessonA Reproducible Cleaning Pipeline
MODULE 8 : Business Product and Marketing Analytics
lessonBusiness, Product, and Marketing Analytics Introduction
lessonSales and Revenue Analytics
lessonCustomer Retention and Churn
lessonMarketing Funnel and Campaign Analytics
lessonProduct Analytics and User Journeys
lessonOperational Analytics and Root-Cause Investigation
MODULE 9 : Advanced Analytics - Forecasting and Machine Learning Basics
lessonAdvanced Analytics, Forecasting, and Machine Learning Basics - Introduction
lessonForecasting and Time-Series Basics
lessonRegression and Classification
lessonClustering and Segmentation
lessonModel Evaluation and Choosing Metrics
lessonOverfitting, Leakage, and Responsible Modelling
MODULE 10 : Data Workflows - Warehousing and Professional Practice
lessonData Workflows, Warehousing, and Professional Practice - Introduction
lessonOperational Databases and Data Warehouses
lessonETL, ELT, and Data Pipelines
lessonAutomation, Scheduling, and Monitoring
lessonDocumentation, Version Control, and Collaboration
lessonPrivacy, Governance, and Ethical Practice
MODULE 11 : Final Lesson: Bringing It All Together
lessonFinal Lesson: Bringing It All Together

Learn via Video Course

Data Analysis and Processing with Python using Pandas - Data Science Course Logo

Data Analysis and Processing with Python using Pandas - Data Science Course

5 hrs

Get in Touch For Details

Data Analytics Tutorial

MODULE 1 : Foundations of Data Analytics
lessonIntroduction - Foundations of Data Analytics
lessonWhat is Data Analystics
lessonTypes of Data Analytics
lessonThe Data Analytics Workflow
lessonData Types, Sources, and Structure
lessonTurning a Business Request into an Analytical Question
MODULE 2 : Spreadsheets and Practical Data Handling
lessoniIntroduction - Spreadsheets and Practical Data Handling
lessonUnderstanding Spreadsheet Structure
lessonFormulas and Cell References
lessonEssential Functions for Analysis
lessonSorting, Filtering, and Data Validation
lessonLookups and Pivot Tables
MODULE 3 : SQL for Data Analytics
lessonSQL for Data Analytics - Introduction
lessonDatabases and Your First SQL Query
lessonFiltering, Sorting, and Limiting Results
lessonAggregate Functions and GROUP BY
lessonJoining Related Tables
lessonCASE, Subqueries, and CTEs
MODULE 4 : Python for Data Analytics
lessonPython for Data Analytics Introduction
lessonPython Basics for Analysts
lessonConditions, Loops, and Functions
lessonReading and Inspecting Data with pandas
lessonCleaning and Transforming Data
lessonGrouping, Summaries, and Visualisation
MODULE 5 : Statistics for Data Analytics
lessonStatistics for Data Analytics Introduction
lessonDescriptive Statistics
lessonDistributions, Percentiles, and Outliers
lessonSampling and Uncertainty
lessonHypothesis Testing and Confidence Intervals
lessonCorrelation, Regression, and Causation
MODULE 6 : Data Visualization Reporting and Dashboards
lessonData Visualisation, Reporting, and Dashboards Introduction
lessonChoosing the Right Chart
lessonVisual Design and Avoiding Misleading Charts
lessonKPIs and Dashboard Planning
lessonBuilding Reports in BI Tools
lessonPresenting an Insight and Recommendation
MODULE 7 : Exploratory Data Analysis and Data Cleaning
lessonExploratory Data Analysis and Data Cleaning - Introduction
lessonStarting an Exploratory Data Analysis
lessonMissing Values and Their Meaning
lesson Duplicates, Inconsistent Labels, and Data Types
lesson Outliers and Validation Rules
lessonA Reproducible Cleaning Pipeline
MODULE 8 : Business Product and Marketing Analytics
lessonBusiness, Product, and Marketing Analytics Introduction
lessonSales and Revenue Analytics
lessonCustomer Retention and Churn
lessonMarketing Funnel and Campaign Analytics
lessonProduct Analytics and User Journeys
lessonOperational Analytics and Root-Cause Investigation
MODULE 9 : Advanced Analytics - Forecasting and Machine Learning Basics
lessonAdvanced Analytics, Forecasting, and Machine Learning Basics - Introduction
lessonForecasting and Time-Series Basics
lessonRegression and Classification
lessonClustering and Segmentation
lessonModel Evaluation and Choosing Metrics
lessonOverfitting, Leakage, and Responsible Modelling
MODULE 10 : Data Workflows - Warehousing and Professional Practice
lessonData Workflows, Warehousing, and Professional Practice - Introduction
lessonOperational Databases and Data Warehouses
lessonETL, ELT, and Data Pipelines
lessonAutomation, Scheduling, and Monitoring
lessonDocumentation, Version Control, and Collaboration
lessonPrivacy, Governance, and Ethical Practice
MODULE 11 : Final Lesson: Bringing It All Together
lessonFinal Lesson: Bringing It All Together

ZEN CLASS

LIVE CLASS

Popular Courses

Self-Paced Courses

Practice Platforms

Community

Products

Resources

Company

ZEN CLASS

LIVE CLASS

Popular Courses

Self-Paced Courses

Practice Platforms

Community

Products

Resources

Company

app store
play store
Refer & Earn

HCL GUVI (Grab Your Vernacular Imprint) Geek Network Private Limited is a leading online learning and skills development company, incubated by IIT Madras and IIM Ahmedabad.

Established in 2014 and acquired by the HCL Group in 2022, HCL GUVI is dedicated to providing effective and high-quality learning and skilling programs that transcend language barriers in technology education. HCL GUVI today is trusted by over 4.8 million users, 20 languages and 2500+ corporate partners.

app storeplay store
Refer & Earn

HCL GUVI (Grab Your Vernacular Imprint) Geek Network Private Limited is a leading online learning and skills development company, incubated by IIT Madras and IIM Ahmedabad.

Established in 2014 and acquired by the HCL Group in 2022, HCL GUVI is dedicated to providing effective and high-quality learning and skilling programs that transcend language barriers in technology education. HCL GUVI today is trusted by over 4.8 million users, 20 languages and 2500+ corporate partners.

app storeplay storeRefer & Earn
Terms and ConditionsPrivacy Policy

HCL GUVI Geek Network Pvt. Ltd.

Terms and ConditionsPrivacy Policy

HCL GUVI Geek Network Pvt. Ltd.