Descriptive Statistics in Microsoft Excel

Name: Descriptive Statistics in Microsoft Excel (English version)
SKU: 9B16E014

Kyle Maclean; Lauren E. Cipriano; Gregory S. Zaric

Product #:9B16E014

Supplier:Ivey

Discipline:Management Science

Setting:2016

Details:Note (PDF) • 13 pages • 2016-06-30 (Rev: 2016-06-29)

Subjects:

Analytics and data science Data science

Your Price:

$9.71

Language:

Format:

Purchase this material with a free Educator Account and enjoy more benefits:

Free Educator Copy
Free Teaching Notes
Build your coursepack
Discounted academic price

The purpose of this note is to illustrate the use of Microsoft Excel functions for generating descriptive statistics for continuous data. These functions are common when analyzing data to provide insights for decision making. The note includes practice exercises and their solutions, and a supporting Excel workbook for students.

Learning Objectives

After completion of this note and its associated activities, students should be able to do the following:

Use the Microsoft Excel functions that identify the minimum, maximum, rank, average, median, variance, and standard deviation of a single continuous variable data set.
Use the Microsoft Excel functions for computing the covariance and the correlation between two continuous variables in a data set.