Benford Law

[drobinsingh]

Pls can anyone guide me through steps for creating benford's law chart and summary in excel?

 

[ninad7]

Googling gave the below.


http://ss64.com/office/

http://www.exceluser.com/tools/benford_xl11.htm

 

[simulationconsultant]

Also try the spreadsheet at http://investexcel.net/3420/benfords-law-excel/

 

[Hui]

Drobinsingh


Firstly, Welcome to the Chandoo.org forums.


It is really about making a summary table of the count of the occurrances of the first character of each entry in your data


If you post a sample file, Refer: http://chandoo.org/forums/topic/posting-a-sample-workbook

We can give better advice