Question
Can you please analyse statistically and do the graph in excel please Table 1: Additional estimates Mar-20 Apr-20 March to April change Australia - unemployed
Can you please analyse statistically and do the graph in excel please
Table 1: Additional estimates
Mar-20
Apr-20
March to April change
Australia - unemployed people718,800
823,300
+104,500
Australia - unemployed people plus employed people in Group 1727,600
1,232,800
+505,000
Australia - unemployed people plus employed people in Group 2746,500
1,544,700
+798,000
Canada - unemployed people (includes temporary layoffs)1,547,000
2,418,000
+871,000
United States - unemployed people (includes temporary layoffs)7,140,000
23,078,000
+15,938,000
Australia - unemployment rate5.2%
6.2%
+1.0 pts
Australia - unemployed people plus Group 1, as a percentage of the labour force5.3%
9.3%
+4.0 pts
Australia - unemployed people plus Group 2, as a percentage of the labour force5.4%
11.7%
+6.2 pts
Canada - unemployment rate7.8%
13.0%
+5.2 pts
United States - unemployment rate4.4%
14.7%
+10.3 pts
Australia - participation rate66.0%
63.5%
-2.4 pts
Canada - participation rate63.5%
59.8%
-3.7 pts
United States - participation rate62.7%
60.2%
-2.5 pts
Source: ABS, Statistics Canada , US Bureau of Labor Statistics.
Notes: 'Group 1' refers to employed people working zero hours who indicated they were 'stood down'. 'Group 2' refers to a further expanded group of employed people working zero hours who indicated they had 'no work, not enough work available or were stood down'. The US Bureau of Labor Statistics noted that some people on temporary layoff were not classified as such and the unemployment rate could have been almost 5 percentage points
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started