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