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

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?




May 08, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here