Descriptive Statistics

Summarize your data by finding the mean, median, standard deviation, and other descriptive statistics.

Min and Max
In this video I demonstrate how to use =min() and =max() to calculate the minimum and maximum scores in a dataset.

Mean, Median, and Standard Deviation
Learn how to use the =average(), =median(), and =stdev() functions to calculate the mean, median, and standard deviation.

Descriptive statistics for nominal or ordinal data: Frequencies using =countif
The =countif() function calculates frequencies in Excel. In this video, you’ll learn how to use =countif() to tally how many people selected strongly agree, agree, disagree, and strongly disagree options in a satisfaction survey.

Descriptive statistics for nominal or ordinal data: Countif with $
Next, use $ symbols within your =countif function to save even more time as you tally responses on a satisfaction survey.

Descriptive statistics for interval or ratio data

In this video, I show you how to calculate a variety of descriptive statistics for interval or ratio data, including:

  • Basic data cleaning: =count, =countblank
  • Measures of central tendency: =average, =median, =mode
  • Measures of dispersion: =var, =stdev, =min, =max, =quartile, ranges

This tutorial is designed for people with a basic statistics or social science background. That is, I explain how to translate your preexisting knowledge about descriptive statistics into simple Excel formulas rather than explaining why these metrics are useful.

Free Download Bonus! Download the spreadsheet used in this video.

Filtering a list to find unique entries

How many different categories (like states) are represented in your dataset? In this video, I teach you three strategies for determining how many unique entries are represented:

  • Filters
  • Pivot table tallies
  • Advanced filters
Free Download Bonus! Download the spreadsheet used in this video.

Togel Togel Togel Togel Togel Togel Online Toto Slot Togel Online Togel178 Pedetogel Pedetogel Situs Togel Terpercaya Togel178 Togel279 Toto Macau Situs Togel Bandar Togel Agen Togel Bo Togel Daftar Togel Togel279 Toto Macau Colok178 Bo Togel Terpercaya Toto Togel Sabatoto Slot Server Luar Negeri rote4d rote4d rote4d togel158 togel158 togel279 togel279 pedetogel togel178 rote4d sabatoto Togel279 Rote4d Togel Online togel sabatoto pedetogel colok178 Slot88 Situs Togel Prize 123 Bo Togel Terpercaya Togel Online Daftar Akun Togel Resmi Toto Macau Toto Togel Situs Togel Terpercaya Situs Togel Via Pulsa Tanpa Potongan Daftar Togel Via Pulsa Tanpa Potongan Daftar Togel Via Dana Togel Via Dana Toto Slot Bandar Togel Hadiah 4D 10 Juta Terpercaya Bandar Togel Hadiah 4D Bo Togel Hadiah 2D bo togel terpercaya Togel279 Sabatoto togel158 pedetogel Pedetogel togel158 pedetogel togel178 sabatoto togel279 pedetogel pedetogel rote4d togel158 togel Togel Kingkong kingkong4d kingkongpools togel bolak balik pedetogel sabatoto pragmatic178 togel178 togel158 novaslot88 togel279 pedetogel sabatoto togel158 novaslot88 togel279 togel178 Togel Togel Dana Toto Situs Toto Result Toto Macau Result Toto Macau Toto Togel ladangtoto Bandar Togel Terbesar Togel Bet 100 badak188 Toto Slot Daftar Togel Togel Via Pulsa Kode Syair Sdy Aplikasi Togel Syair Toto Agen Togel Terbesar Bo Togel Daftar Akun Togel Agen Slot Pgsoft Situs Togel Bet 100 Perak toto togel dana toto toto macau Bandar Togel Hadiah 4D 10 Juta Terpercaya Toto Slot Situs Toto Bo Togel Terpercaya Togel Via Pulsa Togel Prize 123 Togel Bet 100 Agen Togel Situs Togel Hadiah Daftar Togel Daftar Bandar Togel Bo Togel Hadiah 2D Daftar Akun Togel Bandar Togel Bebas Invest 5 Situs Togel Resmi Terbaik Dan Terpercaya togel ewallet Situs Togel Terpercaya Bandar Togel Result Toto Macau Togel Diskon Bo Togel Bolak Balik Dibayar Aplikasi Togel Terpercaya Togel Via Dana Ovo Gopay Linkaja Bo Togel BBFS ladangtoto ladangtoto2 toto macau bandar togel