Business Analytics

NOTE: ONLY ASSIGNMENT 1 HAS TO BE DONE.

Business Analytics
1

Contents
Introduction......................................................................................................................................3
MAIN BODY..................................................................................................................................3
Question 1....................................................................................................................................3
Question 2....................................................................................................................................4
Question 3....................................................................................................................................5
Question 4....................................................................................................................................7
CONCLUSION................................................................................................................................9
REFERENCES..............................................................................................................................10
2

Introduction
In present time, it is very important to implement best analytic process for every kind of
business in order to evaluate the trends and patterns within the industry and also determine the
overall performance of different internal operation (Cocârţă, Stoian and Karademir, 2017).
Business analytic help in recognising the best possible business activities which can be profitable
in future also as well as it also supports to make certain plans for reducing the reasons for non-
profitable activity. In this report, different questions are analysed with the help of excel and
different concepts are covered such as breakeven point, one way and two way Anova,
recommendation to student regarding Covid-19 virus, data screening and interpreting and
descriptive analysis.
MAIN BODY
Question 1
A) Breakeven point:
Fixed cost £100
Variable cost £0.40
Units to be sold 500
Selling price £1
Contribution per unit
Selling price-variable cost per
unit
0.6
BEP (in units) Fixed cost/contribution per unit
Pens to be sold 166.67
B) One-way table:
Estimated units to be
sold
Pric
e
Sales
revenue
Fixed
cost
Variable cost per
unit
Variable
cost
Prof
it
400 3 1200 350 0.5 200 650
450 3 1350 350 0.5 225 775
520 3 1560 350 0.5 260 950
350 3 1050 350 0.5 175 525
260 3 780 350 0.5 130 300
C) Two-way table:
Estimated units to be
sold
Pric
e
Sales
revenue
Fixed
cost
Variable cost per
unit
Variable
cost
Prof
it
3

400 5 2000 500 0.4 160
134
0
490 5 2450 500 0.6 294
165
6
290 5 1450 500 0.7 203 747
350 5 1750 500 0.5 175
107
5
260 5 1300 500 0.8 208 592
D) Graph
1 2 3 4 5
0
100
200
300
400
500
600
700
800
900
1000
350 350 350 350 350
200 225 260
175 130
650
775
950
525
300
Chart Title
Fixed cost Variable cost Profit
Question 2
A) Sample and pollution size.
In the presented data, there have been 200 total observations those are respective student of listed
UK universities, they all are consumer of Ryanaires and have been travelling to their specific
destination. The main reason for their traveling is fear of getting infected due to Covid-19 as they
all are worried of getting sick if they were in contact of any other person. In order to collect the
accurate data, student was provided with a score rating number on their email ID which they use
for booking. The total number which each student give reflects the proportion of fear they are
because of Covid-19 and the be safe they want to travel their home as early as possible. This is
very useful data which is collected by primary means and will give a proper understanding about
the student awareness regarding Covid-19 impact. A benefit using primary data would be that
scientists are gathering knowledge for the specific audiences of their analysis. In general, the
questions posed by the investigators are designed to extract the knowledge that will assist them
throughout their research (Corbett and Mellouli, 2017).
4

B) Type of Graph.
Bar graph: A bar chart is a chart consisting uses rectangular columns (named bins) to large
datasets reflecting the cumulative number of findings within that segment in the data. Vertical
columns, diagonal bars, quantitative bars (several bars to show a distinction of values), or
layered bars will show bar graphs (bars containing multiple types of information). The aim of a
bar chart is to easily communicate relational knowledge as the quantities for a given group is
displayed by the lines. The vertical dimension including its bar graph is considered the y-axis,
whereas the x-axis is named the top of the bar chart. In order to compare the data or the
responses of two groups men and women bar chart can be most useful chart which help in clearly
showing the responses of these group regarding a specific topic. Form the collected data of
students it is assumed that there were total 80 females and 120 males, in order to show their
responses a specific bar chart is prepared. The same is displayed below:
male Female
0
20
40
60
80
100
120
140
120
80
Chart Title
Question 3
A) Data type: In the respective data set for all the variables there is a specific data type such
as:
Household ID: Categorical (Ordinal)
Family size: Numerical (ratio)
Location: Categorical (Nominal)
Ownership: Categorical (Ordinal)
First Income: Numerical (regular)
5

Second Income: Numerical (interval)
Monthly Payment: Numerical (regular)
Utilities: Numerical (ratio)
Debt: Numerical (ratio)
B) Categorical variables:
From the data set, it is determined that Household ID, Location and Ownership are variables
which have certain kind of categories (Gao, Chen and Yuan, 2017). Furthermore, they are also
segmented into ordinal and nominal categories such as household ID and ownership is ordinal
and location is nominal. It is observed that the data is divided in the respective manner as this
data form is descriptive, often obtained using survey questions, since often it gives participants
the right to type answers. While this trait tends to arrive at clearer conclusions, investigators
often have difficulties when they have to work with too much random knowledge. Although
mainly categorised as categorical data, also categorical and numerical data features are said to be
present, rendering it in between. Its designation as structured variable relates to the fact that it
may have certain normative data characteristics. Likert size, interval scale, bug intensity,
customer satisfaction information, etc. are some ordinary data instances. Each of these examples
is a
C) Histogram
6

D) Debt level
The maximum debt level from the collected data is $9,104 and the Household ID is 301. The
minimum debt level is $227 and the household ID for the same is 127.
E) Indebtedness level
The level of in-debtedness at specific quartile is as follows:
25th: 2968.75
50th: 4271.5
75th: 5676.5
F) Interquartile range interpretation:
7

The above determined quartile values for 25th is 2968.75 which states that it is the value of 1st
quarter of the data. The value of 50th quartile is 42.71.5 which define the average value of the 2nd
quarter of the collected data. The 70th quartile value of is 5656.5 which shows the mean value of
3rd quarter of the total number of observation (Huysegoms and Cappuyns, 2017).
Question 4
A) Descriptive analysis for Gross sales:
Column1
Mean
17189484.2
6
Standard Error
1746820.55
2
Median 411184
Mode #N/A
Standard
Deviation
42537860.1
9
Sample
Variance
1.80947E+1
5
Kurtosis
22.5515154
3
Skewness
4.16624022
2
Range 380995484
Minimum 15735
Maximum 381011219
Sum
1019336416
6
Count 593
Descriptive analysis for number of ticket sold:
Column1
Mean 2159483
Standard Error
219449.
8
Median 51656
Mode 5749
Standard
Deviation 5343952
Sample
Variance
2.86E+1
3
Kurtosis 22.5515
8

2
Skewness 4.16624
Range
4786375
4
Minimum 1977
Maximum
4786573
1
Sum
1.28E+0
9
Count 593
b) Cross tabulation table
crosstabulation between genre and movie classification rating
9

Regression Statistics
Multiple R 1
R Square 1
Adjusted R
Square 1
Standard
Error
2.382089
7
Observations 593
ANOVA
df SS MS F
Significan
ce F
Regressi
on 1
1.07E+1
8
1.07E+1
8
1.89E+1
7 0
Residual 591
3353.54
2
5.67435
1
Total 592
1.07E+1
8
Coeffici
ents
Standard
Error t Stat
P-
value
Lower
95%
Upper
95%
Lower
95.0%
Upper
95.0%
Intercept
0.17238
5 0.105518 1.6337
0.102
855
-
0.03485
0.37962
1 -0.03485 0.379621
X
Variable
1 7.96 1.83E-08
4.34E
+08 0 7.96 7.96 7.96 7.96
Observat
ion
Predict
ed Y
Residu
als
Standa
rd
Residu
als
1
381011
218
1.3035
05
0.5476
73
2
352390
544
-
1.2693
3
-
0.5333
2
3
276125
474
1.9232
86
0.8080
77
4
254464
308
-
3.2269
8
-
1.3558
3
5
241063
871
3.8495
56
1.6174
08
6 210031 - -
10

326 0.6911
0.2903
7
7
191450
871
4.1286
26
1.7346
61
8
181030
626
-
1.9451
7
-
0.8172
7
9
176760
181
3.5209
74
1.4793
53
10
176654
505
0.4806
31
0.2019
39
11
169499
547
-
1.1025
8
-
0.4632
5
12
169211
721
-
3.4635
1
-
1.4552
1
13
165249
066
-
3.3163
7
-
1.3933
9
14
146408
304
1.4225
21
0.5976
79
15
145738
326
0.7003
48
0.2942
54
16
143619
812
-
3.1065
2
-
1.3052
2
17
142614
162
-
3.6297
9
-
1.5250
7
18
141186
647
-
1.0744
2
-
0.4514
2
19
136910
217
2.3117
12
0.9712
76
20
127004
180
-
0.8004
2
-
0.3363
21
123477
605
1.7081
4
0.7176
83
22
117538
562
-
2.7511
2
-
1.1559
23
116601
168
3.7258
35
1.5654
26
24 115865 - -
11

051
3.3565
5
1.4102
7
25
109946
966
0.5042
51
0.2118
63
26
108085
306
-
0.5817
9
-
0.2444
4
27
104007
827
0.5649
86
0.2373
81
28
103028
111
-
1.6381
9
-
0.6882
9
29
100368
563
-
3.2068
2
-
1.3473
6
30
100292
856
0.3529
36
0.1482
88
31
999676
74
-
3.7281
2
-
1.5663
9
32
987800
42
0.2680
29
0.1126
13
33
978481
17
-
2.7749
9
-
1.1659
3
34
845726
20
3.1419
44
1.3201
02
35
844932
43
-
1.7383
1
-
0.7303
6
36
843511
97
0.4612
26
0.1937
86
37
835610
71
1.9786
63
0.8313
44
38
835524
26
2.5386
35
1.0666
19
39
826994
33
-
0.8641
3
-
0.3630
7
40
803608
64
1.5282
82
0.6421
15
41
792494
57
-
2.4353
2
-
1.0232
1
42 768022
27
-
2.0832
-
0.8752
12

6 9
43
756580
96
0.5130
28
0.2155
51
44
750160
59
0.1909
45
0.0802
27
45
730139
12
-
1.8555
5
-
0.7796
2
46
720159
67
2.3412
14
0.9836
71
47
717500
39
-
1.9796
5
-
0.8317
6
48
706622
17
2.5768
23
1.0826
64
49
682244
52
0.4889
15
0.2054
2
50
636864
00
-
2.8058
-
1.1788
7
51
624956
47
-
2.4896
7
-
1.0460
4
52
609658
63
3.1453
71
1.3215
42
53
599509
55
-
1.8979
2
-
0.7974
2
54
591468
83
3.5394
7
1.4871
24
55
587097
20
-
3.2619
5
-
1.3705
2
56
580092
00
-
0.4642
2
-
0.1950
4
57
563777
35
-
2.7895
1
-
1.1720
3
58
558027
52
1.8486
23
0.7767
07
59
551004
33
3.6063
45
1.5152
22
60
547122
24
2.8050
86
1.1785
69
61 540091 0.7628 0.3204
13

49 05 96
62
533452
85
1.7606
52
0.7397
46
63
526985
35
-
0.2414
5
-
0.1014
4
64
516705
09
2.7952
19
1.1744
24
65
514004
50
-
0.2856
6
-
0.1200
2
66
503134
96
-
1.3691
8
-
0.5752
7
67
484752
94
-
3.5751
5
-
1.5021
1
68
472578
20
3.4609
06
1.4541
15
69
472281
53
3.3808
09
1.4204
62
70
460731
65
-
1.5829
4
-
0.6650
8
71
458624
08
2.3363
79
0.9816
4
72
450607
32
1.8137
79
0.7620
67
73
444909
95
3.8119
31 1.6016
74
440897
87
-
1.3093
7
-
0.5501
4
75
438534
23
0.9298
63
0.3906
86
76
425876
40
3.2057
57
1.3469
13
77
408507
92
-
3.6798
8
-
1.5461
2
78
407579
22
-
3.3601
8
-
1.4117
9
79
403156
65
0.2383
87
0.1001
59
80 402591 2.0782 0.8731
14

17 04 67
81
390464
91
-
1.5257
3
-
0.6410
4
82
385363
74
2.0726
16
0.8708
19
83
381809
28
-
0.0885
4
-
0.0372
84
379154
14
-
0.3294
-
0.1384
85
376621
59
3.0297
8
1.2729
76
86
374129
47
-
2.2910
3
-
0.9625
9
87
373001
06
0.6686
06
0.2809
18
88
372953
94
-
0.0114
1
-
0.0047
9
89
372434
15
2.7884
22
1.1715
68
90
370764
14
0.5878
8 0.247
91
370539
27
-
3.4121
9
-
1.4336
5
92
366658
54
0.4665
48
0.1960
22
93
366508
33
-
2.0135
-
0.8459
8
94
363924
99
2.8256
62
1.1872
14
95
356082
48
-
3.1368
8
-
1.3179
8
96
350141
93
-
1.3388
1
-
0.5625
1
97
349285
44
1.2609
13
0.5297
78
98
348401
88
3.2606
26
1.3699
67
99 344906 2.8994 1.2182
15

72 93 35
100
340883
58
2.2181
88
0.9319
82
101
330476
36
-
2.5451
9
-
1.0693
7
102
330354
01
-
4.0252
3
-
1.6912
2
103
329999
47
2.8146
57
1.1825
91
104
311775
45
3.0087
46
1.2641
38
105
291366
25
1.1221
26
0.4714
66
106
291215
01
-
2.8779
2
-
1.2091
7
107
280871
55
0.3987
22
0.1675
25
108
278655
72 -1.082
-
0.4546
1
109
268163
41
-
0.6054
-
0.2543
6
110
266928
49
-
3.1658
-
1.3301
3
111
251249
84
2.1091
13
0.8861
53
112
248272
24
3.8281
47
1.6084
13
113
248148
30
-
0.4518
9
-
0.1898
6
114
240466
82
-
0.4943
8
-
0.2077
2
115
232093
06
3.5828
99
1.5053
71
116
231867
72
-
2.6571
7
-
1.1164
2
117
215964
43
1.7376
68
0.7300
89
16

118
213927
55
3.1770
07
1.3348
34
119
213023
37
2.8167
14
1.1834
55
120
212950
22
-
0.9433
1
-
0.3963
4
121
203744
88
-
3.7463
-
1.5740
2
122
200991
75
3.7728
11
1.5851
63
123
194900
44
-
3.1891
6
-
1.3399
4
124
188771
56
-
3.0311
5
-
1.2735
5
125
182986
47
1.8869
7
0.7928
19
126
176869
29
-
0.0750
1
-
0.0315
2
127
174605
55
-
1.6357
5
-
0.6872
7
128
169999
33
0.6827
58
0.2868
64
129
154287
49
-
1.7223
4
-
0.7236
5
130
153247
51
3.6773
24
1.5450
44
131
151836
68
-
3.2831
3
-
1.3794
2
132
150136
51
-
0.6436
9
-
0.2704
5
133
142156
37
-
2.7662
7
-
1.1622
6
134
140110
81
3.3130
63
1.3919
98
135
138437
69
1.5525
2
0.6522
98
17

136
136571
15
-
0.4080
9
-
0.1714
6
137
133056
65
-
0.4892
3
-
0.2055
5
138
131098
18
-
2.6498
6
-
1.1133
5
139
129979
64
2.2697
77
0.9536
57
140
126692
56
-
3.5312
9
-
1.4836
9
141
124500
93 -2.852
-
1.1982
8
142
118623
98
-
0.0939
1
-
0.0394
6
143
115382
03
0.7850
42
0.3298
39
144
112426
56
3.6240
83
1.5226
75
145
107210
30
3.3823
91
1.4211
27
146
103244
39
2.4611
04
1.0340
44
147
101792
72
2.9806
34
1.2523
27
148
101437
78
0.6205
18
0.2607
14
149
101302
22
-
3.4995
3
-
1.4703
4
150
993626
1.2
-
3.1801
5
-
1.3361
6
151
965907
8.1
-
4.0610
5
-
1.7062
7
152
944628
3.4
1.6182
56
0.6799
18
153
893572
1
-
0.0234
-
0.0098
3
18

154
840670
7.4
3.6148
84
1.5188
1
155
790079
3.7
1.3332
43
0.5601
68
156
770643
4.3
1.6526
12
0.6943
53
157
769170
0.4
-
0.3874
4
-
0.1627
8
158
720413
4.5
3.5309
83
1.4835
58
159
694522
7.5
-
1.5098
6
-
0.6343
7
160
692806
5.7
2.2500
88
0.9453
84
161
690491
8.1
0.9300
13
0.3907
49
162
686109
8.3
3.7298
7
1.5671
22
163
579089
2.2
1.8063
99
0.7589
67
164
533614
5.4
-
1.3550
8
-
0.5693
4
165
530491
8.3
1.7248
23
0.7246
92
166
525418
9.2
-
2.1953
4
-
0.9223
8
167
517172
3.6
2.4043
91
1.0102
15
168
504434
7.7
-
3.6760
2
-
1.5445
169
503656
2.8
2.2039
52 0.926
170
494858
8.9
-
2.8763
3
-
1.2085
171
475235
1
2.0030
3
0.8415
82
172
446329
1.6
0.4420
93
0.1857
47
173
444460
9.4
2.5620
32
1.0764
49
19

174
436744
5.2
2.8017
82
1.1771
81
175
428018
7.7
-
1.6785
-
0.7052
3
176
422382
2.9
2.0813
16
0.8744
74
177
418740
5.9
2.0811
98
0.8744
25
178
403617
3.9
1.1207
07
0.4708
7
179
395464
7.6
3.4404
43
1.4455
17
180
374066
6.8
1.1597
49
0.4872
74
181
345008
7
-
0.0411
9
-
0.0173
1
182
337210
2.9
-
2.9214
5
-
1.2274
6
183
328872
9.9
-
3.8817
2
-
1.6309
2
184
317919
2.3
0.6779
27
0.2848
34
185
310365
9.9
-
3.8823
2
-
1.6311
7
186
304210
5.2
2.7974
83
1.1753
75
187
304105
4.5
-
2.4825
2
-
1.0430
4
188
303361
9.8
3.1574
55
1.3266
19
189
291343
9.8
3.2370
65
1.3600
68
190
271929
5.4
0.6364
36
0.2674
01
191
271213
1.4
-
0.3635
9
-
0.1527
6
192
252939
3.6
1.3558
2
0.5696
54
193 251750 - -
20

9.4
3.3642
2
1.4134
9
194
250915
1.4
-
1.3642
5
-
0.5731
9
195
243073
7.4
-
2.4045
-
1.0102
6
196
216726
1.4
-
3.4053
6
-
1.4307
8
197
210799
9.2
-
1.2055
5
-
0.5065
2
198
209445
9.2
-
3.2455
9
-
1.3636
5
199
203096
2.3
-
0.3258
-
0.1368
9
200
196587
3.4
0.5939
92
0.2495
68
201
195353
5.4
3.5939
52
1.5100
15
202
189193
3
3.0337
52
1.2746
44
203
184475
4
-
0.0464
-
0.0195
204
183438
2.2
1.8335
65
0.7703
81
205
179382
6
3.0334
34
1.2745
11
206
175925
5.7
-
3.6866
8
-
1.5489
7
207
170709
3.8
0.1931
52
0.0811
54
208
167120
2.2
-
0.1669
6
-
0.0701
5
209
161884
1.3
2.7128
66
1.1398
23
210
161243
3.5
-
3.4871
5
-
1.4651
4
211 159103 - -
21

7
3.0072
2 1.2635
212
157675
6.8
0.2327
3
0.0977
82
213
157487
8.2
2.7927
23
1.1733
75
214
156110
7.4
-
0.4073
2
-
0.1711
4
215
153259
4.7
-
0.6874
1
-
0.2888
2
216
151493
9.4
2.5925
29
1.0892
63
217
151002
8.1
-
2.0874
9
-
0.8770
7
218
148173
8.2
-
3.2475
8
-
1.3644
8
219
143024
5
-
4.0077
5
-
1.6838
7
220
140072
9.3
-
3.3278
4
-
1.3982
1
221
137397
5.8
-
0.7679
3
-
0.3226
5
222
136151
0.4
1.5920
31
0.6688
99
223
135281
0.1 -1.128
-
0.4739
3
224
135214
9.4
2.5520
01
1.0722
35
225
134820
1.3
3.7119
88
1.5596
08
226
133991
4.9
-
3.9280
4
-
1.6503
8
227
132119
3
0.9919
01
0.4167
51
228
130711
9.7
1.2718
55
0.5343
76
229 120004 - -
22

9.8
3.7684
9
1.5833
5
230
118819
7.3
-
3.3285
3
-
1.3985
231
118654
1.6
-
3.6485
4
-
1.5329
5
232
113125
9.4
1.5512
84
0.6517
79
233
112091
1.4
2.5512
51
1.0719
2
234
110303
3.3
3.7111
93
1.5592
74
235
109992
0.9
-
3.9288
2
-
1.6507
1
236
106933
0.6
3.3510
84
1.4079
73
237
106703
0.2
-
2.2089
2
-
0.9280
9
238
106617
0.5
-
3.5289
3
-
1.4826
9
239
106543
0.2
-
1.2489
3
-
0.5247
4
240
102417
3.6
1.4309
37
0.6012
15
241
100809
4.4
3.6308
85
1.5255
33
242
985909.
85
2.1508
13
0.9036
74
243
977774.
73
-
2.7292
1
-
1.1466
9
244
971239.
57
0.4307
65
0.1809
88
245
970817.
69
-
1.6892
4
-
0.7097
4
246
934949.
93
1.0706
48
0.4498
37
247 911157.
49
-
0.4894
-
0.2056
23

3 4
248
874971.
33
3.6704
53
1.5421
57
249
859815.
49
1.5104
04
0.6346
03
250
841053.
77
2.2303
43
0.9370
89
251
833181.
33
-
1.3296
8
-
0.5586
7
252
818582.
69
-
2.6897
3
-
1.1301
253
808863.
53
1.4702
39
0.6177
27
254
802782.
09
-
4.0897
8
-
1.7183
4
255
768577.
97
2.0301
08
0.8529
59
256
764605.
93
1.0700
95
0.4496
05
257
755666.
85
1.1500
66
0.4832
05
258
733291.
29
2.7099
94
1.1386
16
259
725968.
09
-
2.0900
3
-
0.8781
4
260
711170.
45
-
2.4500
8
-
1.0294
1
261
708217.
29
-
2.2900
9
-
0.9621
9
262
703369.
65
2.3498
97
0.9873
2
263
696922.
05
-
1.0501
2
-
0.4412
1
264
684496.
49
-
0.4901
6
-
0.2059
4
265
655800.
69
1.3097
42
0.5502
94
266 651096. - -
24

33
0.3302
7
0.1387
7
267
645834.
77
-
3.7702
9
-
1.5841
268
644011.
93
-
1.9303
-
0.8110
2
269
638479.
73
-
3.7303
1
-
1.5673
1
270
635327.
57
-
2.5703
2
-
1.0799
3
271
602994.
05
-
4.0504
3
-
1.7018
1
272
577482.
25
2.7494
88
1.1552
1
273
568662.
57
-
0.5705
4
-
0.2397
2
274
564491.
53
-
2.5305
5
-
1.0632
2
275
558131.
49
0.5094
25
0.2140
37
276
543644.
29
1.7093
78
0.7182
03
277
542856.
25
3.7493
76
1.5753
17
278
539791.
65
0.3493
66
0.1467
88
279
538693.
17
-
3.1706
4
-
1.3321
6
280
524142.
29
1.7093
15
0.7181
76
281
514240.
05
-
3.0507
2
-
1.2817
7
282
501360.
77
-
0.7707
6
-
0.3238
4
283
496170.
85
1.1492
24
0.4828
52
25

284
488171.
05
1.9491
98
0.8189
64
285
484589.
05
2.9491
87
1.2391
14
286
478706.
61
3.3891
68
1.4239
74
287
474750.
49
3.5091
55
1.4743
87
288
471335.
65
-
1.6508
6
-
0.6936
1
289
467602.
41
-
0.4108
7
-
0.1726
3
290
464840.
29
-
0.2908
8
-
0.1222
1
291
463542.
81
-
2.8108
8 -1.181
292
454118.
17
2.8290
88
1.1886
54
293
442034.
89
1.1090
49
0.4659
72
294
434592.
29
-
3.2909
8
-
1.3827
2
295
422031.
41
0.5889
84
0.2474
64
296
421935.
89
-
0.8910
2
-
0.3743
6
297
411181.
93
2.0689
49
0.8692
78
298
408157.
13
1.8689
39
0.7852
43
299
405211.
93
-
2.9310
7
-
1.2315
300
391942.
61
-
0.6111
1
-
0.2567
6
301
383146.
81
3.1888
58
1.3398
13
302 382947.
81
-
1.8111
-
0.7609
26

4 6
303
377017.
61
-
3.6111
6
-
1.5172
5
304
362235.
89
3.1087
9
1.3061
72
305
358709.
61
-
3.6112
2
-
1.5172
7
306
356146.
49
2.5087
7
1.0540
71
307
352429.
17
-
1.1712
4
-
0.4921
308
352413.
25
3.7487
58
1.5750
58
309
350861.
05
2.9487
53
1.2389
32
310
348608.
37
-
3.3712
5
-
1.4164
5
311
347135.
77
0.2287
41
0.0961
07
312
332306.
29
-
0.2913
1
-
0.1223
9
313
327713.
37
2.6286
78
1.1044
51
314
326996.
97
3.0286
76
1.2725
12
315
326009.
93
1.0686
72
0.4490
08
316
317508.
65
-
3.6513
6
-
1.5341
3
317
312493.
85
0.1486
29
0.0624
47
318
310758.
57
1.4286
23
0.6002
42
319
285995.
01
-
0.0114
6
-
0.0048
1
320
273752.
53
-
3.5315
-
1.4837
7
321 273083. - -
27

89 0.8915
0.3745
7
322
268021.
33
1.6684
84
0.7010
21
323
267965.
61
-
0.6115
2
-
0.2569
3
324
266692.
01
-
4.0115
2
-
1.6854
6
325
264877.
13
-
4.1315
3
-
1.7358
8
326
263722.
93
0.0684
7
0.0287
68
327
262465.
25
-
0.2515
3
-
0.1056
8
328
261159.
81
-
3.8115
4
-
1.6014
3
329
258540.
97
-
2.9715
5
-
1.2485
1
330
258373.
81
-
0.8115
5
-
0.3409
8
331
258222.
57
-
0.5715
5
-
0.2401
4
332
253446.
57
-
2.5715
6
-
1.0804
5
333
252785.
89
2.1084
35
0.8858
68
334
251759.
05
-
3.0515
7
-
1.2821
3
335
242708.
53
-
2.5316
-
1.0636
6
336
240018.
05
1.9483
94
0.8186
26
337
236953.
45
3.5483
84
1.4908
69
338 236937. 1.4683 0.6169
28

53 84 48
339
230768.
53
-
1.5316
4
-
0.6435
2
340
229654.
13
-
1.1316
4
-
0.4754
6
341
228993.
45
-
1.4516
4
-
0.6099
1
342
223835.
37
2.6283
41
1.1043
09
343
223341.
85
-
1.8516
6
-
0.7779
8
344
220412.
57
-
3.5716
7
-
1.5006
5
345
216106.
21
3.7883
16
1.5916
78
346
212938.
13
1.8683
06
0.7849
77
347
205678.
61
-
3.6117
2
-
1.5174
8
348
203839.
85
-
0.8517
2
-
0.3578
6
349
203099.
57
0.4282
74
0.1799
41
350
196150.
49
-
3.4917
5
-
1.4670
7
351
196126.
61
0.3882
51
0.1631
25
352
186662.
17
-
2.1717
8
-
0.9124
8
353
186407.
45
2.5482
2
1.0706
46
354
184290.
09
1.9082
13
0.8017
44
355
183788.
61
1.3882
11
0.5832
63
356
182292.
13
2.8682
06
1.2050
9
29

357
180580.
73
1.2682
01
0.5328
4
358
180238.
45
-
1.4518
-
0.6099
8
359
174793.
81
2.1881
82
0.9193
74
360
170885.
45
2.5481
69
1.0706
25
361
168226.
81
-
0.8118
4
-
0.3411
362
166571.
13
1.8681
55
0.7849
14
363
164246.
81
0.1881
48
0.0790
51
364
163140.
37
0.6281
44
0.2639
18
365
162304.
57
-
1.5718
6
-
0.6604
2
366
161198.
13
-
4.1318
6
-
1.7360
2
367
157958.
41
2.5881
27
1.0874
13
368
154607.
25
-
3.2518
8
-
1.3662
9
369
154599.
29
-
0.2918
8
-
0.1226
4
370
154519.
69
1.3081
16
0.5496
11
371
153277.
93
2.0681
12
0.8689
27
372
152529.
69
0.3081
1
0.1294
54
373
152362.
53
2.4681
09
1.0369
87
374
151948.
61
3.3881
08
1.4235
29
375
151303.
85
1.1481
06
0.4823
82
376
150889.
93
-
3.9319 -1.652
30

377
148995.
45
-
1.4519
-
0.6100
2
378
143988.
61
-
2.6119
2
-
1.0974
1
379
142285.
17
-
0.1719
2
-
0.0722
3
380
141879.
21
-
2.2119
2
-
0.9293
5
381
139809.
61
3.3880
68
1.4235
12
382
139769.
81
0.1880
68
0.0790
18
383
138758.
89
-
3.8919
3
-
1.6352
1
384
136163.
93
-
0.9319
4
-
0.3915
6
385
135742.
05
-
3.0519
4
-
1.2822
9
386
134078.
41
-
0.4119
5
-
0.1730
8
387
132032.
69
2.3080
43
0.9697
35
388
129206.
89
3.1080
34
1.3058
54
389
125489.
57
0.4280
22
0.1798
35
390
124789.
09
1.9080
2
0.8016
63
391
123523.
45
3.5480
16
1.4907
15
392
122958.
29
0.7080
14
0.2974
75
393
122560.
29
-
2.2919
9
-
0.9629
9
394
120275.
77
-
0.7719
9
-
0.3243
6
31

395
120013.
09
2.9080
04
1.2218
11
396
118922.
57 -3.572
-
1.5007
9
397
117688.
77
2.2279
97
0.9361
03
398
116041.
05
-
4.0520
1
-
1.7024
7
399
115587.
33
3.6679
9
1.5411
22
400
113804.
29
-
0.2920
2
-
0.1226
9
401
112084.
93
2.0679
79
0.8688
7
402
110508.
85
-
1.8520
3
-
0.7781
4
403
104968.
69
-
1.6920
4
-
0.7109
2
404
102540.
89
0.1079
48
0.0453
55
405
101752.
85
2.1479
45
0.9024
69
406
101235.
45
1.5479
43
0.6503
75
407
100367.
81
2.1879
41
0.9192
73
408
100240.
45
-
3.4520
6
-
1.4504
409
100081.
25
3.7479
4
1.5747
14
410
99611.6
12
0.3879
38
0.1629
94
411
97040.5
32
-
1.5320
7
-
0.6437
1
412
96865.4
12
2.5879
29
1.0873
3
413
96156.9
72
2.0279
27
0.8520
43
414 95313.2 2.7879 1.1713
32

12 24 59
415
92256.5
72
2.4279
14
1.0200
99
416
91261.5
72
-
1.5720
9
-
0.6605
2
417
87727.3
32
-
0.3321
-
0.1395
3
418
85976.1
32
-
2.1321
1
-
0.8958
1
419
85522.4
12
3.5878
92
1.5074
69
420
85506.4
92
-
3.4921
1
-
1.4672
2
421
85259.7
32
2.2678
92
0.9528
65
422
83261.7
72
-
2.7721
1
-
1.1647
2
423
81932.4
52
-
3.4521
2
-
1.4504
2
424
81598.1
32
1.8678
8
0.7847
98
425
80093.6
92
2.3078
75
0.9696
64
426
77466.8
92
-
0.8921
3
-
0.3748
3
427
77244.0
12
2.9878
66
1.2553
65
428
72483.9
32
2.0678
5
0.8688
16
429
71902.8
52
1.1478
48
0.4822
74
430
71831.2
12
2.7878
48
1.1713
27
431
71154.6
12
3.3878
46
1.4234
19
432
69650.1
72
-
0.1721
6
-
0.0723
3
433 68957.6 3.3478 1.4066
33

52 39 09
434
68726.8
12
-
3.8121
6
-
1.6017
435
67875.0
92
-
4.0921
6
-
1.7193
4
436
67071.1
32
-
0.1321
7
-
0.0555
3
437
66171.6
52
-
0.6521
7
-
0.2740
1
438
66100.0
12
-
1.0121
7
-
0.4252
7
439
65996.5
32
3.4678
29
1.4570
24
440
65447.2
92
-
2.2921
7
-
0.9630
7
441
65240.3
32
-
1.3321
7
-
0.5597
2
442
64571.6
92
0.3078
24
0.1293
34
443
64014.4
92
-
0.4921
8
-
0.2067
9
444
62557.8
12
1.1878
18
0.4990
67
445
62024.4
92
2.5078
16
1.0536
7
446
61905.0
92
2.9078
16
1.2217
32
447
61793.6
52
0.3478
15
0.1461
36
448
61761.8
12
-
2.8121
8
-
1.1815
5
449
61339.9
32
-
2.9321
9
-
1.2319
7
450
61117.0
52
2.9478
13
1.2385
37
451 60631.4 - -
34

92
1.4921
9
0.6269
5
452
60336.9
72
-
1.9721
9
-
0.8286
2
453
60289.2
12
1.7878
11
0.7511
57
454
59771.8
12
2.1878
09
0.9192
18
455
59477.2
92
3.7078
08
1.5578
52
456
57694.2
52
-
2.2522
-
0.9462
7
457
55521.1
72
-
3.1722
-
1.3328
2
458
55369.9
32
-
3.9322
1
-
1.6521
3
459
53714.2
52
-
0.2522
1
-
0.1059
7
460
53626.6
92
3.3077
89
1.3897
82
461
53356.0
52
-
0.0522
1
-
0.0219
4
462
53252.5
72
3.4277
88 1.4402
463
52926.2
12
-
2.2122
1
-
0.9294
7
464
52679.4
52
1.5477
86
0.6503
09
465
51740.1
72
1.8277
83
0.7679
51
466
50434.7
32
-
1.7322
2
-
0.7278
467
49001.9
32
-
0.9322
3
-
0.3916
8
468
48763.1
32
0.8677
73
0.3645
99
469 48747.2 - -
35

12
3.2122
3
1.3496
3
470
48643.7
32
0.2677
73
0.1125
06
471
48381.0
52
-
0.0522
3
-
0.0219
4
472
47895.4
92
1.5077
7
0.6334
96
473
47362.1
72
-
0.1722
3
-
0.0723
6
474
47330.3
32
-
2.3322
3
-
0.9799
475
47187.0
52
-
2.0522
3
-
0.8622
5
476
47011.9
32
-
2.9322
3
-
1.2319
9
477
46781.0
92
0.9077
67
0.3814
02
478
46621.8
92
1.1077
66
0.4654
33
479
46311.4
52
-
1.4522
3
-
0.6101
6
480
46032.8
52
-
3.8522
4
-
1.6185
3
481
45762.2
12
1.7877
63
0.7511
37
482
45762.2
12
-
3.2122
4
-
1.3496
4
483
45467.6
92
2.3077
62
0.9696
17
484
45157.2
52
-
3.2522
4
-
1.3664
4
485
44464.7
32
-
2.7322
4
-
1.1479
6
486
44345.3
32
2.6677
59
1.1208
71
36

487
43740.3
72
1.6277
57
0.6839
09
488
43597.0
92
-
4.0922
4
-
1.7193
7
489
43215.0
12
-
1.0122
4
-
0.4253
490
43183.1
72
0.8277
55
0.3477
85
491
42204.0
92
-
2.0922
5
-
0.8790
7
492
41917.5
32
-
3.5322
5
-
1.4840
9
493
41129.4
92
0.5077
48
0.2133
33
494
41041.9
32
3.0677
48
1.2889
28
495
40683.7
32
1.2677
47
0.5326
5
496
40548.4
12
-
0.4122
5
-
0.1732
1
497
40508.6
12
-
0.6122
5
-
0.2572
4
498
40365.3
32
-
3.3322
5
-
1.4000
6
499
40293.6
92
0.3077
46
0.1293
01
500
40054.8
92
-
2.8922
6
-
1.2151
9
501
39473.8
12
1.1877
43
0.4990
36
502
39298.6
92
-
1.6922
6
-
0.7110
1
503
38996.2
12
-
0.2122
6
-
0.0891
8
504 38263.8
92
-
2.8922
-
1.2152
37

6
505
38247.9
72
-
1.9722
6
-
0.8286
5
506
38152.4
52
-
1.4522
6
-
0.6101
7
507
38096.7
32
3.2677
39
1.3729
55
508
37802.2
12
1.7877
38
0.7511
26
509
37746.4
92
-
3.4922
6
-
1.4672
9
510
37706.6
92
3.3077
37
1.3897
61
511
36886.8
12
-
2.8122
7
-
1.1815
9
512
36735.5
72
2.4277
34
1.0200
23
513
36401.2
52
-
2.2522
7
-
0.9463
514
35987.3
32
-
1.3322
7
-
0.5597
6
515
34634.1
32
2.8677
27
1.2048
88
516
34355.5
32
-
0.5322
7
-
0.2236
4
517
33973.4
52
2.5477
25
1.0704
38
518
33830.1
72
2.8277
25
1.1880
81
519
33750.5
72
1.4277
24
0.5998
65
520
33249.0
92
-
4.0922
8
-
1.7193
9
521
33145.6
12
-
1.6122
8
-
0.6774
1
522 33042.1
32
-
0.1322
-
0.0555
38

8 8
523
32978.4
52
-
1.4522
8
-
0.6101
8
524
32867.0
12
1.9877
22
0.8351
5
525
32126.7
32
0.2677
19
0.1124
83
526
31131.7
32
3.2677
16
1.3729
46
527
31131.7
32
1.2677
16
0.5326
37
528
31060.0
92
-
4.0922
8
-
1.7193
9
529
30678.0
12
1.9877
15
0.8351
47
530
30439.2
12
0.7877
14
0.3309
61
531
30112.8
52
3.1477
13
1.3225
26
532
30096.9
32
3.0677
13
1.2889
13
533
29683.0
12
-
0.0122
9
-
0.0051
6
534
29380.5
32
3.4677
1
1.4569
74
535
29197.4
52
2.5477
1
1.0704
32
536
28847.2
12
2.7877
09
1.1712
68
537
28791.4
92
-
0.4922
9
-
0.2068
4
538
28003.4
52
0.5477
06
0.2301
21
539
27812.4
12
0.5877
05
0.2469
27
540
27716.8
92
1.1077
05
0.4654
07
541
27621.3
72
0.6277
05
0.2637
33
542
27557.6
92
-
1.6923
-
0.7110
3
39

543
27048.2
52
3.7477
03
1.5746
14
544
26705.9
72
2.0277
02
0.8519
48
545
25846.2
92
-
2.2923
-
0.9631
2
546
25519.9
32
2.0676
98
0.8687
52
547
25519.9
32
-
2.9323
-
1.2320
2
548
25424.4
12
-
1.4123
-
0.5933
9
549
25368.6
92
-
3.6923
-
1.5513
4
550
25026.4
12
0.5876
96
0.2469
23
551
25018.4
52
1.5476
96
0.6502
71
552
24660.2
52
-
3.2523
1
-
1.3664
7
553
24556.7
72
-
2.7723
1
-
1.1648
554
24548.8
12
-
3.8123
1
-
1.6017
6
555
24373.6
92
3.3076
94
1.3897
42
556
23904.0
52
-
3.0523
1
-
1.2824
4
557
23744.8
52
1.1476
92
0.4822
08
558
22733.9
32
-
2.9323
1
-
1.2320
2
559
22725.9
72
3.0276
89
1.2720
97
560
22550.8
52
3.1476
88
1.3225
15
561 22272.2 - -
40

52
2.2523
1
0.9463
2
562
22264.2
92
1.7076
87
0.7174
92
563
22232.4
52
0.5476
87
0.2301
13
564
22176.7
32
3.2676
87
1.3729
33
565
22049.3
72
-
0.3723
1
-
0.1564
3
566
21882.2
12
-
0.2123
1
-
0.0892
567
21611.5
72
-
1.5723
1
-
0.6606
2
568
21524.0
12
2.9876
85
1.2552
89
569
21269.2
92
1.7076
84
0.7174
91
570
20919.0
52
-
2.0523
2
-
0.8622
9
571
20839.4
52
0.5476
83
0.2301
11
572
20775.7
72
2.2276
82
0.9359
71
573
20743.9
32
0.0676
82
0.0284
37
574
20728.0
12
-
2.0123
2
-
0.8454
8
575
20298.1
72
1.8276
81
0.7679
08
576
19725.0
52
-
3.0523
2
-
1.2824
5
577
19629.5
32
1.4676
79
0.6166
52
578
19414.6
12
-
2.6123
2
-
1.0975
8
579
19327.0
52
-
0.0523
2
-
0.0219
8
41

580
19303.1
72
-
0.1723
2
-
0.0724
581
18586.7
72
0.2276
75
0.0956
59
582
18228.5
72
1.4276
74
0.5998
44
583
18220.6
12
-
2.6123
3
-
1.0975
8
584
17981.8
12
-
0.8123
3
-
0.3413
585
17480.3
32
-
1.3323
3
-
0.5597
8
586
17305.2
12
3.7876
71
1.5914
07
587
17106.2
12
0.7876
7
0.3309
43
588
17082.3
32
2.6676
7
1.1208
34
589
16978.8
52
-
3.8523
3
-
1.6185
7
590
16819.6
52
-
3.6523
3
-
1.5345
4
591
16286.3
32
-
2.3323
3
-
0.9799
4
592
16270.4
12
-
0.4123
3
-
0.1732
4
593
15737.0
92
-
2.0923
3
-
0.8791
CONCLUSION
In the last it is concluded that Business analysis is a helpful tool in determining the best and
accurate values of the data which support to make meaningful results. After analysing
employee relation in this report it can be concluded that for growth of an organization it
important to maintain a good relationship between all members of company.
42

REFERENCES
Books and Journals
Cocârţă, D. M., Stoian, M. A. and Karademir, A., 2017. Crude oil contaminated sites: evaluation
by using risk assessment approach. Sustainability, 9(8), p.1365.
Corbett, J. and Mellouli, S., 2017. Winning the SDG battle in cities: how an integrated
information ecosystem can contribute to the achievement of the 2030 sustainable
development goals. Information Systems Journal, 27(4), pp.427-461
Gao, J., Chen, W. and Yuan, F., 2017. Spatial restructuring and the logic of industrial land
redevelopment in urban China: I. Theoretical considerations. Land Use Policy, 68,
pp.604-613.
Huysegoms, L. and Cappuyns, V., 2017. Critical review of decision support tools for
sustainability assessment of site remediation options. Journal of environmental
management, 196, pp.278-296.
Isaac, D., O'Leary, J. and Daley, M., 2016. Property development. Macmillan International
Higher Education.
43