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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!