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.
--
David Biddulph

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

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.

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/