Lecture - Descriptive Statistics in Excel
HTML-код
- Опубликовано: 3 окт 2024
- Let's explore how to summarize data using Excel
Chapters:
00:00 Introduction
00:40 What are descriptive statistics?
01:15 Level of measurement
03:14 Measures of central tendency
04:54 Measures of variability
05:44 Functions in Excel
07:23 Cell references
07:47 Range reference
08:51 Union reference
09:25 Tip: Checking the reference operators
10:07 Activity: Descriptive Statistics in Excel
12:19 Finding the mode
13:59 Finding the median
15:45 Finding the mean
16:27 Measures of Variability
16:47 Finding the range
17:52 Finding the IQR
20:40 Finding the variance
24:56 Finding the standard deviation
27:13 Interpretation of the standard deviation
27:52 Final instructions for the activity