Due 6/16/19 by midnight

Homework Assignment 3 is worth 100 points. The assignment must be submitted to Webcourses by Sunday, June 16th by 11:59pm EST. Late assignments will not be accepted for any reason and will automatically be graded as a zero. Do not work together on assignments or you will receive a zero for the assignment. Type all of your answers in your own words or you will receive a zero for the assignment. Failure to complete all five components of the assignments below will result in a deduction of points. Using the “Crime by state 2015” excel file: Create a Pivot Table that displays the row labels by “state” and the sum of “violent crime”. Create a variable that displays the rate of robbery (using the “robbery” variable) for every 10,000 individuals for every state. Write at least two (2) sentences describing the rate of robbery variable that you created. Be sure to include which state and the rate of individuals (every 10,000 individuals) in your sentences. You can compare and contrast states, describe different states, or include additional information from the table in your sentences. Create a variable that displays the rate of burglary (using the “burglary” variable) for every 100,000 individuals for every state. Write at least two (2) sentences describing the rate of burglary variable that you created. Be sure to include which state and the rate of individuals (every 100,000 individuals) in your sentences. You can compare and contrast states, describe different states, or include additional information from the table in your sentences. To answer question #3 and #5: After adding the new variables, click on a cell and click on the "insert" tab, then click on "new comment". Please answer question #3 and #5 as two separate comments. HW3 Save the Excel spreadsheet as: YOURLASTNAME2