S.

NO Emp_NO Emp_Name Department Designation Basic

8 1008 M IT Analyst 50000
19 1019 B Sales Clerk 45000
14 1014 G Sales Clerk 40000
17 1017 D HR Executive 35000
7 1007 N HR Executive 32000
10 1010 K Finance Lead 31000
18 1018 C IT Analyst 29000
9 1009 L Sales Clerk 27000
3 1003 R IT Analyst 25000
16 1016 E Accounts Manager 23000
5 1005 P Finance Lead 22000
12 1012 I HR Executive 21000
15 1015 F Finance Lead 19000
2 1002 S HR Executive 18000
20 1020 A Finance Lead 17000
13 1013 H IT Analyst 16000
6 1006 O Accounts Manager 15000
11 1011 J Accounts Manager 14000
1 1001 T Accounts Manager 12000
4 1004 Q Sales Clerk 8000

Salary Comparison:Highest vs Lowest

15980
19220
21590
64250
22775

23960 58325

42920
52400
46475

M B G D N H O J T Q
 DA HRA TA Medical PF Gross Net_Sale
6000 4000 0 5000 750 65000 64250
5400 3600 0 5000 675 59000 58325
4800 3200 0 5000 600 53000 52400
4200 2800 0 5000 525 47000 46475
3840 2560 0 5000 480 43400 42920
3720 2480 0 5000 465 42200 41735
3480 2320 0 5000 435 39800 39365
3240 2160 0 5000 405 37400 36995
3000 2000 0 5000 375 35000 34625
2760 1840 0 5000 345 32600 32255
2640 1760 0 5000 330 31400 31070
2520 1680 0 5000 315 30200 29885
2280 1520 0 5000 285 27800 27515
2160 1440 0 5000 270 26600 26330
2040 1360 0 5000 255 25400 25145
1920 1280 0 5000 240 24200 23960
1800 1200 0 5000 225 23000 22775
1680 1120 0 5000 210 21800 21590
1440 960 0 5000 180 19400 19220
960 640 1500 5000 120 16100 15980

Lowest Top 5 Highest Paid Employees

70000
64250
60000 58325
52400
50000 46475
42920
40000

30000

20000

10000

0
Q M B G D N
 Grade Mean Standard deviation
A
A
A
B
B
B
B
B
B
B
B
C
C
C
C
C
C
C
C 17600 2291.025971044
C

es

75
42920

D N
Department (empty) Designation (empty) Sum of Net_Salary
Accounts Analyst 692815
Finance Clerk
HR Executive
IT Lead
Sales Manager
(empty) (empty)
Total Result Total Result
Count of Emp_NO
20
Roll no. Student_id Name Marks 1 Marks 2
1 S1001 A 83 41
2 S1002 B 90 84
3 S1003 C 99 82
4 S1004 D 100 48
5 S1005 E 51 32
6 S1006 F 31 57
7 S1007 G 89 86
8 S1008 H 89 83
9 S1009 I 78 97
10 S1010 J 85 89
11 S1011 K 90 70
12 S1012 L 50 87
13 S1013 M 43 69
14 S1014 N 58 40
15 S1015 O 88 34
16 S1016 P 42 35
17 S1017 Q 97 63
18 S1018 R 80 59
19 S1019 S 63 82
20 S1020 T 46 94
21 S1021 U 47 66
22 S1022 V 86 52
23 S1023 W 64 44
24 S1024 X 61 75
25 S1025 Y 92 33
Marks 3 Marks 4 Marks 5 Marks 6 Marks 7 Total
46 78 93 89 72 502
35 69 44 67 66 455
57 58 53 80 58 487
59 39 94 50 56 446
50 35 37 40 99 344
55 65 84 79 80 451
91 46 51 34 90 487
53 40 60 35 66 426
82 80 95 36 96 564
64 64 30 31 43 406
52 63 36 71 70 452
97 52 68 73 39 466
62 56 82 30 77 419
38 49 77 73 64 399
86 94 59 99 30 490
49 99 72 100 77 474
95 93 41 93 95 577
82 32 89 96 62 500
42 30 33 61 31 342
54 76 30 83 33 416
52 92 61 88 79 485
95 99 85 67 82 566
94 75 91 96 67 531
68 100 59 31 74 468
85 39 49 56 53 407
Average Grade Minimum Maximum Class Average Standard Deviation
72 B 49 82 66.12 8.57120761619972
65 B
70 B
64 B
49 D
64 B
70 B
61 B
81 A
58 C
65 B
67 B
60 B
57 C
70 B
68 B
82 A
71 B
49 D
59 C
69 B
81 A
76 A
67 B
58 C
eviation
Roll no. Student_id Name Marks 1 Marks 2 Marks 3 Marks 4 Marks 5
1 S1001 A 89 46 81 59 55
2 S1002 B 71 63 79 94 48
3 S1003 C 37 92 41 42 47
4 S1004 D 34 49 84 91 75
5 S1005 E 58 40 68 37 83
6 S1006 F 99 53 83 98 57
7 S1007 G 67 36 83 41 66
8 S1008 H 90 61 84 30 44
9 S1009 I 52 98 35 98 95
10 S1010 J 30 60 59 98 75
11 S1011 K 80 59 69 72 94
12 S1012 L 34 72 52 73 57
13 S1013 M 63 49 43 94 83
14 S1014 N 91 77 67 83 64
15 S1015 O 90 65 72 31 83
16 S1016 P 39 98 59 89 37
17 S1017 Q 87 42 98 51 67
18 S1018 R 63 51 87 93 85
19 S1019 S 77 83 65 60 46
20 S1020 T 66 65 51 99 95
21 S1021 U 67 77 85 37 80
22 S1022 V 93 31 43 59 47
23 S1023 W 70 96 88 38 49
24 S1024 X 37 43 71 35 100
25 S1025 Y 61 96 43 99 48

Student Perform
90
80
70
60
50
40
30
20
10
0
A B C D E F G H I J K
 Marks 6 Marks 7 Total Average Grade Minimum Maximum
54 83 467 67 B 51 78
97 95 547 78 A
53 43 355 51 C
63 34 430 61 B
74 80 440 63 B
74 47 511 73 B
49 66 408 58 C
34 73 416 59 C
33 97 508 73 B
43 92 457 65 B
43 33 450 64 B
58 40 386 55 C
86 81 499 71 B
68 50 500 71 B
69 91 501 72 B
94 43 459 66 B
89 80 514 73 B
68 30 477 68 B
47 52 430 61 B
40 36 452 65 B
87 57 490 70 B
88 97 458 65 B
88 66 495 71 B
87 47 420 60 B
42 59 448 64 B

Student Performance:Average Marks

C D E F G H I J K L M N O P Q R S T U V W X Y
Class Average Standard Deviation
65.76 6.28191053740819