Reference no: EM133668464
Assessment: Case study
Case study: Australian Labour Force 2020 -2022
You have just accepted a job in Workforce Australia, the Australian Government Department of employment and workforce, as a data analyst. Between 2020 and 2022 COVID - 19 Pandemic significantly affected the structure and composition of Australian labour force. Write a report on the current situation of Australian labour force and provide some insights which can assist them in setting their decisions for the future. For this report, the Work Force Australia require for the below information:
Requirement 1:
The total unemployment and participation rates for each state and territory in Australia from 2020 to 2022. Break down the total unemployment and participation rates information based on age groups and gender groups for each state and territory in Australia.
Requirement 2:
The total full time and part time employment (seasonall: adjusted) for each state and territory in Australia from 2020 ti 2022.
Break down the total full time and part time employment (seasonally adjusted) for hours worked in all jobs and underemployment for each state and territory in Australia.
Asia Pacific International College Pty Ltd. Trading as Asia Pacific International College
As statistical analysts, you require collecting, organising, analysing, and presenting data relevant to the above requirements. Your analysis would support the Work Force Australia to make strategic decisions in management of Australian Labour force.
Task 1: provide a brief description of Australian labour force, and outline the importance of analysis of data on Australian labour force.
Task 2: Prepare tables using a spreadsheet to show the data for each requirement in different sheets in the excel file (for both parts). Ensure that the data in each column has been labelled and presented clearly.
Task 3: In your report, choose suitable graphs to illustrate the presented data for both requirement 1 (a and b) and requirement 2 (a and b). Explain why you made this choice of graphic display.
Task 4: Use your graph from task 3 to discuss the trends of Australian labour force over (in terms of total unemployment and participation rates) for 2020, 2021 and 2022 for each state and territory in Australia.
Task 5: Calculate the mean and the standard deviation of the presented data for requirement 2 part a for 2021 and 2022.