Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Refer to the data stored in ExportImport worksheet in the .xls data file attached. (located below) The data shows Australias exports and imports of services

Refer to the data stored in ExportImport worksheet in the .xls data file attached. (located below) The data shows Australias exports and imports of services by selected regions in 2017 and 2018.

  1. Use Excel to draw an appropriate graphical technique to display the percentage value of Australias exports of services (in %) in 2017, broken down by region of export destination. Display your chart output. Provide comments on the information you observe from the chart output.
  2. Use Excel to draw an appropriate graphical technique to compare the value of Australias imports of services (in $m) in 2017 and 2018, broken down by region of import origin. Display your chart output. Provide comments on the information you observe from the chart output

image text in transcribed

A E 1 Australia's Exports and Imports of Services by Selected Regions 2 Exports ($m) Imports ($m) 3 Country 2017 2018 2017 2018 4 Africa 1,255 1,308 1,398 1,618 5 Americas 12,653 14,139 19,831 21,355 6 Asia 48,164 53,358 33,604 37,677 7 Europe 13,374 14,261 23,661 25,714 8 Oceania and Antartica 6,075 6,453 8,198 9,135 9 Other 3,457 3,266 2,581 2,284 10 11 Source: Australian Government: Department of Foreign Affairs and Trade 12 Composition of Trade Australia 2018 13

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

Step: 3

blur-text-image

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

Global Business Today

Authors: Charles Hill

7th Edition

0078137217, 9780078137211

More Books

Students also viewed these Finance questions

Question

1. What will happen in the future

Answered: 1 week ago

Question

3. Avoid making mistakes when reaching our goals

Answered: 1 week ago