Data Analysis for Test Scores and Income

Data Analysis

Table of Contents
Q1................................................................................................................................................................3
Q2................................................................................................................................................................5
Q3................................................................................................................................................................5
Q4................................................................................................................................................................6
Q5................................................................................................................................................................6
Q6................................................................................................................................................................6
Q7................................................................................................................................................................7
Q8................................................................................................................................................................7
Q9................................................................................................................................................................7
Q10..............................................................................................................................................................8
Q11..............................................................................................................................................................9
Q12..............................................................................................................................................................9

Q1.
10% of employees are equal to 15 (150 * 0.10) employees. Converting the data into ranks, at 10th
rank score is 111. Thus any employee scored below 111 will be selected for training.
Test
Count of
Test
1 74 2
2 82 1
3 83 1
4 95 1
5 96 1
6 102 1
7 104 2
8 107 2
9 109 1
10 111 1
11 112 3
12 113 1
13 116 1
14 118 1
15 119 1
16 122 1
17 123 5
18 124 2
19 125 1
20 126 1
21 127 1
22 128 1
23 129 2
24 132 1
25 133 1
26 134 1
27 135 2
28 136 1
29 137 1
30 138 5
31 139 2
32 141 3
33 142 3
34 143 2
35 145 1