Benford law option available in Microsoft Excel

A

Auditor

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

David Biddulph

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.
 
G

Glenn

Auditor said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top