You have been hired by a consulting group that researches worldwide trends related to resource usage. Your job is to analyze large sets of data to identify trends related to population, population density, or male$-$to$-$female population ratios around the world.

Review this data set from the United Nations related to populations for different parts of the world.

Identify $2$ or $3$ aspects of the data that you would like to investigate.

Think about how you need to organize and transform your data and whether it is better to use formulas, functions, or a Pivot Table, and then organize and transform the data using that method in Microsoft Excel.

Create a new sheet in your workbook and discuss the following:

How you used formulas, functions, and PivotTables in organizing and transforming your data set

The advantages and disadvantages of each tool

What you learned in implementing the data transformation for this assignment