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 ejercicio forma parte del curso
Data Analysis in Google Sheets
Instrucciones de ejercicio
- In column
E
, find the unique values in theParent
column. - In column
F
, filter theMean radius (km)
column to return rows containing the moons of Jupiter. - In
G2
, calculate the median of the radius values in columnF
.
Ejercicio interactivo práctico
Convierte la teoría en acción con uno de nuestros ejercicios interactivos
