a. Analyse the number of confirmed cases and deaths by states.

b Analyse the number of deaths by states and age groups.

c Analyse the data by age groups and gender.

Update the dataprovided in COVID19AUS.xlsx to currently available data from the above source (https://www.covid19data.com.au/states-and-territories)and store in worksheet 2021.

d Analyse the number of confirmed cases and deaths by states.

e Analyse the number of deaths by states and age groups.

f Analyse the data by age groups and gender.

g Comment on any changes between 30 June 2020 and the currently available data.

Year Month Temp Anomaly ("C) Carbon Dioxide (ppm) 2 1958 3 0.0737 315.71 3 1958 0.1166 317.45 4 1958 5 0.1495 317.5 5 1958 6 -0.1119 317.1 6 1958 7 -0.0082 315.86 7 1958 8 -0.0684 314.93 1958 9 -0.2107 313.2 1958 10 -0.0803 312.66 10 1958 11 0.1794 313.33 11 1958 12 0.2421 314.67 12 1959 1 0.1911 315.62 13 1959 2 0.0206 316.38 14 1959 3 0.528 316.71 15 1959 0.2175 317.72 16 1959 -0.1001 318.29 17 1959 0.1925 318.15 18 1959 0.0786 316.54 19 1959 8 0.0048 314.8 20 1959 9 0.0912 313.84 21 1959 10 -0.2187 313.26 22 1959 11 -0.3423 314.8 23 1959 12 -0.1075 315.58 24 1960 -0.0172 316.43 25 1960 1 6337 316 97Number of COVID-19 cases and number of deaths, Australia, 30 June 2020 Number of COVID-19 deaths by age group, state/territory and gender, Australia, 30 June 2020 State COVID-19 cases Deaths State/Territory Gender New South Wales (NSW) 3,211 48 Age group NSW VIC OLD WA SA TAS ACT NT Australia Male Female Victoria (VIC) 2,195 20 40-49yrs 1 1 1 Queensland (QLD) 1,079 6 50-59yrs 1 2 1 Western Australia (WA) 594 9 60-69yrs 4 W 1 10 5 5 W H South Australia (SA) 436 4 70-79yrs 11 6 34 22 12 Tasmania (TAS) 225 13 80-89yrs 16 9 N 5 2 36 19 17 Australian Capital Territory (ACT) 111 3 90-99yrs 16 1 3 20 8 12 Norther Territory (NT) 30 0 Total 48 20 6 9 4 13 3 0 103 56 47 Australia 7881 103