Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please show me the formula used in Excel. I just need to see the formula that used in here. 19 27 35 33 Country Continent

image text in transcribed

image text in transcribed

Please show me the formula used in Excel. I just need to see the formula that used in here.

19 27 35 33 Country Continent Zambia Africa Yemen Asia Vietnam Asia Venezuela South America Uzbekistan Asia Uruguay South America United Kingdom Europe United Arab Emirates Asia Ukraine Europe Uganda Africa Turkey Asia Togo Africa Thailand Asia Tanzania Africa Taiwan Asia Syria Asia Switzerland Europe Sweden Europe Sudan Africa Sri Lanka Asia Spain Europe South Korea Asia South Africa Africa Slovenia Europe Slovakia Europe Singapore Asia Serbia Europe Senegal Africa Saudi Arabia Asia Saint Lucia Central America Rwanda Africa Russia Asia Romania Europe Qatar Asia Portugal Europe Poland Europe Philippines Asia Peru South America Paraguay South America Panama Central America Trade Balance World (millions) Share $48.98 0.23% $154.11 0.38% -$25,742.12 1.26% $4,619.19 0.42% $209.93 0.42% $553.97 0.05% $3,414.24 0.13% $9,021.64 0.58% $596.41 0.58% $3.72 0.87% $185.21 1.07% $376.95 0.10% -$12,976.82 0.91% $211.64 0.77% $10,335.78 0.31% $38.95 0.24% $11,992.77 0.11% -$4,982.34 0.13% $42.83 0.54% $1,519.96 0.27% -$3,828.74 0.61% $11,731.70 0.67% $1,693.59 0.75% $351.71 0.03% -$1,922.17 0.07% $3,788.58 0.08% -$100.75 0.11% $61.27 0.21% -$5,368.14 0.44% $366.31 0.00% -$17.88 0.16% $9,223.02) 1.89% $1,037.16 0.26% $1,384.42 0.04% $1,890.55 0.13% $1,516.10 0.50% -$2,335.59 1.40% $1,456.74 0.43% $1,593.80 0.09% $4,124.58 0.05% Urban Median Land Area Percentage Population Population Age (sq. km) of Tariff 17,609,178 39% 17 743,390 28,915,284 33% 527,970 96,491,146 34% 30 310,070 32,381,221 88% 882,050 32,364,996 34% 26 425,400 3,469,551 95% 175,020 9,541,615 90% 83,600 44,009,214 70% 40 579,320 44,270,563 16% 16 199,810 66,573,504 81% 40 241,930 81,916,871 71% 30 769,630 7,990,926 39% 19 54,390 69,183,173 52% 38 510,890 59,091,392 31% 17 885,800 23,694,089 77% 40 35,410 18,284,407 75% 20 183,630 8,544,034 73% 42 39,516 9,982,709 85% 41 410,340 41,511,526 34% 19 1,765,048 20,950,041 19% 32 62,710 46,397,452 82% 43 498,800 51,164,435 81% 97,230 57,398,421 62% 26 1,213,090 2,081,260 50% 43 20,140 5,449,816 54% 48,088 5,791,901 75% 40 700 8,762,027 59% 40 87,460 16,294,270 43% 18 192,530 33,554,343 77% 30 2,149,690 179,667 19% 33 610 12,501,156 32% 19 24,670 143,964,709 73% 39 16,376,870 19,580,634 60% 41 230,170 2,694,849 91% 31 11,610 10,291,196 67% 44 91,590 38,104,832 61% 40 306,230 106,512,074 44% 24 298,170 32,551,815 78% 27 1,280,000 6,896,908 63% 25 397,300 4,162,618 28 74,340 41 39 66% 19) In Tariff column, use Logical function to determine the percentage of Tariff for all countries. See below table for criteria. (5 marks) Trade Balance (millions) Percentage of Tariff Greater than 153 None Between -1500 to 153 2.5% Between - 10000 to -1501 5.0% Between -80000 to -10001 10% Less than -80001 25% 19 27 35 33 Country Continent Zambia Africa Yemen Asia Vietnam Asia Venezuela South America Uzbekistan Asia Uruguay South America United Kingdom Europe United Arab Emirates Asia Ukraine Europe Uganda Africa Turkey Asia Togo Africa Thailand Asia Tanzania Africa Taiwan Asia Syria Asia Switzerland Europe Sweden Europe Sudan Africa Sri Lanka Asia Spain Europe South Korea Asia South Africa Africa Slovenia Europe Slovakia Europe Singapore Asia Serbia Europe Senegal Africa Saudi Arabia Asia Saint Lucia Central America Rwanda Africa Russia Asia Romania Europe Qatar Asia Portugal Europe Poland Europe Philippines Asia Peru South America Paraguay South America Panama Central America Trade Balance World (millions) Share $48.98 0.23% $154.11 0.38% -$25,742.12 1.26% $4,619.19 0.42% $209.93 0.42% $553.97 0.05% $3,414.24 0.13% $9,021.64 0.58% $596.41 0.58% $3.72 0.87% $185.21 1.07% $376.95 0.10% -$12,976.82 0.91% $211.64 0.77% $10,335.78 0.31% $38.95 0.24% $11,992.77 0.11% -$4,982.34 0.13% $42.83 0.54% $1,519.96 0.27% -$3,828.74 0.61% $11,731.70 0.67% $1,693.59 0.75% $351.71 0.03% -$1,922.17 0.07% $3,788.58 0.08% -$100.75 0.11% $61.27 0.21% -$5,368.14 0.44% $366.31 0.00% -$17.88 0.16% $9,223.02) 1.89% $1,037.16 0.26% $1,384.42 0.04% $1,890.55 0.13% $1,516.10 0.50% -$2,335.59 1.40% $1,456.74 0.43% $1,593.80 0.09% $4,124.58 0.05% Urban Median Land Area Percentage Population Population Age (sq. km) of Tariff 17,609,178 39% 17 743,390 28,915,284 33% 527,970 96,491,146 34% 30 310,070 32,381,221 88% 882,050 32,364,996 34% 26 425,400 3,469,551 95% 175,020 9,541,615 90% 83,600 44,009,214 70% 40 579,320 44,270,563 16% 16 199,810 66,573,504 81% 40 241,930 81,916,871 71% 30 769,630 7,990,926 39% 19 54,390 69,183,173 52% 38 510,890 59,091,392 31% 17 885,800 23,694,089 77% 40 35,410 18,284,407 75% 20 183,630 8,544,034 73% 42 39,516 9,982,709 85% 41 410,340 41,511,526 34% 19 1,765,048 20,950,041 19% 32 62,710 46,397,452 82% 43 498,800 51,164,435 81% 97,230 57,398,421 62% 26 1,213,090 2,081,260 50% 43 20,140 5,449,816 54% 48,088 5,791,901 75% 40 700 8,762,027 59% 40 87,460 16,294,270 43% 18 192,530 33,554,343 77% 30 2,149,690 179,667 19% 33 610 12,501,156 32% 19 24,670 143,964,709 73% 39 16,376,870 19,580,634 60% 41 230,170 2,694,849 91% 31 11,610 10,291,196 67% 44 91,590 38,104,832 61% 40 306,230 106,512,074 44% 24 298,170 32,551,815 78% 27 1,280,000 6,896,908 63% 25 397,300 4,162,618 28 74,340 41 39 66% 19) In Tariff column, use Logical function to determine the percentage of Tariff for all countries. See below table for criteria. (5 marks) Trade Balance (millions) Percentage of Tariff Greater than 153 None Between -1500 to 153 2.5% Between - 10000 to -1501 5.0% Between -80000 to -10001 10% Less than -80001 25%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing Cases An Interactive Learning Approach

Authors: Mark S. Beasley, Frank A. Buckless, Steven M. Glover, Douglas F. Prawitt

5th edition

132567237, 978-0132998345, 132998343, 978-0132567237

More Books

Students also viewed these Accounting questions