Question: Open the File:US_CRime.txt. Produce a chart with a scatter plot , where the X-axis contains the number of aggravated assaults in Georgia while the Y-axis
Open the File:US_CRime.txt. Produce a chart with ascatter plot, where the X-axis containsthe number of aggravated assaults in Georgiawhile the Y-axis containsthe number of aggravated assaults in Michigan. Fit the trend line.
Georgia,Violent Crime,Aggravated assault,1960,4525 Georgia,Violent Crime,Aggravated assault,1961,4360 Georgia,Violent Crime,Aggravated assault,1962,4038 Georgia,Violent Crime,Aggravated assault,1963,4823 Georgia,Violent Crime,Aggravated assault,1964,5808 Georgia,Violent Crime,Aggravated assault,1965,6403 Georgia,Violent Crime,Aggravated assault,1966,6357 Georgia,Violent Crime,Aggravated assault,1967,5792 Georgia,Violent Crime,Aggravated assault,1968,6467 Georgia,Violent Crime,Aggravated assault,1969,6995 Georgia,Violent Crime,Aggravated assault,1970,8139 Georgia,Violent Crime,Aggravated assault,1971,9291 Georgia,Violent Crime,Aggravated assault,1972,9628 Georgia,Violent Crime,Aggravated assault,1973,10103 Georgia,Violent Crime,Aggravated assault,1974,10779 Georgia,Violent Crime,Aggravated assault,1975,12442 Georgia,Violent Crime,Aggravated assault,1976,12022 Georgia,Violent Crime,Aggravated assault,1977,12946 Georgia,Violent Crime,Aggravated assault,1978,13432 Georgia,Violent Crime,Aggravated assault,1979,14562 Georgia,Violent Crime,Aggravated assault,1980,16189 Georgia,Violent Crime,Aggravated assault,1981,16267 Georgia,Violent Crime,Aggravated assault,1982,15292 Georgia,Violent Crime,Aggravated assault,1983,15408 Georgia,Violent Crime,Aggravated assault,1984,16619 Georgia,Violent Crime,Aggravated assault,1985,17292 Georgia,Violent Crime,Aggravated assault,1986,19449 Georgia,Violent Crime,Aggravated assault,1987,19438 Georgia,Violent Crime,Aggravated assault,1988,23278 Georgia,Violent Crime,Aggravated assault,1989,25937 Georgia,Violent Crime,Aggravated assault,1990,27690 Georgia,Violent Crime,Aggravated assault,1991,27483 Georgia,Violent Crime,Aggravated assault,1992,28835 Georgia,Violent Crime,Aggravated assault,1993,29628 Georgia,Violent Crime,Aggravated assault,1994,28249 Georgia,Violent Crime,Aggravated assault,1995,29318 Georgia,Violent Crime,Aggravated assault,1996,28879 Georgia,Violent Crime,Aggravated assault,1997,27044 Georgia,Violent Crime,Aggravated assault,1998,26514 Georgia,Violent Crime,Aggravated assault,1999,25721 Georgia,Violent Crime,Aggravated assault,2000,25450 Georgia,Violent Crime,Aggravated assault,2001,24491 Georgia,Violent Crime,Aggravated assault,2002,23125 Georgia,Violent Crime,Aggravated assault,2003,22501 Georgia,Violent Crime,Aggravated assault,2004,23561 Georgia,Violent Crime,Aggravated assault,2005,23977
Answer questions 1 to 4.(pick the answer that fits best)
1. What does each dot represent?
- a. A crime
- b. A year
- c. A murder
- d. A state
2. What is the slope of the trend line (round to 2 decimal places)?
- a. 0.72
- b. 0.87
- c. 1.26
- d. 1.59
3. What is the highest number of aggravated assaults recorded for Michigan? (pick the best answer)
- a. 44747
- b. 45070
- c. 29318
- d. 29628
4. What is the approximate average number of aggravated assaults for Georgia? (pick the best answer)
- a. 14000
- b. 17000
- c. 20000
- d. 22000
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
