From the following data, check the correlation of ‘Migrants person’ (Migration form Urban areas of J & K to another urba

[answerhappygod]

From the following data, check the correlation of ‘Migrantsperson’ (Migration form Urban areas of J & K to another urbanareas of J &K) with the below given variables. Write yourconclusion with respect to the correlation coefficient and ScatterDiagram.
Draw the scatter plot (you may use EXCEL, SPSS, Python, Retc.)
Perform the correlation for the following pairs ofvariables
Migrant person numbers V/s ‘Number of Factory/Workshop/Work shedetc.’
Migrant person number V/s ‘Number of commercialestablishments’
Migrant person number V/s ‘Number of towns’
Migrant person number V/s ‘Population per sq. km.’
(Note: no need to calculate correlation coefficient manually,use EXCEL formula, or any other software) (Note regarding the dataaccess: You can copy the data from this pdf document and paste itinto your EXCEL workbook; you may have to work on alignment if itis distorted in Excel.)
Data for the analysis
Districts
Migrant person numbers
Number of Factory/ Workshop/ Workshed etc.
Number ofcommercial establishments
Number oftowns
Population per sq. km.
Kupwara
2667
188
6571
10
2212
Badgam
5370
273
5552
9
1996
Leh(Ladakh)
2621
176
3898
3
1902
Kargil
650
61
1711
1
7635
Punch
2038
67
3605
3
1604
Rajouri
4011
236
4656
4
2390
Kathua
11306
504
6952
6
2079
Baramula
19382
663
12171
7
2871
Bandipore
4866
156
3258
3
1317
Srinagar
94844
3575
47986
5
4141
Ganderbal
3041
231
2418
3
1852
Pulwama
7939
257
4885
5
2087
Shupiyan
1700
30
1673
1
3007
Anantnag
13545
919
14079
12
2880
Kulgam
2621
243
3902
7
1619
Doda
2297
76
3016
2
1655
Ramban
1171
41
1768
3
783
Kishtwar
569
45
1765
1
23595
Udhampur
10873
549
6795
6
2475
Reasi
2085
28
3677
5
692
Jammu
139422
2410
46539
20
3034
Samba
5349
685
5162
6
1383