Benford law option available in Microsoft Excel

  • Thread starter Thread starter Auditor
  • Start date Start date
A

Auditor

I want to use Benford Law on my data, either that function available in
Microsoft Excel 2007. Thanks
 
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.
 
Auditor said:
I want to use Benford Law on my data, either that function available in
Microsoft Excel 2007. Thanks
Click to expand...


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