Question: In order to generate a table that reports mean, standard deviation, skewness, Sharpe ratio, and variance and covariance matrix of five stocks (in annual term)

In order to generate a table that reports mean, standard deviation, skewness, Sharpe ratio, and variance and covariance matrix of five stocks (in annual term) over 12 years on excel, how would you calculate this on excel ? Please provide the formulas you would use - e.g for the mean to be calculated in annual term is it =AVERAGE(then the cells that is in) or is it to be multiplied by the term?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Draw the shear and moment diagrams for each member of the frame. Assume the support at A is a pin and D is a roller. 0.8 k/ft B 0.6 k/ft 16 ft -20 ft -

You are hired as an investment consultant by a hedge fund that focuses on the following five US stocks: Exxon Mobile (ticker XOM), Nike (ticker NKE), Amazon (ticker AMZN), Goldman Sachs (ticker GS),...

Problem 1: Portfolio Optimisation and Factor Investing Working in a large investment fund as a quantitative analyst, your daily task involves tracking portfolio weights of different factor trading...

Problem 1 : Portfolio Optimisation and Factor Investing Working in a large investment fund as a quantitative analyst, your daily task involves tracking portfolio weights of different factor trading...

This Excel project is a great practice of the Markowitz Portfolio Theory. Enjoy and Have Fun! Format: Please follow the exact layout and format in project331sample.xlsx. One worksheet in one Excel...

SUMMARY this journal, the length of it should not be more than 2 pages, with 1.5 spacing size 12 Times New Rome. Available online at www.sciencedirect.com Journal of Empirical Finance 15 (2008) 199 -...

Portfolio 1: 1/N strategy, i.e., 1/5 weight on each of the five assets. 2---Portfolio 2: implement the maximum utility strategy by investing in all five assets using a degree of relative risk...

Consider the instructions below and find the weights for Microsoft and Tesla stock in the optimal risky portfolio. As your answer, submit Microsoft. Enter your answer as a decimal number up to four...

Date XOM NKE AMZN GS V 29/1/2010 -0.05514008 -0.03511427 -0.06772228 -0.11916605 -0.06208553 26/2/2010 0.01536551 0.06039213 -0.05589667 0.05365791 0.04114348 31/3/2010 0.03046159 0.09127221...

Begg made out a check payable to the order of Newwall, a subcontractor, for $ 32,000 in November to cover work in progress. In January, Begg issued another check to Newwall to cover the entire amount...

7. A beam of span 8 m has roller support at A and hinge support at B as shown in Fig. Draw SF and BM diagrams when the beam is subjected to UDL, a concentrated load and an externally applied moment...

which of the following is a basic principle of cash management? keep inventory levels high, use the full payment period for payment of liabilities, increase the payment cycle of salaries and wges,...

If tax revenues equal 20 percent of total output and government expenditures equal 15 percent of total output, then there is a a.government budget surplus. b.trade deficit. c.government budget...