Benford law option available in Microsoft Excel
 

I want to use Benford Law on my data, either that function available in
Microsoft Excel 2007. Thanks

Benford law option available in Microsoft Excel
 

To get the leading digit in cell A2, use =LEFT(A2), or --LEFT(A2) to convert
from text to a number.
Benford's law states that the leading digit d (d ? {1, ., b ? 1} ) in base b
(b ? 2) occurs with probability P(d)=logb(d + 1) ? logbd = logb((d + 1)/d).
If you wished to, you could calculate that in Excel.
--
David Biddulph

"Auditor" wrote in message
...
I want to use Benford Law on my data, either that function available in
Microsoft Excel 2007. Thanks

Benford law option available in Microsoft Excel
 

Auditor wrote:
I want to use Benford Law on my data, either that function available in
Microsoft Excel 2007. Thanks


Type "Benford Excel" into a search engine and follow the links until you find
something that fits your data.

Benford law option available in Microsoft Excel
 

On Tuesday, April 28, 2009 5:26:05 PM UTC+1, Auditor wrote:
I want to use Benford Law on my data, either that function available in
Microsoft Excel 2007. Thanks

Try the Excel spreadsheet at: http://investexcel.net/3420/benfords-law-excel/