stats assignment

profileiamnickok
data.xlsx

MATH533 Course Project Data SAL

Employee Number SALES (Y) CALLS (X1) TIME (X2) YEARS(X3) TYPE Legend:
1 46 171 12.7 5 ONLINE Employee Number is just as it sounds.
2 34 134 17.0 4 NONE SALES represents the number sales made this week.
3 44 165 15.7 3 ONLINE CALLS represents the number of sales calls made this week.
4 45 186 13.0 3 ONLINE TIME represents the average time per call this week.
5 42 180 14.8 2 ONLINE YEARS represents years of experience in the call center.
6 47 184 12.4 2 ONLINE TYPE represents the type of training the employee received.
7 33 126 20.2 3 NONE
8 44 172 14.4 3 GROUP
9 42 161 13.9 1 GROUP
10 37 149 15.4 3 NONE
11 46 181 12.2 4 ONLINE
12 40 145 16.0 0 NONE
13 43 140 17.0 2 GROUP
14 52 198 13.5 2 ONLINE
15 41 149 17.3 0 ONLINE
16 42 168 12.9 3 ONLINE
17 32 124 17.5 2 NONE
18 42 149 16.5 1 GROUP
19 38 135 18.2 1 GROUP
20 49 185 18.6 2 ONLINE
21 39 154 18.3 1 NONE
22 43 149 15.6 1 ONLINE
23 50 193 13.2 1 ONLINE
24 37 153 18.7 0 NONE
25 39 152 15.0 3 GROUP
26 43 170 14.7 4 GROUP
27 44 192 14.6 1 GROUP
28 45 165 16.4 3 ONLINE
29 40 150 15.3 3 GROUP
30 43 174 15.6 2 ONLINE
31 42 168 15.0 0 ONLINE
32 48 178 15.1 3 ONLINE
33 44 164 16.5 3 GROUP
34 51 191 11.8 2 ONLINE
35 37 139 14.4 0 NONE
36 37 138 17.7 1 NONE
37 46 171 15.9 5 ONLINE
38 44 170 11.2 0 ONLINE
39 41 153 18.0 3 GROUP
40 42 154 15.1 2 GROUP
41 40 144 14.0 3 NONE
42 37 134 16.9 2 NONE
43 47 177 17.2 0 ONLINE
44 39 157 14.5 4 NONE
45 40 134 20.2 3 GROUP
46 37 131 18.3 1 GROUP
47 35 129 18.4 4 NONE
48 44 183 15.1 4 ONLINE
49 43 169 14.0 5 GROUP
50 42 155 16.0 2 ONLINE
51 48 182 12.8 2 ONLINE
52 37 143 12.0 1 NONE
53 41 157 13.5 1 ONLINE
54 43 167 14.8 3 ONLINE
55 40 142 15.8 2 NONE
56 42 168 12.1 2 GROUP
57 43 175 14.8 2 GROUP
58 39 150 18.0 2 GROUP
59 41 155 17.9 1 GROUP
60 46 163 16.6 2 ONLINE
61 40 162 13.6 4 GROUP
62 44 189 14.1 3 ONLINE
63 44 153 20.9 2 ONLINE
64 41 158 13.4 3 ONLINE
65 43 160 11.2 4 ONLINE
66 46 173 12.1 1 ONLINE
67 43 178 18.3 2 GROUP
68 47 189 13.1 1 ONLINE
69 49 184 11.4 4 ONLINE
70 45 174 14.0 2 ONLINE
71 48 188 14.6 0 ONLINE
72 37 149 15.8 1 GROUP
73 40 159 14.6 2 GROUP
74 44 160 14.8 2 ONLINE
75 41 166 17.4 1 GROUP
76 52 178 14.9 1 ONLINE
77 49 178 12.0 2 ONLINE
78 48 176 13.3 1 ONLINE
79 39 143 15.5 2 NONE
80 41 159 18.8 2 ONLINE
81 38 149 14.7 2 NONE
82 40 151 16.6 2 GROUP
83 48 186 13.1 1 ONLINE
84 47 194 13.1 2 ONLINE
85 38 152 14.2 4 GROUP
86 38 146 19.7 2 NONE
87 45 188 10.0 2 ONLINE
88 39 139 19.3 3 GROUP
89 49 201 12.5 1 ONLINE
90 41 156 11.8 3 GROUP
91 36 132 19.5 2 NONE
92 42 161 16.3 3 ONLINE
93 41 152 14.6 1 ONLINE
94 45 178 16.4 2 ONLINE
95 38 157 16.4 3 GROUP
96 41 154 14.3 1 GROUP
97 44 156 21.6 0 ONLINE
98 44 170 12.5 1 ONLINE
99 44 170 15.8 0 ONLINE
100 37 146 17.7 3 NONE