60.1K

Verified Solution

Link Copied!

Please randomly select exchange rates of Turkish Lira with respect to five foreign currencies and record/download their daily stock prices for one month time (daily closing prices) in the following format and respond to the following instructions: 1. Create an academic cover page in a presentable form in the first page. 2. Compute the above statistics listed in the table using MS Excel and present the above table in the second page of your report. 3. Create a line plot for each exchange rate (X-axis: Days, Y-axis: TL prices per foreign currency) in the third page of your report. All five exchange rates' graphs will be on the same page. 4. Having the above table and figures, now provide your final report on your findings regarding the followings under a title "REPORT": a. Which exchange rate has shown better performance than others? Why? b. Compare TL performance for each foreign currency with each other? c. If you invest your money, which exchange rate above would be your best solution if you are risk taker or risk avoider? And why? Note: This assignment will be designed and submitted in two separate documents: 1. MS Word (all pages will contain page numbers) 2. MS Excel (Data and graphs will be in different worksheets) Please randomly select exchange rates of Turkish Lira with respect to five foreign currencies and record/download their daily stock prices for one month time (daily closing prices) in the following format and respond to the following instructions: 1. Create an academic cover page in a presentable form in the first page. 2. Compute the above statistics listed in the table using MS Excel and present the above table in the second page of your report. 3. Create a line plot for each exchange rate (X-axis: Days, Y-axis: TL prices per foreign currency) in the third page of your report. All five exchange rates' graphs will be on the same page. 4. Having the above table and figures, now provide your final report on your findings regarding the followings under a title "REPORT": a. Which exchange rate has shown better performance than others? Why? b. Compare TL performance for each foreign currency with each other? c. If you invest your money, which exchange rate above would be your best solution if you are risk taker or risk avoider? And why? Note: This assignment will be designed and submitted in two separate documents: 1. MS Word (all pages will contain page numbers) 2. MS Excel (Data and graphs will be in different worksheets)

Answer & Explanation Solved by verified expert

See Answer