ComeçarComece gratuitamente

How big are Jupiter's moons?

Categorical data is everywhere! It consists of a finite number of distinct values, called categories. When you're working with categorical data, understanding the different categories present in the data is an important first data exploration step. When looking at the unique categories, you might identify data quality issues, such as typos, which will mistakenly be identified as a distinct category.

Once you understand the different categories, you can filter your dataset on the categories to zoom-in and begin exploring your dataset on smaller scales.

In this exercise, you'll find the unique values in the Parent column as a data quality check, then use your new-found filtering skills to begin exploring the 79 moons of Jupiter!

Este exercício faz parte do curso

Análise de dados no Planilhas Google

Ver Curso

Instruções de exercício

  • In column E, find the unique values in the Parent column.
  • In column F, filter the Mean radius (km) column to return rows containing the moons of Jupiter.
  • In G2, calculate the median of the radius values in column F.

Exercício interativo prático

Transforme a teoria em ação com um de nossos exercícios interativos

Comece o exercício