Bloomberg Assignment #1 Please type all responses in a Word document. You need to attach Excel worksheets for Part #1. Remember to type your name within the document. 1. Find the month-end exchange rates between MXP and US$ and fill in the blanks i

   

Bloomberg Assignment  #1

Please type all responses in a Word document. You need to attach Excel worksheets for Part #1. Remember to type your name within the document. 

1. Find the month-end exchange rates between MXP and US$ and fill in the blanks in the following table. 

   

a. For the year 2013:

  

Date

US$ per MXP

 

Jan-13

 

Feb-13

 

Mar-13

 

Apr-13

 

May-13

 

Jun-13

 

Jul-13

 

Aug-13

 

Sep-13

 

Oct-13

 

Nov-13

 

Dec-13

b. For the year 2016/17

  

Date

US$ per MXP

 

Jan-17

 

Feb-17

 

Mar-17

 

Apr-17

 

May-17

 

Jun-17

 

Jul-17

 

Aug-16

 

Sep-16

 

Oct-16

 

Nov-16

 

Dec-16

   

2． Then, compute the standard deviation of the percent changes for each of the two periods. Which period is more volatile? What political, economic or financial factors made one period more volatile than the other period?