Here is the data set that you will be working with: Consider part of the data set of the world's population in 2019 by country such as the one below (Source: https://data.worldbank.org/indicator/SP.POP.TOTL) A B C 1 Country Name Country Code Year 2019 2 Brazil BRA 211,049,527 3 Barbados BRB 287,025 4 Brunei Darussalam BRN 433,285 5 Bhutan BTN 763,092 6 Botswana BWA 2,303,697 7 Central African Republic CAF 4,745,185 8 Canada CAN 37,589,262 9 Central Europe and the Baltics CEB 102,378,579 10 Switzerland CHE 8,574,832 11 Channel Islands CHI 172,259 12 Chile CHL 18,952,038 13 China CHN 1,397,715,000G2 X vf =COUNTIF(SO$2:$D$263,F2) A B C D E F G H 1 Country Name Country Code Year 2019 First digit First digit |Frequency 2 Aruba ABW 106,314 1 1=COUNTIF($D$2:50$263,F2) 3 Afghanistan AFG 38,041,754 3 2 COUNTIF(range, criteria) 4 Angola AGO 31,825,295 3 5 Albania ALB 2,854,191 2 6 Andorra AND 77,142 7 7 Arab World ARB 427,870,270 4 8 United Arab Emirates ARE 9,770,529 9 9 Argentina ARG 44,938,712 10 Armenia ARM 2,957,731 2 11 American Samoa ASM 55.312 5D2 X v fx =LEFT(C2,1) A B C D E 1 Country Name Country Code | Year 2019 First digit 2 Aruba ABW 106,314 =LEFT(C2,1) 3 Afghanistan AFG 38,041,754 4 Angola AGO 31,825,295 5 Albania ALB 2,854,191 Press enter to execute the function. You can now repeat the process by utilizing the fill handle feature of Excel.H2 1 X vf =G2/$G$11 A B C D E F G H Country Name Country Code Year 2019 First digit First digit | Frequency | Percent Frequency 2 Aruba ABW 106,314 1 79 =G2/SG$11 3 Afghanistan AFG 38,041,754 4 Angola AGO 31,825,295 3 5 Albania ALB 2,854,191 6 Andorra AND 77,142 7 7 Arab World ARB 427,870,270 4 8 United Arab Emirates ARE 9,770,529 9 9 Argentina ARG 44,938, 712 4 10 Armenia ARM 2,957,731 2 11 American Samoa ASM 55,312 5 TOTAL 267 12 Antigua and Barbuda ATG 97.118 9