Excel Forum



Excel Array Formula Series 14.3 Portfolio Standard Deviation


See how to create array formulas for Portfolio Return & Standard Deviation. See the array functions: MMULT, COLUMN, TRANSPOSE. See how to do this given different assumed states of the future economy.

See how to use probability, stock weights and assumed stock returns to calculate Portfolio Return & Standard Deviation.

See of to use the MMULT to matrix algebra. See of to use the COLUMN and TRANSPOSE functions to create a vertical array of ones.

In this series see how to create array formulas in Excel. Array formulas can take complex series of formula calculations and reduce them down to a single formula that sits in just one cell! You will see how to create array formulas and see how to use Array Functions.





Got a Question? Ask it Here in the Forum.