The data required for this task can be found inStatistics File 1.

(2 marks) 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.

(2 marks) 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.

Task 2. Evolution of Australia's geographical pattern of trade.

The data required for this task can be found inStatistics File 1.

Top export partners (goods).

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 300 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 (in 2019). Draw the graph including all years between 1989 and 2019. Discuss your findings

Total exports of Goods and Services 450,000 400,000 350,000 300,000 250,000 200,000 150,000 100,000 50,000 0 1989 1991 1993 1995 1997 1999 2001 2003 2005 2007 2009 2011 2013 2015 2017 2019 Total exports of goods Total exports of servicesTotal Imports of Goods and Services 350,000 300,000 250,000 200,000 150,000 100,000 50,000 0 1989 1991 1993 1995 1997 1999 2001 2003 2005 2007 2009 201 1 2013 2015 2017 2019 Total Imports of goods Total Imports of services