Explore BrainMass

Using MS Excel for Descriptive Statistics

Jeremy Shearer, PhD (IP) (#110194)

In this video lecture, Academic Expert Jeremy Shearer explains how students can use Microsoft Excel for describing and analyzing data. He begins with an explanation of what descriptive statistics are, and from there he explains how they can be used to help us understand data. Jeremy explains how to make decisions using the raw data, and he explains several different charts and graphs that can be used to illustrate and easily explain said data. This video lecture is ideal for students at the college or university level taking a first year or second year level statistics course.

In this series: 6 Videos | 00:25:58 Total Length

Descriptive statistics are defined in the first video in the series, and Jeremy explains how they can help us to understand data.

Part #: 1 | 05:05

Jeremy explains how to format tables in MS Excel. He then shows examples of good data and bad data, and how much easier it is to work with good data tables.

Part #: 2 | 03:55

Histograms, dot plots, and line charts are some examples that are presented of how to graph data.

Part #: 3 | 04:31

How to format charts in MS Excel and how to calculate descriptive stats.

Part #: 4 | 03:56

Reading and understanding central tendency.

Part #: 5 | 05:07

Reading and understanding dispersion and variance, and future tips for working with descriptive statistics.

Part #: 6 | 03:24