please solve it using excel.

1. For the following given data of Northern Cyprus in million US S, calculate the correlation coefficient in MS Excel by the given formula and make interpretation. What does your result mean? (45 pts) Exports % Growth Years 2009 2010 2011 2012 2013 2014 2015 Tourism Revenues 224,8 153,6 175.1 224.6 65,5 52.5 54.6 54,5 53,4 67,3 70,5 57,7 53,4 172,9 218.9 175,6 2016 183.2 186,0 2017 a) R = 61 - Xy - 1) 6 - G- Answer: b) Compute percentage growth rates of exports and tourism revenues over the years. Answer: c) What is coefficient of variation for exports and tourism revenues? Which one is more volatile and why? Answer: 2. Assume that you want to evaluate two investment alternatives which are given below. Are they worth of investment for a discount rate of 5.025%? If yes, which one seems more attractive? What are their internal rates of return? What does IRR mean? What is NPV? Write the theoretical formula of NPV? (20 pts) (Assume that investment is made at the beginning of 2019). Years Project A Project B Today's Future Cash Flows Investment 2019 2020 2021 2022 2023 2024 2025 $ 125,000 S 26,500 $ 32,000 S 37,000 $ 38,000 S 42,000 $ 47,600 $ 127,000 S 24,000 $ 31,000 S 38,000 $ 39,800 $ 41,900 $ 45,000