See Attachements for more detail:
Remember that this must be a perfectly general spreadsheet with all the formulas cell referenced as the project will be graded by changing the portfolio weights, probabilities and returns at the top of your spreadsheet and verifying that all parts of the spreadsheet recompute correctly. I have also attached a excel spreadsheet template for you to work from and I strongly encourage you to base your submissions on this template and follow this format (the first 3 parts of this project are already completed for you in this template). Remember that your excel formulas will follow the outline given in the solution to the portfolio analysis homework problem (which is part of the homework for Chapter 6).
These are all population formulas. You CANNOT!!!!!!!!!! use the built-in excel formulas for standard deviation, covariance or correlation as these are sample formulas and you must use population formulas as illustrated in the solution to the portfolio analysis homework. Before you send this to me you should check your results with “out of sample” data by entering all the data for a different problem (just use the portfolio analysis homework or one of the examples in the text) and making sure all components re-compute correctly.