ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How can I generate correlated standard normals? (https://www.excelbanter.com/excel-worksheet-functions/54401-how-can-i-generate-correlated-standard-normals.html)

Dan

How can I generate correlated standard normals?
 
How can I generate correlated standard normals?

Jerry W. Lewis

How can I generate correlated standard normals?
 
Generate three N(0,1) variables, X2,X2,X3
Y1=a*X1+b*X3
Y2=c*X2+d*X3
where a^2+b^2=1=c^2+d^2. Y1 and Y2 are both N(0,1) with correlation b*d

Jerry

"Dan" wrote:

How can I generate correlated standard normals?



All times are GMT +1. The time now is 09:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com