Analysis of Australia's Goods and Services Trade Evolution Assignment

Assignment Task

Task

1. Evolution of Australia's goods and services trade

a.  Exports of goods and services. Use Excel to produce a line graph including Australia's total exports of goods, and Australia's total exports of services between 1989 and 2019. Discuss your findings in no more than words.

b. Imports of goods and services. Use Excel to produce a line graph including Australia's total imports of goods, and Australia's total imports of services between 1989 and 2019. Discuss your findings in no more than words.

c.  Balance of Trade. Calculate Australia's trade balance for goods, services and for total trade between 1989 and 2019. Show your results on a table. Discuss your findings in no more than words.

2. Evolution of Australia's geographical pattern of trade

i. Generate a table where you list Australia's top 20 export partners in 1989, 2005 and 2022. Include the value of Australia's exports of goods to each of the top 20 trade partners in your table. Discuss your findings in no more than words by highlighting the main differences observed over time.

ii. Use Excel to generate a line graph including Australia's goods export value to each of Australia's top 10 export partners between 1989 and 2019 (including all years in between). Discuss your findings in no more than words.

This Statistics Assignment Help has been solved by our Statistics Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.