ISBN XXXXXXXXXX58576-3 Case 1 Use the 1_ CensusData_2010 data file:1_CensusData_2010.xlsx download This Excel file shows the state, the county reference, the county name, the county area, and the...

1 answer below »
ISBN (13) 978-1-119-58576-3Case 1

Use the1_
CensusData_2010data file:1_CensusData_2010.xlsx

download

This Excel file shows the state, the county reference, the county name, the county area, and the county population according to the 2010 census. There are 3,143 records and a header row. Use Excel and show your screenshots or text for the requirements.


There is a guidance videoForensic Analytics Second Edition, Guidance Case 1.1, Using Excel’s VLOOKUP function for a Histogram, which can be found at:https://www.youtube.com/watch?v=pUrieXshCtA(Links to an external site.)





Required



  1. Use the VLOOKUP function in Column F to add aDescriptionfor each county that describes the population as anErrorif the population is less than 1, asSmallif the population is in the 1 to 14,999 range, asMediumif the population is in the 15,000 to 49,999 range, asLargeif the population is in the 50,000 to 499,999 range, and asVery Largefor populations of 500,000 and higher. Show a screenshot of your headings and the first 10 rows of your results. A blurred clue is shown below:

  2. Create a table showing the counts for theError,Small,Medium,Large, andVery Largecategories and the five category names. Show the total of the five counts. The count for theErrorcategory should be zero. Make sure that your five category counts reconcile with the total number of counties (3,143). Sort theDescriptionsas set out in the first sentence, that is, from the smallest category (Error) to the largest category (Very Large).

  3. Read the histogram section in Chapter 2 on pages 56-58. Create a histogram of the 2010 population numbers using 11 intervals (1-49,999, 50,000-99,999, …, 500,000 and higher). The last interval is for all populations 500,000 and higher. In Chapter 2 in Figure 2.5 (on page 58) the last interval is for all dollar amounts $2,800 and higher. Thex-axis labels should show the upper bounds of the intervals (49,999, 99,999, 149,999, 199,999, …, 499,999, 500,000+). Be sure to add a graph title and to label thex-axis and they-axis with descriptive words and text that can be easily read on a screen. A blurred clue is shown below:
    Case 1.png

  4. Read the histogram section in Chapter 2 on pages 56-58. Is the Census 2010 population data positively or negatively skewed? Does the data show the same general pattern that is expected for the dollar amounts of purchasing card data and for invoices paid through the accounts payable department?

  5. Give an example of a data set that you think would have a negatively skewed skewness measure. Avoid giving an example that has to do with time. Histograms generally have nothing to do with time. A negatively skewed data set will have more large numbers and relatively fewer small numbers.

  6. Review theCase Submission Checklistand type the statement, “I reviewed the case submission checklist before submitting this case.”


Test 1B Chapter 1" style="float: left;">Previous
Required Discussion Question Module 1 - Introduce yourself (Two truths and one non-truth)" style="float: right;">Next
Answered 3 days AfterMay 13, 2021

Answer To: ISBN XXXXXXXXXX58576-3 Case 1 Use the 1_ CensusData_2010 data file:1_CensusData_2010.xlsx download...

Archit answered on May 16 2021
153 Votes
SOLUTIONS
1) The following results were found after using the VLOOKUP function available in Microso
ft Excel. We categorized the population into 5 categories: error (for population less than 1), small (for population 1 to 14,999), medium (for population 15,000 to 49,999), large (for population 50,000 to 500,000) and very large (for population greater than 50,000). The following screenshot shows the starting of the data that was prepared after adding a description.
2) After defining the description column we then created a table which contained the count of each category of population i.e. error, small, medium, large, very large. For this purpose we used COUNTIF function in excel to count the number of occurrence of each category.
3) For creating a histogram of county population the data was divided into 11 intervals (1-49,999, 50,000-99,999, 100,000-149,999, 150,000-199,999, 200,000-249,999, 250,000-299,999, ...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here