Excel Forum
Similar Content
Error bars in Charts in Excel
Tutorial: How to add, manage, and remove error bars in charts in Excel. Error bars allow you to sh...
Convert Numbers into True and False in Excel
Tutorial: How to convert numbers into the TRUE and FALSE Boolean values in Excel. This is very impor...
Sum Values from Every X Number of Rows in Excel
Tutorial: Add values from every x number of rows in Excel. For instance, add together every other va...



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.