Below are attached two files, “writing assignment rules” and an excel sheet “crime”.From you is required to follow all the steps in the “writing assignment rules” file in order to complete them in the “crime” excel file, please make sure to show how you completed every single step.Once all the steps are done, you are required to create a word file that contains your results, and interpretations. From you I expect back two files, an Excel file and a Word document The “writing assignment rules” file gives a detailed explanation of what needs to be done. MUST FOLLOW ALL THE STEPS!!!
03statswritassnfall2018_1_.pdf

03crime.xlsx

crime.xlsx

writting_assingment_rules.pdf

Unformatted Attachment Preview

Economics Statistics, ECON 221
Hunter College, CUNY
Fall 2018
R. Tasnim
Writing Assignment Description
For this writing assignment, you are required to analyze a given dataset, apply statistical
concepts you learned in this class, and present your results in an effective and professional
manner. The assignment is 15% of your final grade. Following are the rules for the assignment:
• The assignment must be submitted individually. You are welcome to work in groups,
but each student must submit his or her own assignment.
• It is due on December 21, 2018 by 11:59 p.m. There will be absolutely no extensions to
this deadline, and late assignments will not be accepted.
• You will submit two files for this assignment:
1. An Excel file that contains your calculation.
2. A Word file that contains your results, and interpretations.
• You will upload your files on BlackBoard in the designated folder.
In your Word file:
• Put your full name, course name, semester, and “Writing Assignment: the name of your
data file” at the top of the first page.
• Use font: Times New Roman, size: 12 pts, and spacing: 1.5.
• When answering each question, number each one followed by your excel results, and
interpretation. Position your tables, graphs, and charts in an organized way. Graphs
should have proper titles, axis labels, legends (if applicable) and should be easy to read.
• This file must NOT exceed 3 pages.
• Name your word file as “Lastname Firstname Result 221”.
In your Excel file:
• Show all your calculations. You can use different worksheets in the same Excel file.
• Name your file as “Latsname Firstname Calculation 221”.
1
Using the dataset “03Crime”, answer the following questions:
1. Find the mean, median, sample variance and sample standard deviation for the variables
All Violent and All Property.
2. Create a histogram using Excel’s Data Analysis toolpack for All Violent. Use the
Sturges’ rule to find how many bins you should include. In your Word file, make sure to
include both a frequency table for the histogram with bin limits, frequencies and relative
frequencies, and your histogram chart. What can you say about the distribution of All
Violent?
3. Find the covariance and correlation coefficient between All Violent and All Property.
Explain what these statistics mean for your dataset.
4. Conduct a hypothesis test at 5% significance level that the population mean of All
Violent is 385 per thousand:
(a) Assume that the dataset given is a sample and population standard deviation is
unknown.
5. Calculate the confidence interval for population mean of All Violent for 90%, 95%, and
99% confidence levels:
(a) Assume that the dataset given is a sample and population standard deviation is
unknown.
6. Can you reject the hypothesis that the population mean of All Violent is 385 per
thousand in both questions 4a and 5a?
2
Crime Rates in U.S. Metropolitan Areas, 2010 (n = 365)
Metropolitan Statistical Area
Abilene, TX M.S.A.
Akron, OH M.S.A.
Albany, GA M.S.A.
Albany-Schenectady-Troy, NY M.S.A.
Albuquerque, NM M.S.A.
Alexandria, LA M.S.A.
Allentown-Bethlehem-Easton, PA-NJ M.S.A.
Altoona, PA M.S.A.
Amarillo, TX M.S.A.
Ames, IA M.S.A.
Anchorage, AK M.S.A.
Anderson, IN M.S.A.
Anderson, SC M.S.A.
Ann Arbor, MI M.S.A.
Appleton, WI M.S.A.
Asheville, NC M.S.A.
Athens-Clarke County, GA M.S.A.
Atlanta-Sandy Springs-Marietta, GA M.S.A.
Atlantic City-Hammonton, NJ M.S.A.
Augusta-Richmond County, GA-SC M.S.A.
Austin-Round Rock-San Marcos, TX M.S.A.
Bakersfield-Delano, CA M.S.A.
Baltimore-Towson, MD M.S.A.
Bangor, ME M.S.A.
Barnstable Town, MA M.S.A.
Battle Creek, MI M.S.A.
Bay City, MI M.S.A.
Beaumont-Port Arthur, TX M.S.A.
Bellingham, WA M.S.A.
Bend, OR M.S.A.2
Billings, MT M.S.A.
Binghamton, NY M.S.A.
Bismarck, ND M.S.A.
Blacksburg-Christiansburg-Radford, VA M.S.A.
Bloomington, IN M.S.A.
Bloomington-Normal, IL M.S.A.2
Boise City-Nampa, ID M.S.A.
Boston-Cambridge-Quincy, MA-NH M.S.A.
Boston-Quincy, MA M.D.
Cambridge-Newton-Framingham, MA M.D.
Peabody, MA M.D.
Rockingham County-Strafford County, NH M.D.
Boulder, CO M.S.A.
Bowling Green, KY M.S.A.
Bremerton-Silverdale, WA M.S.A.
Bridgeport-Stamford-Norwalk, CT M.S.A.
Brownsville-Harlingen, TX M.S.A.
Brunswick, GA M.S.A.
Buffalo-Niagara Falls, NY M.S.A.
Burlington, NC M.S.A.
Canton-Massillon, OH M.S.A.
Cape Coral-Fort Myers, FL M.S.A.
Cape Girardeau-Jackson, MO-IL M.S.A.2
Carson City, NV M.S.A.
Casper, WY M.S.A.
Cedar Rapids, IA M.S.A.
Charleston-North Charleston-Summerville, SC M.S.A.
Charlottesville, VA M.S.A.
Chattanooga, TN-GA M.S.A.
Cheyenne, WY M.S.A.
Chico, CA M.S.A.
Cincinnati-Middletown, OH-KY-IN M.S.A.
Clarksville, TN-KY M.S.A.
Cleveland, TN M.S.A.
Cleveland-Elyria-Mentor, OH M.S.A.
Coeur d’Alene, ID M.S.A.
College Station-Bryan, TX M.S.A.
Colorado Springs, CO M.S.A.
Columbia, MO M.S.A.
Columbia, SC M.S.A.
Columbus, GA-AL M.S.A.
Columbus, IN M.S.A.
Columbus, OH M.S.A.2
Corpus Christi, TX M.S.A.
Corvallis, OR M.S.A.2
Crestview-Fort Walton Beach-Destin, FL M.S.A.
Cumberland, MD-WV M.S.A.
Dallas-Fort Worth-Arlington, TX M.S.A.
Dallas-Plano-Irving, TX M.D.
Fort Worth-Arlington, TX M.D.
Dalton, GA M.S.A.
Danville, IL M.S.A.2
Danville, VA M.S.A.
Davenport-Moline-Rock Island, IA-IL M.S.A.2
Dayton, OH M.S.A.
Decatur, AL M.S.A.
Decatur, IL M.S.A.2
Deltona-Daytona Beach-Ormond Beach, FL M.S.A.
Denver-Aurora-Broomfield, CO M.S.A.2
Des Moines-West Des Moines, IA M.S.A.
Detroit-Warren-Livonia, MI M.S.A.
Detroit-Livonia-Dearborn, MI M.D.
Warren-Troy-Farmington Hills, MI M.D.
Dothan, AL M.S.A.
Dover, DE M.S.A.
Dubuque, IA M.S.A.
Durham-Chapel Hill, NC M.S.A.
Eau Claire, WI M.S.A.
El Centro, CA M.S.A.
Elizabethtown, KY M.S.A.
Elkhart-Goshen, IN M.S.A.
Elmira, NY M.S.A.
El Paso, TX M.S.A.
Erie, PA M.S.A.
Evansville, IN-KY M.S.A.4
Fairbanks, AK M.S.A.2
Fargo, ND-MN M.S.A.3
Farmington, NM M.S.A.
Fayetteville, NC M.S.A.
Fayetteville-Springdale-Rogers, AR-MO M.S.A.5
Flagstaff, AZ M.S.A.
Flint, MI M.S.A.
Florence, SC M.S.A.
Fond du Lac, WI M.S.A.
Fort Collins-Loveland, CO M.S.A.
Fort Smith, AR-OK M.S.A.
Fort Wayne, IN M.S.A.2
Fresno, CA M.S.A.
Gadsden, AL M.S.A.
Gainesville, FL M.S.A.
Gainesville, GA M.S.A.
Glens Falls, NY M.S.A.
Goldsboro, NC M.S.A.
Grand Forks, ND-MN M.S.A.3
Grand Junction, CO M.S.A.
Grand Rapids-Wyoming, MI M.S.A.
Great Falls, MT M.S.A.
Greeley, CO M.S.A.
Green Bay, WI M.S.A.2
Greensboro-High Point, NC M.S.A.
Greenville-Mauldin-Easley, SC M.S.A.
Gulfport-Biloxi, MS M.S.A.
Hagerstown-Martinsburg, MD-WV M.S.A.
Hanford-Corcoran, CA M.S.A.
Harrisburg-Carlisle, PA M.S.A.
Harrisonburg, VA M.S.A.
Hartford-West Hartford-East Hartford, CT M.S.A.
Hattiesburg, MS M.S.A.
Hickory-Lenoir-Morganton, NC M.S.A.
Hinesville-Fort Stewart, GA M.S.A.
Holland-Grand Haven, MI M.S.A.
Honolulu, HI M.S.A.
Hot Springs, AR M.S.A.
Houma-Bayou Cane-Thibodaux, LA M.S.A.
Houston-Sugar Land-Baytown, TX M.S.A.
Huntsville, AL M.S.A.
Idaho Falls, ID M.S.A.
Iowa City, IA M.S.A.
Ithaca, NY M.S.A.
Jackson, MI M.S.A.
Jackson, MS M.S.A.
Jackson, TN M.S.A.
Jacksonville, FL M.S.A.
Janesville, WI M.S.A.
Jefferson City, MO M.S.A.
Johnson City, TN M.S.A.
Johnstown, PA M.S.A.
Jonesboro, AR M.S.A.
Joplin, MO M.S.A.
Kalamazoo-Portage, MI M.S.A.
Kansas City, MO-KS M.S.A.2
Kennewick-Pasco-Richland, WA M.S.A.
Killeen-Temple-Fort Hood, TX M.S.A.
Kingsport-Bristol-Bristol, TN-VA M.S.A.
Kingston, NY M.S.A.
Knoxville, TN M.S.A.
Kokomo, IN M.S.A.
La Crosse, WI-MN M.S.A.3
Lafayette, IN M.S.A.
Lafayette, LA M.S.A.
Lake Charles, LA M.S.A.
Lakeland-Winter Haven, FL M.S.A.
Lancaster, PA M.S.A.
Lansing-East Lansing, MI M.S.A.
Laredo, TX M.S.A.
Las Cruces, NM M.S.A.
Las Vegas-Paradise, NV M.S.A.
Lawrence, KS M.S.A.
Lawton, OK M.S.A.
Lebanon, PA M.S.A.
Lewiston, ID-WA M.S.A.
Lewiston-Auburn, ME M.S.A.
Lexington-Fayette, KY M.S.A.
Lima, OH M.S.A.
Lincoln, NE M.S.A.
Little Rock-North Little Rock-Conway, AR M.S.A.
Logan, UT-ID M.S.A.
Longview, TX M.S.A.
Longview, WA M.S.A.
Los Angeles-Long Beach-Santa Ana, CA M.S.A.
Los Angeles-Long Beach-Glendale, CA M.D.
Santa Ana-Anaheim-Irvine, CA M.D.
Louisville/Jefferson County, KY-IN M.S.A.
Lubbock, TX M.S.A.
Lynchburg, VA M.S.A.
Macon, GA M.S.A.
Madera-Chowchilla, CA M.S.A.
Madison, WI M.S.A.2
Manchester-Nashua, NH M.S.A.
Manhattan, KS M.S.A.
Mankato-North Mankato, MN M.S.A.3
Mansfield, OH M.S.A.
McAllen-Edinburg-Mission, TX M.S.A.
Medford, OR M.S.A.2
Memphis, TN-MS-AR M.S.A.
Merced, CA M.S.A.
Miami-Fort Lauderdale-Pompano Beach, FL M.S.A.
Fort Lauderdale-Pompano Beach-Deerfield Beach, FL M.D.
Miami-Miami Beach-Kendall, FL M.D.
West Palm Beach-Boca Raton-Boynton Beach, FL M.D.
Michigan City-La Porte, IN M.S.A.
Midland, TX M.S.A.2
Milwaukee-Waukesha-West Allis, WI M.S.A.
Minneapolis-St. Paul-Bloomington, MN-WI M.S.A.3
Mobile, AL M.S.A.2,6
Modesto, CA M.S.A.
Monroe, LA M.S.A.
Monroe, MI M.S.A.
Montgomery, AL M.S.A.
Morristown, TN M.S.A.
Mount Vernon-Anacortes, WA M.S.A.
Muncie, IN M.S.A.
Muskegon-Norton Shores, MI M.S.A.
Myrtle Beach-North Myrtle Beach-Conway, SC M.S.A.
Napa, CA M.S.A.
Naples-Marco Island, FL M.S.A.
Nashville-Davidson—Murfreesboro—Franklin, TN M.S.A.
New Haven-Milford, CT M.S.A.
New Orleans-Metairie-Kenner, LA M.S.A.1
New York-Northern New Jersey-Long Island, NY-NJ-PA M.S.A.
Edison-New Brunswick, NJ M.D.
Nassau-Suffolk, NY M.D.
Newark-Union, NJ-PA M.D.
New York-White Plains-Wayne, NY-NJ M.D.
North Port-Bradenton-Sarasota, FL M.S.A.
Norwich-New London, CT M.S.A.
Ocala, FL M.S.A.
Ocean City, NJ M.S.A.
Odessa, TX M.S.A.
Ogden-Clearfield, UT M.S.A.
Oklahoma City, OK M.S.A.5
Olympia, WA M.S.A.
Omaha-Council Bluffs, NE-IA M.S.A.
Orlando-Kissimmee-Sanford, FL M.S.A.
Owensboro, KY M.S.A.
Oxnard-Thousand Oaks-Ventura, CA M.S.A.
Palm Bay-Melbourne-Titusville, FL M.S.A.
Palm Coast, FL M.S.A.
Panama City-Lynn Haven-Panama City Beach, FL M.S.A.
Pascagoula, MS M.S.A.
Pensacola-Ferry Pass-Brent, FL M.S.A.
Peoria, IL M.S.A.2
Philadelphia-Camden-Wilmington, PA-NJ-DE-MD M.S.A.
Camden, NJ M.D.
Philadelphia, PA M.D.
Wilmington, DE-MD-NJ M.D.
Phoenix-Mesa-Glendale, AZ M.S.A.
Pine Bluff, AR M.S.A.
Pittsburgh, PA M.S.A.
Pittsfield, MA M.S.A.
Pocatello, ID M.S.A.
Portland-South Portland-Biddeford, ME M.S.A.
Port St. Lucie, FL M.S.A.
Poughkeepsie-Newburgh-Middletown, NY M.S.A.
Prescott, AZ M.S.A.
Providence-New Bedford-Fall River, RI-MA M.S.A.
Provo-Orem, UT M.S.A.
Pueblo, CO M.S.A.2
Punta Gorda, FL M.S.A.
Racine, WI M.S.A.
Raleigh-Cary, NC M.S.A.
Rapid City, SD M.S.A.
Reading, PA M.S.A.
Redding, CA M.S.A.
Reno-Sparks, NV M.S.A.
Richmond, VA M.S.A.
Riverside-San Bernardino-Ontario, CA M.S.A.
Roanoke, VA M.S.A.
Rochester, MN M.S.A.3
Rochester, NY M.S.A.
Rockford, IL M.S.A.2
Rocky Mount, NC M.S.A.
Rome, GA M.S.A.
Sacramento—Arden-Arcade—Roseville, CA M.S.A.
Saginaw-Saginaw Township North, MI M.S.A.
Salem, OR M.S.A.2
Salinas, CA M.S.A.
Salisbury, MD M.S.A.
Salt Lake City, UT M.S.A.
San Angelo, TX M.S.A.
San Antonio-New Braunfels, TX M.S.A.
San Diego-Carlsbad-San Marcos, CA M.S.A.
Sandusky, OH M.S.A.
San Francisco-Oakland-Fremont, CA M.S.A.
Oakland-Fremont-Hayward, CA M.D.
San Francisco-San Mateo-Redwood City, CA M.D.
San Jose-Sunnyvale-Santa Clara, CA M.S.A.
San Luis Obispo-Paso Robles, CA M.S.A.
Santa Barbara-Santa Maria-Goleta, CA M.S.A.
Santa Cruz-Watsonville, CA M.S.A.
Santa Fe, NM M.S.A.
Santa Rosa-Petaluma, CA M.S.A.
Savannah, GA M.S.A.
Scranton—Wilkes-Barre, PA M.S.A.
Seattle-Tacoma-Bellevue, WA M.S.A.
Seattle-Bellevue-Everett, WA M.D.
Tacoma, WA M.D.
Sebastian-Vero Beach, FL M.S.A.
Sherman-Denison, TX M.S.A.
Shreveport-Bossier City, LA M.S.A.
Sioux City, IA-NE-SD M.S.A.
Sioux Falls, SD M.S.A.
South Bend-Mishawaka, IN-MI M.S.A.
Spartanburg, SC M.S.A.
Spokane, WA M.S.A.
Springfield, IL M.S.A.2
Springfield, MA M.S.A.
Springfield, MO M.S.A.
Springfield, OH M.S.A.
State College, PA M.S.A.
St. Cloud, MN M.S.A.3
Steubenville-Weirton, OH-WV M.S.A.
St. George, UT M.S.A.
St. Joseph, MO-KS M.S.A.
St. Louis, MO-IL M.S.A.2
Stockton, CA M.S.A.
Sumter, SC M.S.A.
Syracuse, NY M.S.A.
Tallahassee, FL M.S.A.
Tampa-St. Petersburg-Clearwater, FL M.S.A.
Texarkana, TX-Texarkana, AR M.S.A.
Toledo, OH M.S.A.4
Topeka, KS M.S.A.
Trenton-Ewing, NJ M.S.A.
Tucson, AZ M.S.A.4
Tulsa, OK M.S.A.
Tuscaloosa, AL M.S.A.
Tyler, TX M.S.A.
Utica-Rome, NY M.S.A.
Valdosta, GA M.S.A.
Vallejo-Fairfield, CA M.S.A.2
Victoria, TX M.S.A.
Vineland-Millville-Bridgeton, NJ M.S.A.
Virginia Beach-Norfolk-Newport News, VA-NC M.S.A.
Visalia-Porterville, CA M.S.A.
Waco, TX M.S.A.
Warner Robins, GA M.S.A.
Washington-Arlington-Alexandria, DC-VA-MD-WV M.S.A.
Bethesda-Rockville-Frederick, MD M.D.
Washington-Arlington-Alexandria, DC-VA-MD-WV M.D.
Waterloo-Cedar Falls, IA M.S.A.
Wausau, WI M.S.A.
Wenatchee-East Wenatchee, WA M.S.A.
Wichita, KS M.S.A.
Wichita Falls, TX M.S.A.
Williamsport, PA M.S.A.
Wilmington, NC M.S.A.
Winchester, VA-WV M.S.A.
Winston-Salem, NC M.S.A.
Worcester, MA M.S.A.
Yakima, WA M.S.A.
York-Hanover, PA M.S.A.
Youngstown-Warren-Boardman, OH-PA M.S.A.
Yuba City, CA M.S.A.
Yuma, AZ M.S.A.
Crime Rate Database – Page 1 of 3
Note: Grey indicates missing data
Violent Crimes Per 100,000
Murder
Rape
Robbery
3.1
48.9
72.7
3.7
40.9
105.1
8.7
24.9
150.4
1.5
21.0
98.5
5.8
44.8
124.3
5.8
23.1
132.3
3.5
20.3
93.6
0.8
38.0
49.8
5.7
40.8
98.9
1.1
41.7
12.4
4.2
85.9
148.5
2.3
33.4
70.6
5.3
36.4
75.9
1.4
43.2
69.8
0.0
21.4
13.8
1.9
21.8
59.9
4.2
19.6
70.5
6.1
20.9
149.7
8.0
18.9
245.5
10.2
37.4
156.6
3.4
24.7
84.0
9.0
19.9
148.4
10.3
23.6
214.4
2.0
12.6
27.2
0.5
36.1
57.6
4.5
75.3
109.6
0.9
78.1
50.8
5.6
37.7
157.9
2.5
44.7
50.6
4.3
29.0
30.9
1.9
19.7
28.6
2.5
20.3
51.0
1.8
33.2
17.0
3.1
28.6
25.5
2.1
29.4
48.6
0.6
45.3
74.5
1.6
33.7
18.2
3.5
22.6
102.5
5.8
26.9
163.0
1.3
17.1
61.6
2.9
21.3
71.8
1.4
24.7
26.6
2.3
18.9
23.5
0.0
39.3
49.1
0.4
68.5
48.1
3.8
16.0
110.6
2.7
25.1
78.7
5.9
25.6
149.7
6.1
25.9
174.3
5.9
15.1
63.0
2.5
30.7
107.8
4.5
22.6
100.2
1.1
31.0
71.7
0.0
1.8
36.3
3.9
12.9
31.1
0.8
22.2
49.9
6.0
25.9
122.9
3.0
31.0
40.0
4.6
26.2
119.6
0.0
44.6
25.0
3.2
41.4
70.7
4.2
32.4
158.0
5.9
37.9
68.4
0.0
21.9
35.1
4.9
32.1
205.4
2.8
33.0
17.6
3.7
43.4
65.7
3.7
64.8
91.0
2.4
28.1
82.5
5.3
36.3
121.5
7.0
21.6
195.8
0.0
35.2
28.7
5.8
43.2
213.6
5.0
53.4
109.8
0.0
20.7
19.5
1.7
29.6
63.7
5.0
32.9
54.8
4.7
28.2
131.0
4.7
26.3
141.9
4.8
32.0
108.8
3.8
24.4
32.7
1.3
79.9
125.5
11.3
25.5
64.3
1.8
45.4
82.4
4.9
31.7
142.9
2.6
17.6
56.1
3.8
28.2
128.7
3.4
29.0
98.2
2.5
48.9
79.9
1.6
34.1
47.1
9.1
34.8
180.7
18.2
41.9
348.1
2.0
29.3
51.9
3.4
42.7
96.4
3.7
43.9
113.3
0.0
24.4
38.2
7.1
23.7
152.2
4.3
27.3
17.4
1.8
15.3
62.0
0.0
21.1
33.4
1.0
27.1
77.3
4.6
12.6
44.8
0.9
29.4
70.1
4.6
47.2
77.4
2.3
26.3
48.6
783.1
0.0
193.2
88.8
1.0
22.1
645.9
3.2
74.8
27.6
478.9
6.3
21.2
168.8
324.2
0.8
58.1
17.3
402.9
4.8
48.5
46.9
827.0
13.8
53.7
221.5
689.5
10.4
30.3
151.8
174.3
1.0
30.9
12.9
238.6
0.0
37.8
27.8
419.0
4.7
41.5
51.0
211.1
6.0
28.7
81.3
536.9
6.8
19.5
147.6
459.8
6.7
42.1
110.9
623.4
4.9
50.1
114.7
174.4
2.1
19.3
46.6
146.3
0.0
26.6
11.0
520.5
7.0
6.1
134.3
1.0
9.0
265.8
2.0
49.6
30.6
389.7
2.2
46.7
91.7
195.4
4.8
7.2
27.7
264.8
1.2
27.4
30.1
157.2
1.0
30.6
24.4
383.8
4.3
16.7
137.3
518.6
4.6
32.8
91.4
221.9
5.0
35.2
91.0
245.7
0.7
17.5
59.1
353.7
2.0
19.2
56.4
304.0
3.5
34.3
119.5
116.4
0.8
23.0
12.3
297.4
4.5
17.7
106.8
140.4
4.1
26.2
51.6
214.7
3.5
17.4
51.9
379.1
9.7
22.1
99.6
179.8
0.0
58.0
11.1
268.1
2.0
22.9
93.8
562.2
9.0
53.2
92.4
384.6
5.9
22.5
80.1
620.7
7.3
25.8
237.1
398.0
5.3
27.8
135.5
225.2
2.3
28.1
11.7
232.1
1.3
39.8
26.3
117.6
2.0
15.8
26.7
384.2
6.9
53.6
49.2
413.5
10.4
32.0
218.5
655.4
4.4
37.7
137.7
557.0
7.2
30.9
148.0
247.2
2.5
32.9
67.7
292.9
2.7
16.3
40.8
348.1
2.5
22.7
41.3
209.2
2.8
16.7
44.5
393.4
4.1
42.0
50.2
376.3
1.7
44.0
48.0
416.2
4.3
64.0
81.0
461.3
8.2
31.9
119.7
236.1
2.0
30.3
37.8
416.2
4.4
42.0
98.4
355.3
4.6
34.9
37.6
227.0
1.1
17.2
35.0
466.1
5.0
28.7
126.4
207.3
3.0
28.3
68.8
2.2
28.4
195.6
1.0
26.1
32.2
620.0
7.5
18.0
123.3
652.1
8.2
56.9
110.7
405.7
5.1
21.7
89.3
186.0
1.8
23.3
65.0
416.2
2.7
48.0
80.2
517.6
4.5
33.3
85.8
350.1
4.2
30.1
35.7
763.4
6.7
39.8
240.6
386.7
0.0
38.7
52.1
771.7
4.4
56.9
99.7
189.1
3.8
18.2
33.3
168.1
1.6
49.4
6.6
159.4
2.8
37.3
59.7
434.2
4.6
25.6
145.2
408.9
3.9
54.0
109.0
426.8
0.7
48.9
60.1
755.8
6.3
47.4
177.8
63.7
0.0
23.6
3.9
473.2
9.6
45.8
81.4
312.9
1.9
95.5
46.8
442.6
5.3
19.5
189.5
509.0
6.3
21.0
221.8
227.1
2.2
14.8
84.6
395.2
4.9
27.0
153.9
808.3
3.6
47.7
121.7
287.2
6.4
22.0
39.5
484.6
12.0
25.3
155.6
432.3
6.6
32.4
85.3
238.5
0.9
24.1
73.3
218.5
0.7
33.2
56.3
329.1
4.8
38.3
35.1
3.2
19.1
177.8
3.2
38.0
76.8
321.1
4.6
29.0
72.0
264.7
1.5
37.2
31.3
1006.5
8.6
46.1
278.1
582.2
10.5
28.9
108.2
609.2
6.6
23.6
198.5
483.2
3.5
24.7
176.3
733.3
8.9
21.3
236.1
540.2
6.4
26.7
155.9
212.5
4.5
33.2
83.4
335.1
2.2
33.7
52.4
464.1
6.4
17.9
208.3
2.4
92.3
534.1
7.4
25.4
176.4
517.3
5.6
26.1
148.5
429.3
9.1
23.4
67.4
278.3
1.3
56.6
57.9
341.3
7.0
25.0
126.9
384.1
4.3
23.8
68.5
208.5
0.0
41.4
44.7
251.6
0.0
27.8
94.6
470.6
2.3
70.0
104.2
645.3
5.9
42.7
153.4
480.1
1.5
21.4
52.4
313.6
3.4
16.6
62.7
643.2
6.2
41.0
138.9
420.7
5.0
15.4
154.6
466.5
20.8
25.6
134.8
391.9
4.7
10.1
164.2
155.9
1.7
8.0
59.8
163.8
2.8
5.1
67.7
389.5
6.9
13.7
193.8
496.0
5.4
11.1
203.5
511.5
3.6
25.4
123.8
394.6
3.5
36.0
86.8
533.9
2.7
42.9
71.4
253.9
2.1
17.7
63.5
658.2
5.2
25.8
81.1
149.6
1.5
31.3
35.6
5.7
43.8
107.6
247.5
1.6
33.7
33.7
386.7
4.5
38.8
97.0
613.7
4.8
33.0
144.1
115.9
1.8
38.6
25.5
216.6
2.2
13.0
77.8
589.3
3.7
31.7
97.9
235.6
0.0
16.5
37.0
520.5
7.2
36.7
95.0
271.4
3.8
58.2
71.1
569.9
7.6
55.1
130.8
406.6
7.5
37.0
99.5
551.8
7.8
28.5
222.5
332.6
4.1
17.6
125.1
605.9
9.1
32.3
251.2
634.8
6.8
26.2
233.2
370.8
5.5
25.9
124.1
793.0
9.0
55.9
172.8
319.5
4.7
16.9
96.5
453.7
0.8
37.7
28.3
217.3
1.1
36.4
15.4
133.5
1.9
28.7
44.3
370.7
4.8
27.9
83.2
264.0
4.6
14.2
85.3
327.2
3.3
23.4
11.0
371.4
2.6
30.2
91.8
81.4
1.1
22.1
14.1
585.2
2.6
19.2
104.8
240.6
0.6
14.5
29.7
253.1
4.0
15.9
109.5
242.6
3.4
16.1
75.3
412.0
3.2
93.4
49.5
329.6
3.2
15.5
107.6
797.1
1.6
65.7
75.5
423.3
4.2
25.2
117.4
269.3
7.2
15.8
111.8
368.5
4.5
20.4
115.7
302.9
6.3
22.8
68.0
0.5
34.6
317.1
4.9
22.1
99.2
760.4
6.5
53.2
159.8
612.6
10.2
23.8
171.3
481.6
3.2
23.5
106.8
478.1
4.2
26.1
160.4
870.7
3.5
76.0
129.2
240.8
1.3
25.4
45.0
495.9
10.7
20.0
139.7
669.7
9.0
28.7
163.9
355.5
2.9
46.2
85.9
274.9
1.8
52.6
49.0
484.0
4.7
32.6
127.2
378.5
2.2
22.0
108.9
298.0
0.0
17.0
35.3
529.0
6.2
23.7
240.1
581.5
7.7
28.0
253.0
454.3
4.0
17.5
221.9
264.5
1.4
21.7
80.1
266.8
2.2
30.5
34.6
451.8
2.7
32.2
76.8
512.8
5.5
26.6
105.1
357.0
6.6
30.4
62.0
396.7
1.3
26.6
59.0
342.5
6.5
20.5
154.8
238.9
2.2
21.8
61.7
353.0
2.3
33.5
119.3
316.7
2.0
31.1
114.6
472.1
3.4
41.4
134.8
325.9
0.0
19.6
65.5
280.3
9.1
17.4
48.1
627.3
8.4
43.1
113.5
238.8
0.0
18.5
24.0
231.7
1.2
43.3
23.9
348.6
2.5
34.0
134.2
492.9
5.2
28.9
87.8
346.0
2.5
31.1
111.3
855.5
4.4
70.2
181.5
578.9
3.7
43.0
126.6
449.0
3.0
34.0
81.0
360.1
2.9
28.8
158.5
106.7
0.0
16.2
23.0
1.6
25.1
162.5
5.0
14.1
43.1
108.6
0.0
16.5
10.1
298.0
5.5
22.2
59.4
497.4
7.8
26.0
126.9
805.2
9.2
23.8
269.5
708.6
5.7
32.5
169.3
292.7
3.4
22.7
79.9
774.9
5.2
50.3
162.4
500.0
4.3
26.6
125.9
739.0
2.9
42.7
117.4
483.1
4.0
28.3
179.3
391.7
6.0
28.3
99.5
447.2
5.4
6.5
184.8
425.6
8.0
23.4
134.6
598.2
6.4
42.3
158.0
432.0
5.1
30.3
124.4
416.6
6.3
54.5
62.3
260.5
2.4
20.7
63.2
359.3
3.8
25.6
78.9
472.9
8.1
35.1
197.6
566.7
6.9
54.6
74.5
494.6
6.3
9.4
175.1
336.9
6.6
20.4
133.1
476.0
8.0
22.9
101.8
542.9
3.8
50.7
102.7
354.0
6.0
22.4
88.9
380.0
5.3
17.8
179.6
207.8
1.9
12.7
96.6
428.2
6.2
19.2
202.9
377.5
2.4
37.2
44.4
129.3
0.0
20.4
15.1
167.1
0.9
43.4
22.6
581.5
2.9
53.0
82.2
361.0
4.8
32.1
95.5
168.2
1.7
23.9
57.2
363.8
3.0
28.0
103.1
166.1
1.6
45.7
34.6
457.0
3.5
30.5
103.1
470.9
1.7
24.5
73.1
344.2
10.0
43.8
97.1
208.5
2.5
22.9
89.0
302.1
5.9
24.5
99.3
361.9
4.2
32.1
64.2
371.9
4.7
19.4
40.9
All Violent
423.0
304.7
566.0
310.4
670.4
638.0
228.2
243.6
513.1
299.5
812.9
205.8
586.0
338.5
155.8
229.7
374.9
413.8
529.8
412.9
327.9
593.0
685.3
68.4
434.6
697.6
335.2
498.3
267.0
304.9
218.2
221.4
228.5

Purchase answer to see full
attachment