Only this week, get the SQL Complete Track of 9 courses in a special prize of $330$89!
Create new variables
Grouping and statistical functions
7. Median and mean
Joining datasets
Summary

## Instruction

Having one statistic is not very informative. We can calculate other statistics within the same summarise() function by separating the functions with commas, as we did earlier.

Suppose we need both the median and mean populations. We could write:

countries %>%
summarise(
avg_pop = mean(population),
median_pop = median(population))


## Exercise

Use summarise() along with the median() and mean() functions to calculate the average urban population and average urban population percentage (based on the urban_pop_pc column). Give the new columns the names median_urban_pop and avg_urban_pc, respectively.

### Stuck? Here's a hint!

Type:

countries %>%
summarise(
median_urban_pop = median(urban_population),
avg_urban_pc = mean(urban_pop_pc))