Explanations 
Textbooks 
Flashcards 
魅影直播 AI 
Notes 
Study Plans 
Study Sets 
Find a degree 
Magazine Chapter 2: Q.22 (page 131)
The following data sets list full time police per citizens along with homicides per citizens for the city of Detroit, Michigan during the period from
a. Construct a double time series graph using a common x-axis for both sets of data.
b. Which variable increased the fastest? Explain.
c. Did Detroit鈥檚 increase in police officers have an impact on the murder rate? Explain.
Short Answer
a. A double time series graph as follow:
b. The number of police is increasing fastest.
c. May be it can be said to save the city from large number of crimes, Detroit's increasing in police officer.
Step by step solution
Content Introduction
Consider the below data for the number of police and homicide :
The time series graph is made in excel as follow:
- Select the given data and go to Insert in the menu bar.
- select "Insert line Chart" from the heading "Charts".
- Select 2-D line charts.
- Click on displayed chart and on the right hand side of the chart, a plus sign can be seen.
- Click on it and select chart elements written As Axis title, data label, Chart type, Legend, Label, as shown in the time series below.
Explanation (Part a)
The output for time series graph for the number of police and homicides is:
Explanation (Part b)
from the above graph it can be said , the number of police is increasing fastest.
Explanation (Part c)
May be it can be said to save the city from large number of crimes, Detroit's increasing in police officer.
Over 30 million students worldwide already upgrade their learning with 魅影直播!
