Please follow steps below to download the dataset to complete your report.

• Click on the link https://www.abs.gov.au/statistics/industry/tourism-and-transport/survey-motor-vehicle-use-australia/12-months-ended-30-june-2020#data-download

• From the "Contents" of the above master excel file, choose the worksheet "Table 4 Motor vehicle use, by state/territory of registration by type of vehicle" to complete below task.

2: Write Your Report(10 marks)

Cut and paste all relevant computer output with your analysis. Be sure to include both computer output and your discussion of that output in every case. As you discuss each analysis, be sure to interpret what you are finding in the context of your data situation. Include the following.

Introduction: (2 Marks)

Give a reference for your data and describe all relevant variables. Include a copy of the dataset.

Analysis of One Quantitative Variable: (3 Marks)

For at least one of the quantitative variables, include summary statistics (mean, standard deviation, five number summary) and at least one appropriate graphical display. Are there any outliers? Is the distribution symmetric, skewed, or some other shape?

Analysis of One Categorical Variable: (3 Marks)

For at least one of the categorical variables, include a frequency table, a relative frequency table and at least one appropriate graphical display.

Conclusion: (2 Marks)

Briefly summarise the most interesting features of your data.

A B C D E F G H 1 92080DO001_202006 Survey of Motor Vehicle Use, Australia, 12 months ended 30 June 2020 2 Released at 11:30 am (Canberra time) Mon 21 Dec 2020 3 Table 4 Motor vehicle use, by state/territory of registration by type of vehicle 4 total kilometers traveled ( million ) by buses and motor cycles in the states of Australia 5 motor cycles buses 6 NSW 492 591 Chart Title 7 Victoria 269 490 8 Queensland 562 480 Australian Capital Territory 9 South Australia 66 119 Northern Territory 10 Western Australia 230 309 Tasmmania 11 Tasmmania 20 43 Western Australia 12 Northern Territory 19 52 South Australia 13 Australian Capital Territory 25 42 Queensland Total 1,683 2, 126 Victoria 15 NSW 16 100 200 300 400 500 600 700 17 buses . motor cycles 18 19