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!
This exercise is part of the course
Data Analysis in Google Sheets
Exercise instructions
- 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
.
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
