Need help and please list the formulas used.
Instructions 1. Calculate the daily change in exchange rate for the given time period 2. Calculate the mean/average change of the exchange for the given data 3. Calculate the volatility of each currency 4. Show the movement of the currency from 2018 to 2019 and explain the reason behind exchange rate movement (give the answer in excel file) 5. Calculate the cross exchnage rate between EUR/THB for 2019 Date EUR/BDT GBP/BDT THB/BDT 2-Jan-17 82.635 96.983 2.20424 3-Jan-17 82.686 97.251 2.208988 4-Jan-17 83.041 97.553 2.208843 5-Jan-17 84.013 98.365 2.21774 6-Jan-17 83.427 97.319 2.21774 9-Jan-17 83.614 96.175 2.2141 10-Jan-17 83.39 96.204 2.220041 11-Jan-17 83.893 96.811 2.235555 12-Jan-17 84.12 96.386 2.2432 13-Jan-17 84.412 96.582 2.236401 16-Jan-17 84.066 95.526 2.235837 17-Jan-17 84.878 98.346 2.24999 18-Jan-17 84.348 97.269 2.237529 19-Jan-17 84.464 97.754 2.241502 20-Jan-17 84.902 98.165 2.244898 23-Jan-17 85.56 99.632 2.257232 24-Jan-17 85.247 99.463 2.256096 25-Jan-17 85.312 100.287 2.25425 26-Jan-17 84.796 99.961 2.246313 27-Jan-17 85.009 99.755 2.256522 30-Jan-17 84.973 99.207 2.256522 31-Jan-17 85.968 100.148 2.269028 1-Feb-17 85.727 100.756 2.268743 2-Feb-17 85.724 99.823 2.27088 3-Feb-17 85.922 99.494 2.270738 6-Feb-17 85.656 99.357 2.278848 7-Feb-17 85.106 99.657 2.270453 8-Feb-17 85.507 100.22 2.27772 9-Feb-17 85.022 99.716 2.274158 10-Feb-17 84.91 99.676 2.274158 13-Feb-17 84.758 100.161 2.279288 14-Feb-17 84.52 99.638 2.277293 15-Feb-17 84.824 99.695 2.280428 16-Feb-17 85.628 100.185 2.294435 17-Feb-17 85.151 99.596 2.294435 20-Feb-17 85.126 99.944 2.285843 21-Feb-17 84.459 24 99.969 2.284418 22-Feb-17 84.538 99.714 2.282423 23-Feb-17 84.545 100.308 2.284997 24-Feb-17 84.393 99.609 2.292987 27-Feb-17 84.691 99.529 2.295857 28-Feb-17 84.293 98.666 2.279277 1-Mar-17 84.427 98.415 2.289287 2-Mar-17 84.141 98.233 2.282423 3-Mar-17 85.117 98.514 2.283563 6-Mar-17 84.705 97.953 2.281425 7-Mar-17 84.701 7 97.796 8-Mar-17 84.607 97.683 2.2715 9-Mar-17 84.828 97.575 2.26966 10-Mar-17 85.616 97.646 2.270368 13-Mar-17 85.521 98.088 2.271783 14-Mar-17 85.145 97.591 2.272349 15-Mar-17 86.101 98.594 2.285985 16-Mar-17 85.746 98.442 2.277847 17-Mar-17 86.189 99.48 2.303606 2.28456 Instructions 1. Calculate the daily change in exchange rate for the given time period 2. Calculate the mean/average change of the exchange for the given data 3. Calculate the volatility of each currency 4. Show the movement of the currency from 2018 to 2019 and explain the reason behind exchange rate movement (give the answer in excel file) 5. Calculate the cross exchnage rate between EUR/THB for 2019 Date EUR/BDT GBP/BDT THB/BDT 2-Jan-17 82.635 96.983 2.20424 3-Jan-17 82.686 97.251 2.208988 4-Jan-17 83.041 97.553 2.208843 5-Jan-17 84.013 98.365 2.21774 6-Jan-17 83.427 97.319 2.21774 9-Jan-17 83.614 96.175 2.2141 10-Jan-17 83.39 96.204 2.220041 11-Jan-17 83.893 96.811 2.235555 12-Jan-17 84.12 96.386 2.2432 13-Jan-17 84.412 96.582 2.236401 16-Jan-17 84.066 95.526 2.235837 17-Jan-17 84.878 98.346 2.24999 18-Jan-17 84.348 97.269 2.237529 19-Jan-17 84.464 97.754 2.241502 20-Jan-17 84.902 98.165 2.244898 23-Jan-17 85.56 99.632 2.257232 24-Jan-17 85.247 99.463 2.256096 25-Jan-17 85.312 100.287 2.25425 26-Jan-17 84.796 99.961 2.246313 27-Jan-17 85.009 99.755 2.256522 30-Jan-17 84.973 99.207 2.256522 31-Jan-17 85.968 100.148 2.269028 1-Feb-17 85.727 100.756 2.268743 2-Feb-17 85.724 99.823 2.27088 3-Feb-17 85.922 99.494 2.270738 6-Feb-17 85.656 99.357 2.278848 7-Feb-17 85.106 99.657 2.270453 8-Feb-17 85.507 100.22 2.27772 9-Feb-17 85.022 99.716 2.274158 10-Feb-17 84.91 99.676 2.274158 13-Feb-17 84.758 100.161 2.279288 14-Feb-17 84.52 99.638 2.277293 15-Feb-17 84.824 99.695 2.280428 16-Feb-17 85.628 100.185 2.294435 17-Feb-17 85.151 99.596 2.294435 20-Feb-17 85.126 99.944 2.285843 21-Feb-17 84.459 24 99.969 2.284418 22-Feb-17 84.538 99.714 2.282423 23-Feb-17 84.545 100.308 2.284997 24-Feb-17 84.393 99.609 2.292987 27-Feb-17 84.691 99.529 2.295857 28-Feb-17 84.293 98.666 2.279277 1-Mar-17 84.427 98.415 2.289287 2-Mar-17 84.141 98.233 2.282423 3-Mar-17 85.117 98.514 2.283563 6-Mar-17 84.705 97.953 2.281425 7-Mar-17 84.701 7 97.796 8-Mar-17 84.607 97.683 2.2715 9-Mar-17 84.828 97.575 2.26966 10-Mar-17 85.616 97.646 2.270368 13-Mar-17 85.521 98.088 2.271783 14-Mar-17 85.145 97.591 2.272349 15-Mar-17 86.101 98.594 2.285985 16-Mar-17 85.746 98.442 2.277847 17-Mar-17 86.189 99.48 2.303606 2.28456
