Question

We had to collect data on % change of unemployment rate in the last quarter of 2019, and the first quarter of 2020 for three countries. I'm stuck at: Is there a time trend on the unemployment rate? Show them by building a graph using Excel.

I have the following data:

	Last Quarter 2019	First Quarter 2020	% Change
USA	3.50%	4.40%	20.45%
CANADA	5.60%	7.80%	39.29%
INDIA	7.60%	7.80%	8.30%

Answer 1

There appears to be an upward time trend to the unemployment rate in these three countries - USA, Canada, and India. As is also evident from the percentage change shown in column 4.