Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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 data provided 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.

image text in transcribedimage text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Probability Models

Authors: Sheldon M Ross

12th Edition

0128143460, 9780128143469

More Books

Students also viewed these Mathematics questions