Download Excel file: https://people.highline.edu/mgirvin/AllClasses/455/ch10/ExcelShort57-59.xlsx
Learn how to create single cell array formula for stock A and stock B to calculates and spills the Expected Returns and Standard Deviations using array calculations and the BYCOL, SUM and SQRT functions. Also see that we can use BYCOL and BYROW lambda eta functions that are not from the dropdown list of functions. See that we can use the SQRT function inside BYCOL and BYROW functions

#excel #excelformulas #excelfunctions #Short #excelfinance #BYCOL #BYROW #arrays #expectedreturn #standarddeviation