Descriptive Statistics Syllabus

Descriptive Statistics

This course covers Descriptive Statistics and consists of 12 topics.

Histogram Creation – In this video we show how to use a histogram to summarize Cisco’s monthly returns.
Histogram Shapes – In this video we discuss symmetric, positively, and negatively skewed histograms.
Descriptive Statistics – In this video we discuss measures of typical value, variation about the mean, and skewness.
Rule of Thumb – In this video we discuss how to determine normal variation for any data set.
More Statistical Functions – In this video we discuss the PERCENT, PERCENTRANK, LARGE, SMALL, and RANK functions.
Taking a Random Sample – In this video we show how to take a random sample size of 50 from 285 NBA players.
Congressional Apportionment – In this video we show how to fairly allocate members of the House of Representatives based on state populations.
Matchmaker – In this video we show how statistical functions and data tables can be used to find your “perfect match.”
Multiple Objective Decision Making – In this video we show how to choose a job based on multiple objectives.
Income Inequality – In this video we use PivotTables, PivotCharts, and Excel Statistical functions to analyze the changes in the distribution of US family income between 2000 and 2015.
Descriptive Statistics for Grouped Data – In this video we show how to compute the mean, variance, and standard deviation for grouped data.
Chinese Accidental Deaths and Histograms – In this video we use a histogram to prove that Chinese provinces under-report accidental deaths.
Learn More