gérard * wrote:
Hello,
I'm a French student in Prepa Maths sup and i'm learning random suites in order
to do a project's school. I demand at several company their function which
permits to give a random number. If you can give me your function in order to
examine her and finally create my own suite, i would be gratefull for your help.
Waiting your response,
Greetings
Gérard
I suspect you are asking for what formula or algorithm is used to
generate the random number. I cannot shed any light on this, but I can
tell you about the TI58/59 calculators statistics package used the
algorithm "Xi+1 = [(24298xi + 99991) mod 199017] (Xmax - Xmin)/199017 +
Xmin" where X0 is your seed. Searching the internet with "random number
generator algorithm" will generate about 32 million hits, probably
having some good information for you.
However, the helpful help files will tell you (IF this is what you
really are asking for):
QUOTE
RANDBETWEEN
Returns an integer random number in a specified range.
This function is only available if Analysis AddIn is installed.
Syntax
RANDBETWEEN(Bottom; Top)
Returns an integer random number between integers *bottom* and *top*
(both inclusive).
This function produces a new random number each time Calc recalculates.
To force Calc to recalculate manually press Shift+Ctrl+F9.
To generate random numbers which never recalculate, copy cells
containing this function, and use *Edit - Paste Special* (with *Paste
All* and *Formulas* not marked and *Numbers* marked).
Example
=RANDBETWEEN(20;30) returns an integer of between 20 and 30.
RAND
Returns a random number between 0 and 1.
Syntax:
RAND()
This function produces a new random number each time Calc recalculates.
To force Calc to recalculate manually press Shift+Ctrl+F9.
To generate random numbers which never recalculate, copy cells each
containing =RAND(), and use *Edit - Paste Special* (with *Paste All* and
*Formulas* not marked and *Numbers* marked).
Example:
RAND() returns a random number between 0 and 1.
END QUOTE
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
