MulaiMulai sekarang secara gratis

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.

Latihan ini adalah bagian dari kursus

Introduction to Statistics in Google Sheets

Lihat Kursus

Petunjuk latihan

  • In cell B14, use the AVERAGE() function to calculate the 2009 mean rating by passing in the range B2:B13.
  • To get all annual mean ratings, drag and fill in the formula from B14 across to I14.

Latihan interaktif praktis

Ubah teori menjadi tindakan dengan salah satu latihan interaktif kami.

Mulai berolahraga