ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   random number generation (https://www.excelbanter.com/excel-worksheet-functions/5429-random-number-generation.html)

kurtrambis

random number generation
 
How do I randomly generate rates of return per period for a portfolio for
several periods given expected return rates and standard deviations?

Jonathan Rynd

"?B?a3VydHJhbWJpcw==?="
wrote in :

How do I randomly generate rates of return per period for a portfolio
for several periods given expected return rates and standard
deviations?


Generate normally distributed random numbers in the usual way and then
scale them to have the desired mean and standard dev.


All times are GMT +1. The time now is 03:36 AM.

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