# Lsp 120

Only available on StudyMode
• Topic: Chicago, 2000, 1920
• Pages : 3 (893 words )
• Published : May 29, 2013

Text Preview
Assignment 4
Read the article "Chicago falls out of 1st in murders" by David Heinzman from the Chicago Tribune, Jan. 1, 2003.  Then answer the following questions in your Word document. a. Does the headline "Chicago falls out of 1st in murders" refer to an absolute quantity or a relative quantity?  In other words, did Chicago fall out of first in absolute terms or in relative terms?  Briefly explain. It dropped out of first in absolute terms – pure number of homicides. This is mentioned in the second paragraph. It is still #1 with regards to homicide rate, a relative quantity. This is noted in the graph at the top. b. Let us look more carefully at the complete 2001 data. (This is the data for the year before the article)  Open the file HomicidesForCities2001.xls.  Sort the data by the absolute number of murders.  Which three cities had the highest number of murders in 2001? Chicago, New York, and Los Angeles

c. In Column D, calculate the homicide rate (homicides per person).  Paste into your Word document the top five rows of the resulting table. Chicago, Illinois| 2910709| 665| 0.000228|
New York, New York| 8023018| 649| 8.09E-05|
Los Angeles, California| 3763486| 588| 0.000156|
Detroit, Michigan| 956283| 395| 0.000413|