Statistics in Excel: Descriptive Statistics

Name: Statistics in Excel: Descriptive Statistics
Rating: 4.7 (10 reviews)

Master descriptive statistics and numerical summaries using Excel, step by step.

Created byalphas &betas

Last updated 3/2026

English

What you'll learn

Organize and summarize data in Excel using frequency tables, relative frequency tables, and two-way tables to identify patterns and relationships.
Calculate key statistical measures including mean, median, mode, percentiles, variance, and standard deviation to understand data distribution and variability.
Detect outliers and analyze associations between variables to uncover insights and inform decision-making.
Perform advanced data transformations and generate comprehensive summaries efficiently within Excel for faster, accurate statistical analysis.

Course content

1 section • 10 lectures • 1h 4m total length

How to create a frequency table8:27
Learn to create a frequency table in Excel by counting text, numbers, and ranges using functions such as unique and countif or a pivot table, with color and coffee examples.
How to create a relative frequency table2:03
Create a relative frequency table by dividing each value's frequency by the total, using sum to verify the total, as shown with black 20%, red 50%, and yellow 30%.
How to create a two-way frequency table2:30
Learn to build a two-way contingency table in Excel with a PivotTable to count occurrences of two categorical variables, such as gender and movie genre, including row and column totals.
How to calculate measures of central tendency2:39
Discover how to calculate central tendency in Excel by using mean, median, and mode. The lecture shows average, median, mode.mult, and mode.sngl to identify typical values in a data set.
How to calculate measures of relative location10:36
Explore measures of relative location, including quartiles, percentiles, and other quantiles, using Excel functions quartile.inc, quartile.exc, percentile.inc, and percentile.exc, including quintiles and deciles.
How to calculate measures of spread8:54
Learn to calculate measures of spread in Excel, including range, interquartile range, variance, standard deviation, and coefficient of variation, using functions like max, min, quartile.inc, var.p, var.s, stdev.p, and stdev.s.
How to calculate measures of association14:11
Explore measures of association by computing covariance and correlation in Excel, using population and sample formulas, and creating covariance and correlation matrices with the Analysis ToolPak.
How to calculate all numerical summaries at once2:49
Use the Analysis ToolPak to compute descriptive statistics in Excel for multiple variables. Load the tool, set input ranges, group by columns, and choose output, noting sample versus population.
How to find outliers9:57
Identify outliers in a data set using z-scores, interquartile range, and percentiles, then flag extreme values with Excel functions like AVERAGE, STDEV.S, QUARTILE.INC, and IF.
How to transform values2:14
Transform values by replacing each variable with a function of itself using square root, log, square, cube, or inverse. Apply sqrt and log10, and copy formulas across the column.

Requirements

No prior knowledge of statistics is required.

Description

[This course contains the use of artificial intelligence.] - Voiceover

Statistics in Excel is a practical, step-by-step course designed to teach you how to summarize, analyze, and interpret data using Excel’s built-in tools. Whether you are a student, analyst, or professional looking to improve your data skills, this course provides everything you need to confidently perform descriptive statistical analysis.

You will start by learning how to create frequency tables, relative frequency tables, and two-way frequency tables, allowing you to organize data and identify patterns quickly. From there, the course covers essential measures of central tendency, including mean, median, and mode, and measures of relative location, helping you understand the position of individual data points within your dataset.

Next, you will explore measures of spread such as range, variance, and standard deviation, along with measures of association to understand relationships between variables. You will also learn how to calculate complete numerical summaries in a single step, saving time while ensuring accuracy.

The course also teaches techniques to identify outliers that may skew your analysis and demonstrates data transformation methods to prepare datasets for further statistical modeling. Each lesson is designed to be practical and hands-on, using real Excel examples so you can immediately apply what you learn.

By the end of this course, you will be able to generate comprehensive statistical summaries, detect unusual data points, and transform data effectively—all within Excel. This course equips you with the skills to analyze and interpret data confidently, making your work or studies more efficient and insightful.

Who this course is for:

Beginners with little or no prior knowledge of statistics.