BSAD221 Difference Between a Population and A Sample Statistics Excel Project
BSAD221 Difference Between a Population and A Sample Statistics Excel Project
Requirements
– Must know how to use excel
– Be able to make a bar graph based off of the information given as well
Here is the information I would like for you to use to base the project off of.
50 Most Dangerous Cities In The US
State City Population Violent Crimes Per 1000
|
1 |
Alabama |
Anniston |
22,205 |
33.10 |
|
|
2 |
Missouri |
Wellston |
2,326 |
30.09 |
|
|
3 |
Louisiana |
Monroe |
49,677 |
30.05 |
|
|
4 |
Georgia |
Oakwood |
4,218 |
29.63 |
|
|
5 |
Alabama |
Bessemer |
26,592 |
28.69 |
|
|
6 |
New Mexico |
Espanola |
10,030 |
26.72 |
|
|
7 |
Florida |
Opa Locka |
16,835 |
22.22 |
|
|
8 |
Alaska |
Bethel |
6,522 |
21.62 |
|
|
9 |
Florida |
Cocoa |
17,825 |
20.70 |
|
|
10 |
Michigan |
Detroit |
669,673 |
20.47 |
|
|
11 |
South Carolina |
Hartsville |
7,837 |
19.65 |
|
|
12 |
Missouri |
St. Louis |
314,507 |
19.13 |
|
|
13 |
South Carolina |
Dillon |
6,648 |
19.10 |
|
|
14 |
Georgia |
College Park |
14,724 |
18.95 |
|
|
15 |
Alabama |
Alexander City |
14,695 |
18.85 |
|
|
16 |
South Carolina |
Lake City |
6,809 |
18.80 |
|
|
17 |
Arkansas |
West Memphis |
24,818 |
18.58 |
|
|
18 |
Louisiana |
Alexandria |
47,936 |
18.42 |
|
|
19 |
Michigan |
Muskegon Heights |
10,785 |
18.36 |
|
|
20 |
Tennessee |
Memphis |
656,434 |
18.20 |
|
|
21 |
North Carolina |
Lumberton |
21,683 |
18.12 |
|
|
22 |
Alabama |
Selma |
19,283 |
18.05 |
|
|
23 |
Michigan |
Benton Harbor |
9,963 |
17.97 |
|
|
24 |
Maryland |
Baltimore |
618,385 |
17.80 |
|
|
25 |
Delaware |
Wilmington |
72,183 |
17.80 |
|
|
26 |
Texas |
Robstown |
11,596 |
17.42 |
|
|
27 |
Michigan |
Highland Park |
10,810 |
17.39 |
|
|
28 |
New Mexico |
Gallup |
23,528 |
17.26 |
|
|
29 |
New Mexico |
Belen |
7,127 |
17.12 |
|
|
30 |
Alabama |
Prichard |
22,299 |
17.00 |
|
|
31 |
Missouri |
Bel-Ridge |
2,719 |
16.92 |
|
|
32 |
South Carolina |
Myrtle Beach |
31,864 |
16.88 |
|
|
33 |
Tennessee |
Brownsville |
9,795 |
16.85 |
|
|
34 |
Missouri |
Pine Lawn |
3,447 |
16.83 |
|
|
35 |
Missouri |
Kansas City |
478,364 |
16.55 |
|
|
36 |
Ohio |
Cleveland |
386,227 |
16.31 |
|
|
37 |
Michigan |
Ecorse |
9,213 |
16.17 |
|
|
38 |
Alabama |
Lanett |
6,451 |
16.12 |
|
|
39 |
Arkansas |
Pine Bluff |
43,976 |
16.03 |
|
|
40 |
Florida |
Belle Glade |
18,405 |
16.03 |
|
|
41 |
Michigan |
Flint |
97,548 |
15.84 |
|
|
42 |
South Carolina |
Camden |
7,132 |
15.70 |
|
|
43 |
Alabama |
Scottsboro |
14,711 |
15.57 |
|
|
44 |
West Virginia |
Charleston |
49,429 |
15.52 |
|
|
45 |
Wisconsin |
Milwaukee |
600,193 |
15.33 |
|
|
46 |
Arkansas |
Little Rock |
198,800 |
15.31 |
|
|
47 |
Louisiana |
Opelousas |
16,557 |
15.10 |
|
|
48 |
Indiana |
Elkhart |
52,505 |
15.07 |
|
|
49 |
Alabama |
Boaz |
9,729 |
15.01 |
|
|
50 |
Texas |
Bellmead |
10,212 |
14.88 |
