QAB105 Business Research Methods - Assignment 1

Assignment 1

Part 2 [12 Marks]
Using datasets in QAB105 Written Assignment 1 Datafile.xls and EXCEL, answer the questions (a) – (f) below (using no more than 100 words for each question).

1. 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. 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.
3. 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.
4. Dataset 4 presents data for the number of deaths due to road accidents categorised by road user groups and gender from 2016–2020.
   Using appropriate graphs
   i. analyse the data by all road user groups
   ii. analyse the data by gender
5. Dataset 5 presents data on the average number of cigarettes smoked and the number of days absent from work due to colds in year 2019. Present an appropriate plot to investigate the relationship between the average number of cigarettes smoked and the number of days absent from work. Comment on the relationship.
6. Using Dataset 5, prepare a numerical summary output for the variables; average number of cigarettes smoked and the number of days absent from work. Explain the key numerical descriptive measures.

Get Your Customize Task on any subject starting 10$/Page

Order Now Whatsapp Now