Using datasets 1 to 4 in Exam_Datafile.xls and EXCEL, answer the questions (a) - (d) below (using no more than 100 words for each question).

Link to download the file https://www.mediafire.com/file/xut33cihpcpbwsl/STA510+Exam_Datafile.xlsx/file

(a)Dataset 1 displays the electricity and heat production (in gigawatt hours, GWh) patterns of Australia and New Zealand. Using suitable graph(s) compare and comment on the shares of electricity and heat production sources in Australia and New Zealand. (2 marks)

[Type Answer Here]

(b)Dataset 2 presents the Australian exports and imports by 10 major trading partners (in A$ millions) for 2018. Using appropriate graph(s) comment on the volume of Australia's international trade with major trading partners. (2 marks)

[Type Answer Here]

(c)Dataset 3 presents the average petrol prices in Australia and for the six states and the Northern Territory from 2002 to 2019. Using appropriate graph(s), describe your observations about petrol prices trend in Australia and by State/ Territory. (2 marks)

[Type Answer Here]

(d)Dataset 4 presents data for the number of deaths due to road accidents categorised by road user groups and gender from 2016-2020. (2 marks)

Using appropriate graphs

i.analyse the data by all road user groups

ii.analyse the data by gender

[Type Answer Here]