Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
kurtrambis
 
Posts: n/a
Default 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?
  #2   Report Post  
Jonathan Rynd
 
Posts: n/a
Default

"?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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Seed numbers for random number generation, uniform distribution darebo Excel Discussion (Misc queries) 3 April 21st 23 09:02 PM
How can I get Positive values only from the random number generat. Markw3700 Excel Discussion (Misc queries) 1 January 21st 05 12:37 AM
Running Total of Random Number Mr H Excel Discussion (Misc queries) 4 January 19th 05 10:35 PM
How to format a number in Indian style in Excel? Victor_alb Excel Discussion (Misc queries) 2 December 21st 04 04:21 AM
Count number of shaded cells Maddoktor Excel Discussion (Misc queries) 2 December 20th 04 08:35 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"