Import the 2000/2010 census data into Access. Before importing the data change the blank (null) values for the 2000 census to zeroes. Name the file Census.accdb. This case will calculate a risk score for each state based on the census numbers. Each state (and the District of Columbia) will therefore be a forensic unit. No fraud or error is actually suspected in this case. The activity is done simply to develop some practice with scoring forensic units.
Required:

Create a predictor P1 that scores each forensic unit with a 1.00 if the state has a newly formed county, and zero otherwise (similar to the P8 variable in the chapter, although P8 had three possible values, not just 0 or 1). A newly formed county would occur when there is a 0 value for the 2000 census and a positive count for the 2010 census.

Create a predictor P2 that gives each state a score of .1 (with a maximum of 1.00) for each number in either 2000 or 2010 that is an exact multiple of a 100 (e.g., 400, 900, 2,000, or 3600). A state with 4 "round numbers" should score 0.40 for P2 and a state with no round numbers should score 0.00.

Create a predictor P3 that first calculates the proportion of counties in a state that had population increases of 10 percent or more. The P3 score is equal to the proportion times 3 (with a maximum score of 1.00). Counties with zero populations in 2000 should be scored as if their percentage increase is greater than 10 percent.

Calculate the final risk scores for each state by giving P1 a weight of 0.10, P2 a weight of 0.30, and P3 a weight of 0.60. Round and display the scores to three decimal places. Sort the results by risk scores decreasing. Export the results to Excel. Save the Census.accdb file.

Answer rating: 100% (QA)

a P1 IfCensus2000County 0 1 0 b P2 1number of round numbers in 2000 number ... View the full answer