Assign latest poverty to a three-column table with one row for each country that appears in...

 

Transcribed Image Text:

Assign latest poverty to a three-column table with one row for each country that appears in the poverty table. The first column should contain the 3-letter code for the country. The second column should contain the most recent year for which an extreme poverty rate is available for the country. The third column should contain the poverty rate in that year. Do not change the last line, so that the labels of your table are set correctly. Question 2: Using both latest poverty and population, make a four-column table called recent_poverty_total with one row for each country in latest poverty. The four columns should have the following labels and contents: Question 3. Assign the name poverty_percent to the known percentage of the world's 2010 population that were living in extreme poverty. Assume that the poverty_total numbers in the recent_poverty_total table describe all people in 2010 living in extreme poverty. You should find a number that is above the 2018 global estimate of 8%, since many country-specific poverty rates are older than 2018. Hint: The sum of the population_total column in the recent poverty_total table is not the world population, because only a subset of the world's countries are included in the recent poverty_total table (only some countries have known poverty rates). Use the population table to compute the world's 2010 total population.. Hint: think about how group works: it does a sequential search of the table (from top to bottom) and collects values in the array in the order in which they appear, and then applies a function to that array. The first function may be helpful, but you are not required to use it.Using both latest poverty and population, make a four-column table called recent_poverty_total with one row for each country in latest poverty. The four columns should have the following labels and contents: 1. geo contains the 3-letter country code, 2. poverty_percent contains the most recent poverty percent, 3. population total contains the population of the country in 2010, 4. poverty_total contains the number of people in poverty rounded to the nearest integer, based on the 2010 population and most recent poverty rate. Assign latest poverty to a three-column table with one row for each country that appears in the poverty table. The first column should contain the 3-letter code for the country. The second column should contain the most recent year for which an extreme poverty rate is available for the country. The third column should contain the poverty rate in that year. Do not change the last line, so that the labels of your table are set correctly. Question 2: Using both latest poverty and population, make a four-column table called recent_poverty_total with one row for each country in latest poverty. The four columns should have the following labels and contents: Question 3. Assign the name poverty_percent to the known percentage of the world's 2010 population that were living in extreme poverty. Assume that the poverty_total numbers in the recent_poverty_total table describe all people in 2010 living in extreme poverty. You should find a number that is above the 2018 global estimate of 8%, since many country-specific poverty rates are older than 2018. Hint: The sum of the population_total column in the recent poverty_total table is not the world population, because only a subset of the world's countries are included in the recent poverty_total table (only some countries have known poverty rates). Use the population table to compute the world's 2010 total population.. Hint: think about how group works: it does a sequential search of the table (from top to bottom) and collects values in the array in the order in which they appear, and then applies a function to that array. The first function may be helpful, but you are not required to use it.Using both latest poverty and population, make a four-column table called recent_poverty_total with one row for each country in latest poverty. The four columns should have the following labels and contents: 1. geo contains the 3-letter country code, 2. poverty_percent contains the most recent poverty percent, 3. population total contains the population of the country in 2010, 4. poverty_total contains the number of people in poverty rounded to the nearest integer, based on the 2010 population and most recent poverty rate.