1. Crime in Chicago: In 2013, there were 27,295 violent crimes and 113,323 property crimes committed in the city of Chicago for a total of 140,618 crimes
a. Is the number of crimes an example of an absolute quantity or a relative quantity?
b. The number of property crimes was what percent larger than the number of violent crimes?
c. What percent of all crimes in Chicago in 2013 were violent crimes?
d. Good news: The total number of crimes decreased 26% from 2001 to 2013. How many crimes were committed in 2001?
2. Open the tab Accidental Deaths in US.
a. In column D, calculate the absolute change in the number of deaths from 2005 to 2010 for each accident type. Which had the greatest increase? Which had the greatest decrease? State the change for both.
b. In column E, calculate the percent change in deaths from 2005 to 2010. Which had the greatest percent increase? Which had the greatest percent decrease? State the percent change for both.
c. What was the total number of accidental deaths in 2005? What was the total number of accidental deaths in 2010?
d. Compare the total number of deaths in 2005 and in 2010 in 3 different ways. Write a complete sentence for each.
3. Open the tab Heart Disease, which contains data on the number of deaths due to heart disease, which is the leading cause of death in the US, and the population in each state (and DC) in 2010.
a. Which two states had the highest numbers of heart disease deaths? Name the states and the number of cases.
b. In column D, calculate the death rate in number of deaths per 100,000 people for each state. Which two states had the highest heart disease death rates? Name the states and their rates.
c. Does the state with the highest rate also have the highest number of cases? How can a state with a high rate not have a high number of cases? Be specific.
d. Use the Map Making Tool (linked in the excel file) to make a map of the states and their rates. Paste the map here.
e. Examine the map and describe the geographic trends to heart disease in the US. Mention any outliers.
4. Open the Car Salary tab. The table shows the number of cars a salesperson sells and the total salary the salesperson earns.
a. Make a scatter graph with trendline to show that the data is linear. Copy and paste your graph here.
b. What is the rate of change for this function? What is the meaning of this rate of change?
c. What is the initial value for this function? What is the meaning of this initial value?
5. Write your own situation that describes a linear function. Write its equation and define the variables.
6. Gases that trap heat in the atmosphere are often called greenhouse gases. Carbon dioxide (CO2) is one of the principal greenhouse gases. Carbon dioxide is emitted naturally through the carbon cycle and through human activities. Since the Industrial Revolution in the 1700's, human activities such as deforestation and the consumption of energy in the form of burning oil, coal, and gas have increased CO2 concentrations in the atmosphere. (source: epa.gov)
a. Go to the World Carbon tab in the Excel file. Make a scatter graph with trendline of the data. Copy and paste the graph here.
b. According to the trendline equation, how much carbon dioxide will be emitted in 2017? How much confidence do you have in this prediction? Why?
c. According to the trendline equation, in what year were there no global carbon dioxide emissions? How much confidence do you have in this prediction? Why?