3. Go to federalreserve.gov and choose a currency that has historical data under "Country Data."

• Use Excel to chart the direct spot from 1/1/20 to the present (label axes, add a title). Copy and paste the graph into your Word doc.
• Did your currency appreciate or depreciate against the USD?
• Does your currency seem to have a lot of volatility?
• Any other observations?

Data below is for South African Rand. I need assistance with questions and creating a chart.

1-Jan-20	ND
2-Jan-20	14.1220
3-Jan-20	14.2430
6-Jan-20	14.2060
7-Jan-20	14.3010
8-Jan-20	14.1560
9-Jan-20	14.2000
10-Jan-20	14.2550
13-Jan-20	14.4220
14-Jan-20	14.3970
15-Jan-20	14.3670
16-Jan-20	14.3770
17-Jan-20	14.4670
20-Jan-20	ND
21-Jan-20	14.4680
22-Jan-20	14.3380
23-Jan-20	14.4180
24-Jan-20	14.4250
27-Jan-20	14.6080
28-Jan-20	14.5660
29-Jan-20	14.6250
30-Jan-20	14.7879
31-Jan-20	14.9360
3-Feb-20	14.9100
4-Feb-20	14.7470
5-Feb-20	14.7980
6-Feb-20	14.9010
7-Feb-20	15.0620
10-Feb-20	15.0190
11-Feb-20	14.8510
12-Feb-20	14.8180
13-Feb-20	14.8870
14-Feb-20	14.9000
17-Feb-20	ND
18-Feb-20	14.9750
19-Feb-20	14.9800
20-Feb-20	15.1180
21-Feb-20	14.9660
24-Feb-20	15.1280
25-Feb-20	15.2000
26-Feb-20	15.1760
27-Feb-20	15.3920
28-Feb-20	15.6360
2-Mar-20	15.5370
3-Mar-20	15.2930
4-Mar-20	15.3480
5-Mar-20	15.5780
6-Mar-20	15.6350
9-Mar-20	15.9330
10-Mar-20	16.1030
11-Mar-20	16.1516
12-Mar-20	16.5310
13-Mar-20	16.3240
16-Mar-20	16.5330
17-Mar-20	16.5850
18-Mar-20	17.0960
19-Mar-20	17.3721
20-Mar-20	17.5000
23-Mar-20	17.7550
24-Mar-20	17.6550
25-Mar-20	17.4000
26-Mar-20	17.2768
27-Mar-20	17.5550
30-Mar-20	17.9450
31-Mar-20	17.7682
1-Apr-20	18.1450
2-Apr-20	18.5312
3-Apr-20	18.9850
6-Apr-20	18.6740
7-Apr-20	18.2220
8-Apr-20	18.2108
9-Apr-20	17.9030
10-Apr-20	18.0158
13-Apr-20	18.1400
14-Apr-20	18.3570
15-Apr-20	18.7320
16-Apr-20	18.6680
17-Apr-20	18.8500
20-Apr-20	18.8060
21-Apr-20	18.9650
22-Apr-20	19.0070
23-Apr-20	19.0400
24-Apr-20	18.9720
27-Apr-20	18.8510
28-Apr-20	18.6580
29-Apr-20	18.2510
30-Apr-20	18.4480
1-May-20	18.8500
4-May-20	18.7040
5-May-20	18.3880
6-May-20	18.7700
7-May-20	18.5210
8-May-20	18.3600
11-May-20	18.3890
12-May-20	18.2780
13-May-20	18.5210
14-May-20	18.5640
15-May-20	18.5400
18-May-20	18.3830
19-May-20	18.2650
20-May-20	17.9599
21-May-20	17.6530
22-May-20	17.7010
25-May-20	ND
26-May-20	17.4040
27-May-20	17.4180
28-May-20	17.4130
29-May-20	17.5960
1-Jun-20	17.4000
2-Jun-20	17.1950
3-Jun-20	16.8900
4-Jun-20	16.9310
5-Jun-20	16.8360
8-Jun-20	16.7900
9-Jun-20	16.6810
10-Jun-20	16.5560
11-Jun-20	17.0834
12-Jun-20	17.0110
15-Jun-20	17.2650
16-Jun-20	17.1525
17-Jun-20	17.2200
18-Jun-20	17.4850
19-Jun-20	17.3375
22-Jun-20	17.3350
23-Jun-20	17.2275
24-Jun-20	17.4050
25-Jun-20	17.2375
26-Jun-20	17.2625
29-Jun-20	17.3000
30-Jun-20	17.3525
1-Jul-20	17.0800
2-Jul-20	16.9675
3-Jul-20	ND
6-Jul-20	16.9750
7-Jul-20	17.0775
8-Jul-20	16.9750
9-Jul-20	16.9125
10-Jul-20	16.7475
13-Jul-20	16.6900
14-Jul-20	16.7500
15-Jul-20	16.5850
16-Jul-20	16.6400
17-Jul-20	16.6575
20-Jul-20	16.6700
21-Jul-20	16.4600
22-Jul-20	16.4550
23-Jul-20	16.5475
24-Jul-20	16.6925
27-Jul-20	16.4175
28-Jul-20	16.5425
29-Jul-20	16.5000
30-Jul-20	16.9125
31-Jul-20	17.0050
3-Aug-20	17.1925
4-Aug-20	17.3775
5-Aug-20	17.3175
6-Aug-20	17.4575
7-Aug-20	17.6325
10-Aug-20	17.6850
11-Aug-20	17.5350
12-Aug-20	17.3975
13-Aug-20	17.4175
14-Aug-20	17.3475
17-Aug-20	17.4600
18-Aug-20	17.3525
19-Aug-20	17.1800
20-Aug-20	17.2750
21-Aug-20	17.1275
24-Aug-20	16.9300
25-Aug-20	16.8625
26-Aug-20	16.9675
27-Aug-20	17.0025
28-Aug-20	ND
31-Aug-20	16.9150
1-Sep-20	16.6300
2-Sep-20	16.8325
3-Sep-20	16.7775
4-Sep-20	16.6025