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?
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here