Using the employment data provided, generate ONE Excel chart showing Australia's monthly unemployment rate over 2020. In your chart show the overall unemployment as well
Using the employment data provided, generateONEExcel chart showing Australia's monthly unemployment rate over 2020. In your chart show the overall unemployment as well as the unemployment rate for both males and females. Make sure your chart has clearly labelled axes and include a chart title.
Using the employment data contained, briefly analyse gender differences (and similarities) associated with the employment in 2020. In your answer discuss implications associated with impact of COVID-19 and relevant government assistance associated with Job Keeper.
Civilian population Civilian population Civilian population Labour force total ; > Labour force total ; > Participation rate ; Participation rate ; > Participation rate ; > Not in the labour force Not in the labour force Not in the labour force aged 15 years and aged 15 years and aged 15 years and Males : Females ; Persons ; Males ; Females ; (NILF) ; Persons ; (NILF) ; > Males ; (NILF) ; > Females ; over ; Persons ; over ; > Males ; over ; > Females ; Unit 000 000 Percent Percent Percent 000 000 000 000 000 000 Series Type Seasonally Adjusted Seasonally Adjusted Seasonally Adjusted Seasonally Adjusted Seasonally Adjusted Original Original Origina Origina Original Original Data Type STOCK STOCK PERCENT PERCENT PERCENT STOCK STOCK STOCK STOCK STOCK STOCK Frequency Month Month Month Month Month Month Month Month Month Month Month Collection Month Series Start Feb-1978 Feb-1978 Feb-1978 Feb-1978 Feb-1978 Feb-1978 Feb-1978 Feb-1978 Feb-1978 Feb-1978 Feb-1978 co Series End Jun-2021 Jun-2021 Jun-2021 Jun-2021 Jun-2021 Jun-2021 Jun-2021 Jun-2021 Jun-2021 Jun-2021 Jun-2021 9 No. Obs 521 521 521 521 521 521 521 521 521 521 521 10 Series ID A84423033X A84423061J A84423051C A84423037J A84423065T A84423090V A84423076X A84423104W A84423091W A84423077A A84423105X 11 Dec-2019 7207.9 6446.8 65.9 70.9 61.1 6966.2 2913.3 4052.9 20729.8 10171.9 10557.9 12 Jan-2020 7208.5 6501.5 66.0 70.8 61.5 7157.0 3009.6 4147.3 20763.3 10187.6 10575.7 13 Feb-2020 7216.6 6481.7 65.9 70.7 61.2 6982.9 2921.3 4061.5 20796.8 10203.3 10593.5 14 Mar-2020 7225.0 6493.4 65.9 70.7 61.2 7060.2 2960.6 4099.6 20830.3 10219.0 10611.3 15 Apr-2020 7035.6 6212.3 63.6 68.8 58.5 7576.0 3178.4 4397.6 20838.4 10222.9 10615.5 16 May-2020 6950.5 6103.9 62.6 68.0 57.5 7751.1 3267.2 4483.9 20846.4 10226.7 10619.7 17 Jun-2020 7073.4 6285.8 64.1 69.1 59.2 7496.5 3163.3 4333.3 20854.5 10230.6 10623.9 18 Jul-2020 7128.7 6355.2 64.7 69 7 59 8 7385.5 3105.7 4279.8 20852.4 10229.3 10623.1 19 Aug-2020 7149.3 6393.3 65.0 69.9 60 2 7365.0 3111.8 4253.2 20850.3 10227.9 10622.3 20 Sep-2020 7123.4 6384.6 64.8 69.7 60 1 7371.2 3108.6 4262.7 20848.1 10226.6 10621.5 21 Oct-2020 7230.2 6463.4 65.7 70.7 60 8 7207.8 3022.7 4185.1 20852.1 10228.2 10623.9 22 Nov-2020 7261.1 6512.0 66.0 71.0 61.3 7097.1 2982.3 4114.9 20856. 1 10229.8 10626.3 23 Dec-2020 7259.5 6516.8 66.0 71.0 61.3 6988.8 2924.6 4064.2 20860.1 10231.4 10628.7 24 Jan-2021 7276.9 6500.2 66.0 71.1 61 .1 7190.9 2992.1 4198.8 20862.1 10231.8 10630.3 25 Feb-2021 7252.8 6527.8 66.0 70.9 61.4 6960.2 2912.6 4047.7 20864.2 10232.3 10631.9 26 Mar-2021 7253.3 6575.2 66.3 70.9 61.8 6983.3 2944.2 4039.1 20866.2 10232.7 10633.5 27 Apr-2021 7242.5 6521.6 65.9 70.7 61.3 7092.1 2977.8 4114.3 20876.0 10236.8 10639.1 28 May-2021 7259.4 6566.9 66.2 70.9 61.7 7006.2 2964.9 4041.3 20885.7 10241.0 10644.7 29 Jun-2021 7271.8 6561.6 66.2 71.0 61.6 7059.8 2977.1 4082.6 20895.4 10245.1 10650.3 30
