<r>As mentioned the most correct method isGenerate vector of RV's ~N[0,1].Use the cholesky decompostion of the covariance matrix to transform this vector.For an XLL Excel Addin implementation of the two required functions goto:Function: randStd() at <URL url="http://www.PimpMyExcel.com">www.PimpMyEx...