Re: Data Generation
- From: "bplumhoff@xxxxxxxxx" <bplumhoff@xxxxxxxxx>
- Date: 15 May 2006 02:22:17 -0700
Hello,
I get at the end 9247677589.34 which is precisely 4.00% as expected:
=200*(1+4%)^450
My algorithm starts to generate random numbers with the full given
flexibility of +/-12% per step - until it reaches boundary conditions
to meet the final preset result.
There are zillion ways to come from 200 to 9247677589.34 in 450 steps
:-) And each of these are "skewed" by the condition "result =
9247677589.34". Now you can decide which "skew" you would fancy.
Would you like the random numbers to be generated with a flexibility
between -4% and +12% (meaning: on average equal to the given compound
growth rate)?
Regards,
Bernd
.
- Follow-Ups:
- Re: Data Generation
- From: rvExcelNewTip
- Re: Data Generation
- References:
- Data Generation
- From: rvExcelNewTip
- Re: Data Generation
- From: bplumhoff@xxxxxxxxx
- Re: Data Generation
- From: rvExcelNewTip
- Data Generation
- Prev by Date: Re: Data Generation
- Next by Date: Re: formulas containing more than one 'operator'
- Previous by thread: Re: Data Generation
- Next by thread: Re: Data Generation
- Index(es):
Relevant Pages
|