Don't be average!
One of the most frequently used descriptive statistics is the mean, which is often just referred to as just the average. It is a useful statistic to compute when you are exploring a new dataset, such as this one, which lists Barack Obama's approval ratings in 2016.
Your job in this exercise is to manually compute the mean approval rating.
This exercise is part of the course
Introduction to Statistics in Google Sheets
Exercise instructions
- In cell
D2
, calculate theSUM()
of Barack Obama's approval rating for 2016. COUNT()
the number of observations in the data rangeA1:A13
.- Divide the sum by the count to calculate the monthly mean average.
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
