Question: Spreadsheets are useful for computing statistics averages standard deviation variance
Spreadsheets are useful for computing statistics: averages, standard deviation, variance, and correlation are included as built-in functions. Below is recent monthly stock return data for ExxonMobil (XOM) and Microsoft (MSFT). Using a spreadsheet and its functions, compute the average, variance, standard deviation, and correlation between the returns for these stocks. What does the correlation between the returns imply for a portfolio containing both stocks?
Answer to relevant QuestionsIf the conditions in the future are expected to be like those in the past, what is the expected portfolio return and standard deviation in a portfolio comprised of 25% XOM and 75% MSFT? 50% XOM and 50% MSFT? 75% XOM and 25% ...Briefly describe the differences between a subchapter S corporation and a limited liability company. How are industry-operating differences reflected in a firm’s financial statements? Describe four provisions of the Sarbanes-Oxley Act. Use a spreadsheet to construct a common-size balance sheet from the data in problem 2 and a common-size income statement from the data in problem 5.
Post your question