Thread: Data Generation
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
rvExcelNewTip
 
Posts: n/a
Default Data Generation


This is probabably a mathematical rather than an excel question, but I
give it a try. I want to generate a "random" data series with the
following characteristics:
1. The overal series should have a X% compounded growth rate
2. Each point should be within a Y% interval around the previous
point.
(Y X)

For instance, the data series should show a 4% compounded growth rate,
but from one point to the next there can be a variation of +/- 12%.

Has somebody a hint as to how to construct such a function?


--
rvExcelNewTip
------------------------------------------------------------------------
rvExcelNewTip's Profile: http://www.excelforum.com/member.php...o&userid=15668
View this thread: http://www.excelforum.com/showthread...hreadid=541903