Assignment 1 Itec-320-006
Author Email:
1. Write a formula using a VLOOKUP or XLOOKUP function that retrieves the
2018 birth rate of the country in cell A4.
=VLOOKUP(A4,tabCountryData,9,FALSE)
2. Write an AVERAGEIF function that calculates the average percentage of
people ages 15-64 in a country ("2019Mid") for only those countries whose
2019 population in millions (“2019pop”) is greater than or equal to the number
in cell A6.
=AVERAGEIF(tabCountryData[2019pop],">="&A6,tabCountryData[2019Mid])
3. After you have finished the previous question, try entering a few different
values into cell A6. How does the result change? What does this tell you
about the relationship between a country’s population and the percentage of
people ages 15-64 in the country?
When I change the population from 2 million to 3~12 million, the average percentage of
2019 mid decrease. It increase when I change the population to the number bigger than
13. The lowest and highest population tend to have a bigger percentage of people ages
15-64 in the country.
4. Write a formula using COUNTIF to determine how many entries in the
"2019Mid" column are the text in cell A9.
=COUNTIF(tabCountryData[2019Mid],A9)
Author Email:
1. Write a formula using a VLOOKUP or XLOOKUP function that retrieves the
2018 birth rate of the country in cell A4.
=VLOOKUP(A4,tabCountryData,9,FALSE)
2. Write an AVERAGEIF function that calculates the average percentage of
people ages 15-64 in a country ("2019Mid") for only those countries whose
2019 population in millions (“2019pop”) is greater than or equal to the number
in cell A6.
=AVERAGEIF(tabCountryData[2019pop],">="&A6,tabCountryData[2019Mid])
3. After you have finished the previous question, try entering a few different
values into cell A6. How does the result change? What does this tell you
about the relationship between a country’s population and the percentage of
people ages 15-64 in the country?
When I change the population from 2 million to 3~12 million, the average percentage of
2019 mid decrease. It increase when I change the population to the number bigger than
13. The lowest and highest population tend to have a bigger percentage of people ages
15-64 in the country.
4. Write a formula using COUNTIF to determine how many entries in the
"2019Mid" column are the text in cell A9.
=COUNTIF(tabCountryData[2019Mid],A9)
