(LO 7-2) Download the “Population of Countries of the World” dataset in Excel from Connect (Dataset original source accessed May 2020: https://en.wikipedia.org/wiki/

List_of_countries_by_population_(United_Nations) ). Assess the first digit for population of countries of the world using Benford’s Law. (Hint: It may be helpful to complete Lab 7-4 before completing this problem.)

Required:

1. Using the left() command to capture the first digit and a PivotTable to summarize, count the first digits of country populations around the world.

2. Create a visualization for the count each first digit using a bar chart.

3. Analysis: Without performing any statistical analysis, do the country populations seem to conform with Benford’s Law?