Can some one tell me how I can generate n number of negative exponential numbers between a gievn range...

An excel demonstration would really help.... Any one with some time to spare???

thanx in advance

Printable View

- 09-01-2004vasanthNegative Exponential
Can some one tell me how I can generate n number of negative exponential numbers between a gievn range...

An excel demonstration would really help.... Any one with some time to spare???

thanx in advance - 09-01-2004Thantos
Assuming A2 holds the low value for the range and B2 holds the hi value for the range and assuming that you want 2 to the power of the exponent:

Code:`=POWER(2,RAND()*(B2-B1)+B1)`

- 09-01-2004vasanth
oopps.. sorry.. i requre to generate set of n numbers which satisfy the negative exponential curve...