Introduction to statistics

Introduction to Statistics in Google Sheets

Ted Kwartler

Data Dude

Sometimes it's ok to be mean (average)!

• Averages reduce information

What it takes to be mean (average)?

• Mean = Sum of all observations / Number of observations

Let's calculate an average

Person	Age
1	40
2	2
3	47
4	48
5	35
6	26
7	76
8	55
9	48
10	96

• Sum of all observations: 473
• Number of observations: 10
• Mean: 47.3

Let's calculate another average

Person	Age
1	15
2	17
3	21
4	13
5	10
6	16
7	12
8	21
9	19
10	14

• Sum of all observations: 158
• Number of observations: 10
• Mean: 15.8

Median averages

Person	Age
2	2
7	26
6	35
1	40
3	47
4	48
5	48
9	55
8	76
10	96

• Middle number of a dataset
• Half the numbers are less than the median
• Half the numbers are above the median

Median averages

Person	Age
2	2
7	26
6	35
1	40
3	47
4	48
5	48
9	55
8	76
10	96

• Middle number of a dataset
• Half the numbers are less than the median
• Half the numbers are above the median

Modal average

Person	Age
1	40
2	2
3	47
4	48
5	35
6	26
7	76
8	55
9	48
10	96

• Person 4 & 9 are both 48
• All other observations occur only once

Therefore the mode is 48

Mean average in Google Sheets

Mean average in Google Sheets

Mean average in Google Sheets

Median and Mode in Google Sheets

Let's practice some averages!

Introduction to Statistics in Google Sheets