Question

This sheet contains monthly exchange rate.
	Value of each currency is quoted in USD

DATE	CAD1	JPY1	MXN1	THB1
2010-01-01	1.0438	0.0110	0.0781	0.0303
2010-02-01	1.0572	0.0111	0.0773	0.0302
2010-03-01	1.0229	0.0110	0.0796	0.0308
2010-04-01	1.0052	0.0107	0.0817	0.0310
2010-05-01	1.0403	0.0109	0.0786	0.0309

QUESTION:

1. Which currency has the highest average percentage change (in absolute term)
	For each currency, you calculate percentage change for each month
	Then get the average percentage change
	Use absolute value of the average above.
	This absolute average shows you how exchange rate changes regradless of direction (up/down)
2. Which currency has the highest standard deviation of percentage change (not in absolute term)

Answer 1

Solution:

1. Currency THB1 has highest average return of 0.50%

2. Currency MXN1 has highest standard deviation of 2.79%