Lsp 120 free essay sample

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. 9E-05| Los Angeles, California| 3763486| 588| 0. 000156| Detroit, Michigan| 956283| 395| 0. 000413| Philadelphia, Pennsylvania| 1518302| 309| 0. 000204| Note: New York’s rate is â€Å"8. 09E-05. † This means 8. 09*10^-5 or 0. 0000809 (move the decimal to the left 5 times. d. Now sort the data by column D. Which three cities had the highest murder rates in 2001? Fairfield, AL, Gary,In, and Opa Locka, FL e. How many times greater was the murder rate for the Fairfield, Alabama than the rate for Chicago? 4. We will write a custom essay sample on Lsp 120 or any similar topic specifically for you Do Not WasteYour Time HIRE WRITER Only 13.90 / page 23 0. 000965/ 0. 000228 = 4. 23 Fairfield’s rate is 4. 23 times greater than Chicago’s f. There were exactly four cities with population greater than 500,000 with a rate higher than Chicagos. Which were they? Memphis, Baltimore, DC, Detroit g. Now sort by column B (population) in descending order to look at the largest cities in the US. Copy the top 10 rows of the table and paste them into a different part of your Excel sheet. You should now have the just the cities with population greater than 1 million. Sort this table by rate and paste the resulting table into your Word document. Who is ahead of the pack here when we consider cities of population 1 million or greater? Chicago, Illinois| 2910709| 665| 0. 000228| Philadelphia, Pennsylvania| 1518302| 309| 0. 000204| Dallas, Texas| 1215553| 240| 0. 000197| Los Angeles, California| 3763486| 588| 0. 000156| Phoenix, Arizona| 1366542| 209| 0. 000153| Houston, Texas| 1997965| 267| 0. 000134| Las Vegas, Nevada| 1117763| 133| 0. 000119| San Antonio, Texas| 1170622| 100| 8. 54E-05| New York, New York| 8023018| 649| 8. 09E-05| San Diego, California| 1246136| 50| 4. 1E-05| Chicago h. What was the overall impression of the article and the accompanying graph? Given the additional data in the Excel file, do you think the article is misleading in certain ways? If so, how? Critique the use of quantitative information in the New Years Day article. Yes, the article is a bit misleading in that it is only considering cities with more than a million people when it says Chicago is leading with regard to homicide rate. Naturally the rate is going to be high when you have so many people in a city. If you consider cities that have 500,000 or more people we are fifth despite having a larger population than the four cities ahead of us. Additionally, it mentions in the title that Chicago has fallen out of first, but this is only in absolute terms. 2. Spot prices for crude oil are rather volatile. From 1998 to 1999, spot prices for crude oil decreased by 28%. From 1999 to 2000, they increased by 106%. What was the percentage change over the two year period from 1998 to 2000? (You can assume that you start with a $100 initial price. If I start with $100 and in the first year, from 98 to 99, it decreases by 28% then in that year the price goes from $100 to: y= P*(1+/-r)^x y=100*(1-. 28)^1 = $72 If I start with $72 in 1999 and increase that by 100% to 2000 then in 2000 the price is: y = 72*(1+1. 06) = $148. 32 If I started in 1998 with $100 and ended with my new value of $148. 32 in 2000 then my percent increase is: (148. 32 – 100)/100 = . 4832 OR 48. 32% increase 3. There were 100 cellular telecommunications employees in the year 2000. The number of cellular telecommunications employees increased 10. % from 2000 to 2001 and decreased 5. 5% from 2001 to 2002. a. How many cellular telecommunications employees were there in 2002? From 2000 to 2001 we go from 100 employees to: y = 100*(1+. 104) = 110. 4 or 110 employees If we decrease this by 5. 5% then in 2002 we’ll have: Y = 110*(1-. 055) = 103. 95 or 104 employees b. What was the overall percent change in the number of employees from 2000 to 2002? Had 100 (reference or old value) and I now have 104 employees (new value): (104-100)/100 = . 04 or 4% increase