please solve the question in excel and post the solution including formulas by tomorrow

CXELcise The following table contains rate of returns in the US in US dollars and in Australia in Australian dollars. Also the USD/AUD exchange rate at the beginning of each year is given. Calculate the following: a) Average rates of returns and standard deviations to investors in each respective markets b) Average return and standard deviation to a US investor investing in Australia. c) Average return and standard deviation to an Australian investor investing in the US. d) Correlations between the two markets from US investor's point of view e) Correlations between the two markets from an Australian investor's point of view f) Rate of return and standard deviation to a US investor that invests 60% in the US and 40% in Australia. Year 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 USA AUSTRALIA -1.799%I % -14.512% 15.905% 14.603% 38.320% 15.126% 13.395% 1.099% 5.730% -2.127% 7.503% 6.985% 28.241% 7.048% -3.884% -6.903% 35.226% 18.378% -9.827% -19.401% USD/AUD 0.7024 0.897 1.0206 1.0217 1.039 0.8914 0.8161 0.7281 0.7225 0.7801 0.7047 CXELcise The following table contains rate of returns in the US in US dollars and in Australia in Australian dollars. Also the USD/AUD exchange rate at the beginning of each year is given. Calculate the following: a) Average rates of returns and standard deviations to investors in each respective markets b) Average return and standard deviation to a US investor investing in Australia. c) Average return and standard deviation to an Australian investor investing in the US. d) Correlations between the two markets from US investor's point of view e) Correlations between the two markets from an Australian investor's point of view f) Rate of return and standard deviation to a US investor that invests 60% in the US and 40% in Australia. Year 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 USA AUSTRALIA -1.799%I % -14.512% 15.905% 14.603% 38.320% 15.126% 13.395% 1.099% 5.730% -2.127% 7.503% 6.985% 28.241% 7.048% -3.884% -6.903% 35.226% 18.378% -9.827% -19.401% USD/AUD 0.7024 0.897 1.0206 1.0217 1.039 0.8914 0.8161 0.7281 0.7225 0.7801 0.7047