Presidential approval rating averages
Manually calculating the mean is straightforward enough when you have a small dataset, however in this age of big data, you don't want to be calculating means manually, especially when you're working with multiple columns, like in this exercise!
Your job here is to calculate the yearly average approval rating throughout Barack Obama's presidency.
This exercise is part of the course
Introduction to Statistics in Google Sheets
Exercise instructions
- In cell
B14
, use theAVERAGE()
function to calculate the 2009 mean rating by passing in the rangeB2:B13
. - To get all annual mean ratings, drag and fill in the formula from
B14
across toI14
.
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
