Uniform random number generators do not conform to Benford's law. To get uniform digits in the range 1 to 10, try =FLOOR(10*RAND();1;1)
However, Benford's law is about the *first* digit of a wide variety of numbers. See <http://en.wikipedia.org/wiki/Benford%27s_law#Mathematical_statement>. To get the Benford distribution of digits 1 to 9, I think you want =FLOOR(10^RAND();1;1) What makes you think these do not have the Benford distribution? How are you testing that. You should be able to create a histogram for the frequencies of values of 1, 2, 3, ..., 9 and show that it approaches the Benford distribution as you increase the number of samples. While the RNG used for RAND() may not be cryptographically wonderful, I expect it would pass a reasonable test (say chi-squared) for correspondence to the Benford distribution. - Dennis -----Original Message----- From: Toki Kantoor [mailto:toki.kant...@gmail.com] Sent: Sunday, July 14, 2013 02:01 PM Cc: users@global.libreoffice.org Subject: Re: [libreoffice-users] Benford's Law On 07/13/2013 11:01 PM, Brian Barker wrote: >Unless I misunderstand,the formula =10^RAND() should create random variates in >the range (1,10) following the law. 10^RAND generates a set of random numbers that does _not_ adhere to Benford's Law. I need a random number generator whose output does adhere to Benford's Law. jonathon -- LibreOffice in a Multi-Lingual Environment. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted