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