I attached the Excel file with the information for this assignment.Thank you. 
Option 2: World Populations
Instructions
Today there are 195 sovereign countries in the world that are officially recognized. One can choose to look at many types of data coming from these countries, as there is a plethora of existing information. For this assignment you will be looking at populations of cities within Italy at five different times (depending on when a census was taken). The data for these cities can be found in the file named Populations. Use all of the data points for each of the years given, but please note that not every city has a population for each census.
Prepare a report (see below) using the numerical methods of descriptive statistics presented in this module to show how the populations of the cities vary over the years (growth rates). Be sure to include the following three (3) items in your report.

Compute descriptive statistics for each of the years along with an explanation of what the descriptive statistics tell us about the different years. Are they continually growing, or is there a decrease in the number of people? The descriptive statistics will include the mean, mode, range, standard deviation, and the 5-number summary (minimum, first quartile (Q1), median (Q2), third quartile (Q3), and maximum).
Determine which cities, if any, should be considered outliers in each of the years? If there are any outliers in any year, please list them and state for which year each one is an outlier. Use the z-score method to determine outliers for this question showing the z-score calculations for each city and year in your spreadsheet.
Determine the correlation coefficient between the first year and each of the other years. Please provide an explanation of the relationships. Show your calculations for each correlation coefficient within the spreadsheet.Poland
Cities
Name
Aleksandrów Łódzki
Andrychów
Augustów
Bartoszyce
Będzin
Bełchatów
Biała Podlaska
Białogard
Białystok
Bielawa
Bielsko-Biała
Bielsk Podlaski
Bieruń
Biłgoraj
Bochnia
Bolesławiec
Brodnica
Brzeg
Bydgoszcz
Bytom
Chełm
Chełmno
Chodzież
Chojnice
Chorzów
Chrzanów
Ciechanów
Cieszyn
Czechowice-Dziedzice
Czeladź
Czerwionka-Leszczyny
Częstochowa
Dąbrowa Górnicza
Dębica
Działdowo
Dzierżoniów
Elbląg
Ełk
Gdańsk
Gdynia
Population
Population
Administrative Regions
31/Dec/1980
31/Dec/1992
17,000
20,251
LOD
19,400
23,144
MAL
24,300
29,089
POD
20,700
25,694
WAR
75,000
64,117
SLA
27,700
58,314
LOD
39,600
55,065
LUB
22,500
24,437
ZAC
224,200
274,095
POD
32,300
34,851
DOL
163,800
179,689
SLA
20,700
26,605
POD
21,830
SLA

20,600
25,991
LUB
24,400
29,245
MAL
39,800
44,573
DOL
22,000
26,953
KUJ
35,800
39,396
OPO
348,600
383,568
KUJ
234,300
229,243
SLA
53,000
68,023
LUB
19,700
21,777
KUJ
18,300
20,335
WIE
32,000
39,436
POM
150,100
128,832
SLA
35,600
42,125
MAL
33,800
45,054
MAZ
33,900
36,937
SLA
31,500
35,607
SLA
35,400
36,995
SLA
26,200
29,919
SLA
234,700
259,556
SLA
141,400
131,552
SLA
33,900
48,042
PDK
15,400
20,473
WAR
36,300
38,428
DOL
110,200
127,324
WAR
38,200
53,804
WAR
456,700
461,680
POM
236,400
250,171
POM
Giżycko
Gliwice
Głogów
Gniezno
Goleniów
Gorlice
Gorzów Wielkopolski
Gostyń
Gostynin
Grajewo
Grodzisk Mazowiecki
Grudziądz
Gryfino
Hajnówka
Iława
Inowrocław
Jarocin
Jarosław
Jasło
Jastrzębie-Zdrój
Jawor
Jaworzno
Jelenia Góra
Józefów
Kalisz
Kamienna Góra
Katowice
Kędzierzyn-Koźle
Kętrzyn
Kielce
Kłodzko
Kluczbork
Knurów
Kobyłka
Koło
Kołobrzeg
Konin
Końskie
Kościan
Kościerzyna
Koszalin
Kozienice
Kraków [Krakow]
Kraśnik
Krasnystaw
Krosno
Krotoszyn
WAR
SLA
DOL
WIE
ZAC
MAL
LBU
WIE
MAZ
POD
MAZ
KUJ
ZAC
POD
WAR
KUJ
WIE
PDK
PDK
SLA
DOL
SLA
DOL
MAZ
WIE
DOL
SLA
OPO
WAR
SWI
DOL
OPO
SLA
MAZ
WIE
ZAC
WIE
SWI
WIE
POM
ZAC
MAZ
MAL
LUB
LUB
PDK
WIE

24,100
197,500
53,700
62,400
19,100
23,800
105,900
15,700
16,000
15,800
23,300
90,100
15,300
19,200
23,500
66,100
21,200
36,000
30,300
98,500
18,700
89,300
86,900
14,600 …
98,900
22,400
355,100
69,700
26,200
185,300
29,200
21,800
40,800

19,600
38,200
67,700
18,300
21,400
18,700
93,500
16,200
715,700
31,200
16,900
39,100
24,200
29,558
214,389
73,384
70,630
22,248
29,872
124,551
20,268
20,013
22,057
24,833
103,438
21,680
24,179
32,179
79,051
25,663
41,865
38,498
104,202
25,386
98,474
93,013
106,551
23,606
359,887
70,991
30,266
213,651
30,835
26,800
44,729
23,581
46,152
81,460
21,907
24,392
22,930
110,793
21,377
744,032
36,897
20,298
49,380
28,414
Kutno
Kwidzyn
Łaziska Górne
Lębork
Łęczna
Legionowo
Legnica
Leszno
Łódź [Lodz]
Łomża
Łowicz
Lubań
Lubartów
Lubin
Lublin
Lubliniec
Luboń
Łuków
Malbork
Marki
Mielec
Mikołów
Mińsk Mazowiecki
Mława
Mrągowo
Mysłowice
Myszków
Nakło nad Notecią
Nowa Ruda
Nowa Sól
Nowy Dwór Mazowiecki
Nowy Sącz
Nowy Targ
Nysa
Oława
Oleśnica
Olkusz
Olsztyn
Opoczno
Opole
Orzesze
Ostróda
Ostrołęka
Ostrowiec Świętokrzyski
Ostrów Mazowiecka
Ostrów Wielkopolski
Oświęcim
LOD
POM
SLA
POM
LUB
MAZ
DOL
WIE
LOD
POD
LOD
DOL
LUB
DOL
LUB
SLA
WIE
LUB
POM
MAZ
PDK
SLA
MAZ
MAZ
WAR
SLA
SLA
KUJ
DOL
LBU
MAZ
MAL
MAL
OPO
DOL
DOL
MAL
WAR
LOD
OPO
SLA
WAR
MAZ
SWI
MAZ
WIE
MAL
41,400
32,600
19,300
29,200
5,800
39,700
89,600
49,200
835,700
40,800
25,200
21,200
16,500
67,100
304,400
22,300
19,700
24,700
34,400
15,900 …
43,100
33,300
28,700
23,100
17,100
79,800
25,500
19,900
25,400
38,500
22,300
64,100
28,000
41,700
29,200
33,100
28,700
133,300
15,500
116,700
18,000 …
28,500
38,000
65,100
17,500
62,500
44,900
50,940
37,667
23,011
35,882
21,150
50,617
106,579
60,168
838,367
61,527
31,040
24,265
23,063
82,794
350,377
26,356
20,360
31,676
40,237
63,661
36,928
34,468
29,776
22,231
93,140
33,925
20,145
27,313
43,102
26,948
80,482
33,413
48,540
31,707
38,618
40,478
164,882
21,354
129,554
34,911
52,383
79,328
21,333
74,075
44,874
Otwock
Ozorków
Pabianice
Piaseczno
Piastów
Piekary Śląskie
Piła
Pionki
Piotrków Trybunalski
Płock
Płońsk
Police
Polkowice
Poznań
Prudnik
Pruszcz Gdański
Pruszków
Przemyśl
Pszczyna
Puławy
Pyskowice
Racibórz
Radom
Radomsko
Rawicz
Reda
Ruda Śląska
Rumia
Rybnik
Rydułtowy
Rzeszów
Sandomierz
Sanok
Siedlce
Siemianowice Śląskie
Sieradz
Skarżysko-Kamienna
Skawina
Skierniewice
Słupsk
Sochaczew
Sopot
Sosnowiec
Śrem
Środa Wielkopolska
Stalowa Wola
Starachowice
MAZ
LOD
LOD
MAZ
MAZ
SLA
WIE
MAZ
LOD
MAZ
MAZ
ZAC
DOL
WIE
OPO
POM
MAZ
PDK
SLA
LUB
SLA
SLA
MAZ
LOD
WIE
POM
SLA
POM
SLA
SLA
PDK
SWI
PDK
MAZ
SLA
LOD
SWI
MAL
LOD
POM
MAZ
POM
SLA
WIE
WIE
PDK
SWI
47,400
19,500
70,500
23,000
20,400
64,300
58,900
17,200
72,100
102,600
16,200
24,800
18,000
552,900
22,500
18,500
49,300
61,300
35,900
46,000
20,400
55,500
191,100
40,400
19,000

43,201
21,936
76,014
24,468
23,524
67,743
74,433
21,791
81,320
125,005
22,273
33,631
21,185
582,919
24,510
21,093
52,944
68,304
34,073
54,286
21,924
64,327
230,374
50,901
21,412

159,100
26,700
122,700

121,300
20,500
30,800
54,800
77,100
31,300
43,700
21,200
32,400
86,100
32,000
51,300
246,100
21,900
17,400
54,800
49,000
167,685
38,379
143,125
24,075
156,739
26,390
41,020
72,963
79,631
43,821
51,341
23,904
47,188
102,036
39,420
44,978
251,279
28,912
21,073
71,173
57,285
Stargard Szczeciński
Starogard Gdański
Strzelce Opolskie
Suwałki
Swarzędz
Świdnica
Świdnik
Świebodzice
Świebodzin
Świecie
Świętochłowice
Świnoujście
Szczecin
Szczecinek
Szczytno
Tarnobrzeg
Tarnów
Tarnowskie Góry
Tczew
Tomaszów Lubelski
Tomaszów Mazowiecki
Toruń
Trzebinia
Turek
Tychy
Wągrowiec
Wałbrzych
Wałcz
Warszawa [Warsaw]
Wejherowo
Wieliczka
Wieluń
Włocławek
Wodzisław Śląski
Wołomin
Wrocław
Września
Wyszków
Ząbki
Zabrze
Żagań
Zakopane
Zambrów
Zamość
Żary
Zawiercie
Zduńska Wola
ZAC
POM
OPO
POD
WIE
DOL
LUB
DOL
LBU
KUJ
SLA
ZAC
ZAC
ZAC
WAR
PDK
MAL
SLA
POM
LUB
LOD
KUJ
MAL
WIE
SLA
WIE
DOL
ZAC
MAZ
POM
MAL
LOD
KUJ
SLA
MAZ
DOL
WIE
MAZ
MAZ
SLA
LBU
MAL
POD
LUB
LBU
SLA
LOD
59,200
72,191
44,200
50,130
19,700
21,900
40,700
63,913
14,800
24,278
56,900
64,300
32,000
40,072
22,800
24,726
18,400
22,506
22,400
26,806
58,700
60,234
47,100
43,252
388,300
416,402
35,700
41,979
23,200
27,167
37,300
49,982
105,100
121,894
66,700
76,920
53,600
59,860
16,300
20,767
63,400
69,868
174,400
201,806
20,300 …
23,500
30,198
166,600
136,643
19,200
23,789
133,500
140,595
22,800
26,549
1,596,100
1,644,515
42,400
47,266
17,100 …
18,300
25,238
106,800
122,309
105,500
88,368
30,900
36,359
617,700
640,663
23,500
28,375
16,600
24,532
17,300 …
196,000
203,524
23,900
28,050
28,800
28,257
17,400
23,047
46,800
64,279
35,400
40,814
62,600
56,521
39,000
45,754
Zgierz
Zgorzelec
Zielona Góra
Żory
Żyrardów
Żywiec
LOD
DOL
LBU
SLA
MAZ
SLA
53,100
33,300
101,100
47,500
37,200
28,300
59,004
36,500
115,134
66,188
43,499
32,159
Population
Population
Population
20/May/2002 31/Mar/2011 31/Dec/2013
20,220
21,085
21,245
22,187
21,530
21,111
29,705
30,802
30,610
25,771
25,022
24,527
59,210
59,069
58,425
63,122
60,485
59,565
58,311
58,009
57,658
24,544
24,919
24,722
291,383
294,001
295,282
32,017
31,699
31,186
178,028
174,534
173,699
27,115
26,679
26,336
20,094
19,876
19,696
26,380
27,291
27,169
29,388
30,187
30,219
41,579
40,209
39,603
27,252
28,416
28,579
39,023
37,438
36,980
373,804
363,926
359,428
193,546
176,902
173,439
68,909
66,362
65,481
20,655
20,934
20,622
19,750
19,715
19,399
39,448
40,447
40,226
117,430
111,692
110,761
40,880
38,829
38,117
46,452
45,481
44,797
36,640
36,248
35,918
35,151
35,445
35,684
34,957
33,745
32,940
28,956
28,626
28,480
251,436
236,796
232,318
132,236
125,905
123,994
47,678
47,217
46,854
20,777
21,619
21,552
35,437
34,952
34,428
128,134
124,668
122,899
55,224
59,044
59,790
461,334
460,276
461,531
253,458
249,139
248,042
29,735
203,814
70,490
70,029
22,421
29,005
125,914
20,708
19,577
22,898
25,802
100,376
21,928
22,545
32,544
77,986
25,897
40,235
37,916
97,116
24,762
96,826
89,339
16,869
109,498
21,984
327,222
67,097
28,743
212,429
29,173
26,595
40,584
17,110
23,552
44,947
82,353
21,338
24,098
23,105
108,709
19,036
758,544
36,648
19,748
48,372
29,351
30,178
187,474
69,608
70,322
22,869
28,819
124,534
20,318
19,344
22,521
29,363
98,726
21,700
22,274
33,321
76,086
26,324
39,857
37,071
92,465
24,340
94,732
83,860
19,476
105,386
20,734
310,764
64,153
28,466
202,196
28,750
24,962
39,595
19,940
23,360
47,129
78,525
20,920
24,194
23,765
109,248
18,682
757,611
36,370
19,692
47,471
29,627
29,947
185,450
68,997
69,883
22,776
28,415
124,344
20,183
19,092
22,246
29,907
97,676
21,578
21,559
33,338
75,001
26,311
39,138
36,363
91,235
23,937
93,708
81,985
19,914
103,997
20,014
304,362
63,194
28,051
199,870
27,997
24,544
39,090
20,855
23,026
46,897
77,224
20,281
24,011
23,701
109,170
18,277
758,992
35,788
19,539
47,223
29,397
48,741
37,439
22,070
35,252
22,166
50,420
107,100
63,660
789,318
63,936
30,735
22,852
23,166
78,544
357,110
24,601
24,726
30,819
38,545
21,032
61,728
38,096
36,341
29,422
22,074
75,712
33,235
19,699
25,071
41,176
27,361
84,477
33,034
48,145
31,154
37,276
38,173
173,102
22,589
129,946
18,667
33,769
54,238
75,639
22,431
73,568
41,946
46,429
38,632
22,279
35,789
20,703
53,526
103,238
64,630
728,892
63,203
29,880
22,301
22,773
75,357
349,103
24,394
29,832
31,040
39,387
27,066
61,549
39,505
39,347
30,859
22,324
75,446
32,817
19,542
23,896
40,369
28,156
84,290
33,812
45,681
31,847
37,118
37,319
174,645
22,583
122,625
19,539
34,060
53,572
73,681
22,842
72,810
40,342
45,657
38,867
22,460
35,526
19,926
54,231
101,992
64,589
711,332
62,711
29,420
21,921
22,543
74,053
343,598
24,316
30,676
30,757
39,022
29,032
61,096
39,776
39,880
30,880
22,190
75,129
32,619
19,193
23,236
39,721
28,287
83,943
33,672
44,899
32,240
37,303
36,724
174,675
22,188
120,146
20,000
33,963
52,917
72,277
22,796
72,890
39,664
42,621
21,022
72,974
33,031
23,510
60,909
75,074
20,387
80,979
128,361
22,245
34,522
21,869
578,886
23,681
22,724
54,505
68,095
25,774
50,607
19,574
59,495
229,699
49,861
21,466
17,468
150,595
43,697
142,731
22,047
160,376
25,633
40,039
76,656
74,269
44,636
50,464
23,812
48,537
99,943
38,365
41,927
232,622
30,394
21,596
67,555
54,615
44,808
20,507
69,177
42,378
22,966
57,917
74,775
19,840
76,717
124,553
22,565
34,036
22,802
554,696
22,256
27,787
58,144
65,000
26,066
49,941
18,770
56,289
221,287
48,362
21,183
21,579
142,510
46,714
140,924
22,070
179,386
24,894
39,511
76,333
70,170
43,903
48,580
24,253
48,622
95,882
38,141
38,690
216,420
30,343
22,325
65,182
52,359
45,044
20,175
67,688
44,869
22,826
57,148
74,609
19,382
75,903
122,815
22,494
33,625
22,638
548,028
21,778
28,858
59,570
63,638
25,999
49,100
18,642
55,930
218,466
47,643
20,846
23,135
141,521
47,374
140,173
21,847
183,108
24,552
39,027
76,347
68,844
43,356
47,538
24,260
48,634
93,936
37,480
37,903
211,275
30,152
22,572
63,692
51,158
71,367
49,037
20,839
68,923
28,486
61,342
40,187
23,540
21,922
25,975
56,410
41,796
415,399
39,328
26,419
50,287
119,913
62,393
59,857
20,462
67,554
211,243
19,172
29,909
132,816
24,350
130,268
26,476
1,689,201
44,989
18,228
24,645
121,229
49,784
36,483
640,367
28,631
26,511
21,866
195,293
26,781
28,203
23,009
67,160
39,421
54,037
45,056
69,966
49,191
18,868
69,239
30,928
60,437
40,710
23,292
22,166
26,650
53,150
41,480
410,131
40,787
25,254
48,821
114,053
60,847
60,889
20,518
65,998
204,954
20,392
29,059
129,378
25,327
120,715
26,435
1,700,612
49,922
20,559
24,033
116,783
49,346
37,397
630,131
29,526
27,312
28,857
181,128
26,791
27,857
22,812
65,966
39,365
52,091
44,213
69,328
48,621
18,451
69,317
31,084
59,182
40,225
23,152
22,064
26,395
51,824
41,371
408,172
40,620
24,489
48,217
112,120
60,957
60,610
19,983
64,893
203,447
20,302
28,100
128,799
25,178
117,926
26,231
1,724,404
50,340
21,318
23,546
114,885
48,731
37,505
632,067
29,552
27,222
31,884
178,357
26,492
27,721
22,451
65,255
38,856
51,258
43,615
58,393
33,799
118,293
63,461
41,734
32,048
58,306
32,525
118,982
62,094
41,574
32,448
57,503
31,890
118,405
62,038
41,096
32,083

Purchase answer to see full
attachment




Why Choose Us

  • 100% non-plagiarized Papers
  • 24/7 /365 Service Available
  • Affordable Prices
  • Any Paper, Urgency, and Subject
  • Will complete your papers in 6 hours
  • On-time Delivery
  • Money-back and Privacy guarantees
  • Unlimited Amendments upon request
  • Satisfaction guarantee

How it Works

  • Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
  • Fill in your paper’s requirements in the "PAPER DETAILS" section.
  • Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
  • Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
  • From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.