Obtain the areas of the 254 counties in Texas via a link to a Texas census report at Copy and paste this data into an Excel spreadsheet, then perform the following tasks.
1. Extract the first digit from the data series using the LEFT function.
2. Complete the Absolute Frequency and Relative Frequency columns in the following table:
3. Graph Relative Frequency and Benford Frequency on a single line graph.
4. Evaluate the graph to determine whether the data set conforms to Benford’s Law.
5. Is it not reasonable to expect the areas of the counties in Texas to follow Benford’s Law? Why or whynot?

  • CreatedMarch 04, 2015
  • Files Included
Post your question