N
Nazmul Hasan
Hi everyone,
I have been using the Random Number Generation (RNG) tool that comes with
excel to generate numbers for an investigation i am doing for my masters
degree dissertation.
I am very stuck now as i have discovered that the RNG is not really random,
and i have had many multiple results that have repeated themselfs.
I have been using the RNG tool that comes as part of the Analysis ToolPak.
The RNG is accessed via Tools, Data Analysis, Random Number Generation.
The setting i had were:
No. of variables - 4
Number of Random Numbers - this changed with the user choice, say,
40
Distribution - Normal
Parameters: - Mean 0, Standard Deviation 1
No random seed chosen (i acutally don't know what it does)
Output range - A1
Can anyone help me either write a proper RNG tool that i could use in Excel,
with the above setting. Alternatively, does anyone know where i may be able
to obtain in a (free) add-in for excel that will do this task better then
Excel's own RNG.
I am on a extremely tight deadline with my dissertation, any help or advice
is very welcome and is much appreciated.
Thank you all in advance.
Regards
Nazmul Hasan
I have been using the Random Number Generation (RNG) tool that comes with
excel to generate numbers for an investigation i am doing for my masters
degree dissertation.
I am very stuck now as i have discovered that the RNG is not really random,
and i have had many multiple results that have repeated themselfs.
I have been using the RNG tool that comes as part of the Analysis ToolPak.
The RNG is accessed via Tools, Data Analysis, Random Number Generation.
The setting i had were:
No. of variables - 4
Number of Random Numbers - this changed with the user choice, say,
40
Distribution - Normal
Parameters: - Mean 0, Standard Deviation 1
No random seed chosen (i acutally don't know what it does)
Output range - A1
Can anyone help me either write a proper RNG tool that i could use in Excel,
with the above setting. Alternatively, does anyone know where i may be able
to obtain in a (free) add-in for excel that will do this task better then
Excel's own RNG.
I am on a extremely tight deadline with my dissertation, any help or advice
is very welcome and is much appreciated.
Thank you all in advance.
Regards
Nazmul Hasan