9-97. Obtain the areas of the 254 counties in Texas via a link to a Texas census report at www.pearsonglobaleditions

.com/rufus.

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:

(Note: Use the COUNT IF function for Absolute Frequency.)

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 why not?

Transcribed Image Text:

Absolute Relative Digit Frequency Frequency 1 Benford Frequency .301 2 .176 3 .125 4 .097 5 .079 6 .067 7 .058 8 .051 9 .046