Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
Not all data is shown butplease provide thorough steps on how to solve each part in excel B. Recall in Ch. 2, problem 2, you
Not all data is shown butplease provide thorough steps on how to solve each part in excel B. Recall in Ch. 2, problem 2, you sorted and thered the coumtries in GOPlat dota. This time, do the following. a) Bulls a PivocTable to show the number of cosmtries in each continent and the avwage CoP of cosntries in each continent fule Continent, as the row label? b) Format the average GaP with one decimal di fit and comma for 1000 sepwator, e 8, 123,456.7. c) Sort the conbinents in the order of highest average GDP to the lowest average GDP. (Hint: Cick any value in rient-click.] d) Which continent has the Highest average GDe? Which continent has the loweg average GDP? B. Recall in Ch. 2, problem 2, you sorted and thered the coumtries in GOPlat dota. This time, do the following. a) Bulls a PivocTable to show the number of cosmtries in each continent and the avwage CoP of cosntries in each continent fule Continent, as the row label? b) Format the average GaP with one decimal di fit and comma for 1000 sepwator, e 8, 123,456.7. c) Sort the conbinents in the order of highest average GDP to the lowest average GDP. (Hint: Cick any value in rient-click.] d) Which continent has the Highest average GDe? Which continent has the loweg average GDP? B. Recall in Ch. 2, problem 2, you sorted and filtered the countries in GDPlist data. This time, do the following. a) Build a PivotTable to show the number of countries in each continent and the average GDP of countries in each continent (use Continent as the row label). b) Format the average GDP with one decimal digit and comma for 1000 separator, e.g., 123,456.7. c) Sort the continents in the order of highest average GDP to the lowest average GDP. (Hint: Click any value in the Average of GDP column, right-click then click Sort > Sort Largest to Smallest. On Mac, Ctrl-click instead of right-click.) d) Which continent has the highest average GDP? Which continent has the lowest average GDP? B. Recall in Ch. 2, problem 2, you sorted and thered the coumtries in GOPlat dota. This time, do the following. a) Bulls a PivocTable to show the number of cosmtries in each continent and the avwage CoP of cosntries in each continent fule Continent, as the row label? b) Format the average GaP with one decimal di fit and comma for 1000 sepwator, e 8, 123,456.7. c) Sort the conbinents in the order of highest average GDP to the lowest average GDP. (Hint: Cick any value in rient-click.] d) Which continent has the Highest average GDe? Which continent has the loweg average GDP? B. Recall in Ch. 2, problem 2, you sorted and thered the coumtries in GOPlat dota. This time, do the following. a) Bulls a PivocTable to show the number of cosmtries in each continent and the avwage CoP of cosntries in each continent fule Continent, as the row label? b) Format the average GaP with one decimal di fit and comma for 1000 sepwator, e 8, 123,456.7. c) Sort the conbinents in the order of highest average GDP to the lowest average GDP. (Hint: Cick any value in rient-click.] d) Which continent has the Highest average GDe? Which continent has the loweg average GDP? B. Recall in Ch. 2, problem 2, you sorted and filtered the countries in GDPlist data. This time, do the following. a) Build a PivotTable to show the number of countries in each continent and the average GDP of countries in each continent (use Continent as the row label). b) Format the average GDP with one decimal digit and comma for 1000 separator, e.g., 123,456.7. c) Sort the continents in the order of highest average GDP to the lowest average GDP. (Hint: Click any value in the Average of GDP column, right-click then click Sort > Sort Largest to Smallest. On Mac, Ctrl-click instead of right-click.) d) Which continent has the highest average GDP? Which continent has the lowest average GDP
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started