33 34 Points Questior 1 From the "Human Resources_data_example.xlsx" dataset, please select at least 1 important variable for each data type (nominal, ordinal, interval, and ratio) and explain briefly why these selected variables are important to have. (30 pts) El Human Resources_data_example.xlsx 33 34 Points Question 1 From the "Human Resources_data_example.xlsx" dataset, please select at least 1 important variable for each data type (nominal, ordinal, interval, and ratio) and explain briefly why these selected variables are important to have. (30 pts) I El Human Resources_data_example.xlsx saction level as evaluation number project mandy hours 0.53 time spend company Work dident en promotion at Syars Department 0.38 2 157 1 0.8 0.86 3 6 ry low medium 5 O 0 0 262 222 1 0.11 0.88 7 4 1 0.72 0.87 5 223 0 1 0.52 2 0.37 0.41 5 3 159 0 1 Din owles Osalg O os Osale owles Oles O cas 0.5 2 153 O 1 medium low low low low Tow 8 0.77 6 247 0 1 0 0.85 5 3 4 S 5 259 0 1 so 1 S 224 D 1 low 0.53 2 142 2 0.45 3 0 1 Ows low 22 0.54 2 135 3 O 1 low 0.11 0.81 6 305 4 0 1 Osades low 0.84 0.92 4 234 S 0 1 Osales low 15 0.41 O.SS 2 148 3 0 1 Osales low 15 0.36 0.56 2 137 3 0 1 Osales low 17 0.38 0.54 2 143 3 O ale low 0.45 0.47 2 160 3 1 osales low 0.78 0.99 255 6 0 1 Osales low 20 0.45 0.51 160 3 1 1 1 sales low 21 0.76 0.89 5 262 5 0 1 sales Osales 22 0.11 0.83 6 282 4 0 1 low 0.38 0.55 2 147 3 0 1 o les low 24 0.09 0.95 6 304 4 0 1 low 25 0.46 0.57 2 139 3 0 1 Osales low 26 0.4 0.53 2 158 3 1 Osales low 27 0.89 0.92 5 242 5 0 1 28 0.82 0.87 4 239 5 low low low 29 0.4 0.49 2 135 3 0 1 30 0.41 0.46 2 128 0 Osales Osales oses O accounting O accounting O accounting Ohr low 31 0.38 0.5 2 132 0 32 0.09 0.62 low low low 6 294 0 33 0.45 0.57 2 134 Ohr 34 low 0.4 0.51 0 2 145 Ohr low 35 0.45 0.55 2. 140 Ohr 0.84 36 0.87 0 4 246 1 low low 37 0.94 0.1 0 6 255 low O technical technical O technical 0 38 0.46 1 0.38 2 137 low 0 39 0.45 0.5 2 126 HR comma sep + CellStyles FM 4 306 6 0.11 089 054 1 1 3 2 49 0.41 87 152 269 5 0 1 ORA 42 5 2 1 158 0.48 43 0.45 3 3 0 127 1 2 44 0.4 0.45 0.8 4 0 281 1 0.1 7 0 1 4 276 6 0.89 4 1 0.74 182 3 0 0 1 3 147 0.4 OSS 2 6 273 0.7 3 49 O 0 1 1 3 0.4 0.54 148 2 50 1 0 3 147 2 0.47 o technical low O technical low Technical low o technic low O technical low O technical low O technical low O technical low o support low opport low support low O support low support low O support low O support low o support low O support low o support low o support O technical low O technical low O technical low O management medium DIT medium 51 0.43 2 1 152 0.78 6 0.13 52 3 O 1 135 0.44 53 0.55 2 1 se 0.31 0.55 2 134 132 O O 1 2 SS 0.39 0.54 0.92 0 1 7 56 307 140 0 1 0.1 0.37 0.11 57 0.46 2 0 1 255 7 0.94 58 O 1 309 0.81 6 01 59 O 1 2 128 0.38 60 6 0.54 1 1 5 225 4 0.85 226 5 0 O D 0.85 0.91 5 7 1 1 308 0.93 63 0.11 medium 0 244 1 5 DIT OIT 64 0.1 medium O 132 1 2 65 0.36 0.56 4 @ 1 6 286 RSS C33863SBNNSSON 0.54 0.7 161 4 0 1 0.11 0.01 0.43 67 6 153 0 1 SE 054 2 264 D 1 0.9 4 1 1 5 223 70 1 135 2 098 0.86 0.5 0.99 0.77 0 O 2 0.76 0.43 0.74 0.09 0.45 DIT medium DIT medium 0 product_mng medium O producting medium O product meg medium o product_mng medium OIT medium product_mng medium 0 product_mng high 0 product_mngo 0 product_mng medium O product_mng medium 0 product_mng medium 277 2 0 1 S 275 73 1 0.49 2 74 149 295 O 1 0.09 0.87 7 75 0 277 0.97 0.11 5 1 1 75 0 306 0.79 0.11 77 1 295 TB 0.83 0.1 HR comma sep + > I 1 cul stres El forma 0.43 157 O 30 1 0.56 0.56 0.39 2 33 142 0 1 2 140 3 0 0.45 1 52 2 151 3 0 1 83 4 139 3 0 1 038 0.79 0.84 0.11 4 Oles (low O counting low o support O technic low 1 management low O marketing low o marating low o marketing low O ales IC 0.54 0.49 0.59 O.RS 0.77 0.87 4 249 6 O 1 SS 6 291 4 0 5 O 305 4 1 6 87 0.11 0 3 1 88 232 0.17 0.84 5 1 low 0.44 89 3 0.45 2 132 O se Oles D 0 0 1 low 2 3 0.37 0.57 130 90 low 4 1 0.1 0.75 291 6 D low 1 3 130 2 0.4 0.5 92 O ses les O se O les Oles 1 5 246 0.89 S 1 93 low low 0 143 1 3 0.48 2 0.42 94 low 0 1 129 95 0.46 0.55 2 O les 1 0.09 255 95 0.83 6 D 0 1 O ale low low low low 2 155 97 0.37 0.51 0 1 265 0.72 6 0.1 99 1 6 279 0.84 Oles Ows Osale Osales 99 0.1 low 4 284 1 6 100 0.11 0.97 medium 221 5 101 1 0.9 D 1 0 1 medium 2 154 102 0.52 0.38 medium 3 147 0 1 2 103 0.52 0.36 3 1 150 0.42 2 0.46 0 4 1 104 105 267 medium medium medium medium 7 0.94 0.09 3 158 0 1 0.52 2 0.43 0 5 1 106 107 224 Osales ses sal Osale o accounting o accounting O accounting Ohr Ohr hr 7 0.46 0.24 medium 5 0 1 257 4 medium 108 1 0.91 D1 148 2 medium 0.5 109 4 0 1 177 3 medium 110 0.87 0.71 3 0 1 155 2 medium 0.49 0 1 3 0.4 0.43 144 0.47 2 112 4 0 1 289 6 0.85 0.09 113 0 1 160 2 0.43 0.52 O 1 high low medium medium medium medium 0.hr technical O technical O technical Technical O technical 258 4 0.96 0.9 115 0 1 234 5 0.84 1 0 137 1 1 0.48 2 117 037 0.86 5 263 0368 HR comma sep + Cut Styles For 14 D 819 0.11 0 6 2 $20 251 133 1 0.37 057 1 0 0 0.4 0.46 2 112 1 122 0.14 0.62 4 158 4 1 123 0.4 0.46 2 135 1 1 224 4 216 6 0 1 0.75 0.11 1 0.84 225 6 300 5 1 126 0.45 0.49 2 3 127 0.11 0.92 6 4 0 1 260 132 128 038 0.49 3 O 1 2 3 129 0.7 0.89 181 S 1 130 0.00 0.82 6 250 4 0 1 Otacked low o technic low O technic low O technical low O technical low O technic low o support low port low support low 0 port low O wort low o support low o support low O support low support low wpport low O support low O technic low O technical low O technical low O management low O IT low QIT low 133 37 0.45 2 151 1 1 132 0.1 6 292 4 0 1 0.83 0.57 13 0.38 2 140 3 1 334 0.5 1 5 221 5 O 1 135 0.44 0.51 2 138 1 O 1 136 0.5 2 132 3 0 1 0.36 0.31 137 0.84 7 133 5 1 230 0.1 0.54 6 4 1 1 283 129 139 0.42 0.48 2 3 0 140 0.74 1 4 249 5 O 0 1 1 1 143 0.73 0.87 5 257 5 0.09 0.96 6 245 4 0 1 142 14 O IT OIT low low 0.45 0.53 2 155 1 0 1 144 0.11 0.5 6 256 4 0 1 145 0.37 2 152 3 D 0.47 0.99 146 084 4 267 5 0 1 147 0.41 0.46 2 151 0 1 148 0.76 0.92 4 239 O 1 149 0.11 0.87 6 306 0 1 084 150 0.88 263 4 S O IT low O product glow 0 product ng low O product ng low 0 product_ming low DIT low O marketing low o marketing low O marketing low O marketing low marketing low O marketing low low 1 1 151 0.39 0.5 2 147 0 1 152 0.11 0.91 6 278 o 1 153 0.45 0.56 1 154 2 2 D O 156 0.37 0.52 1 143 155 155 0.4 1 0.52 O 1 156 0 39 160 0.48 1 low o accounting 157 0.11 304 0.8 HR comma sep + 33 34 Points Questior 1 From the "Human Resources_data_example.xlsx" dataset, please select at least 1 important variable for each data type (nominal, ordinal, interval, and ratio) and explain briefly why these selected variables are important to have. (30 pts) El Human Resources_data_example.xlsx 33 34 Points Question 1 From the "Human Resources_data_example.xlsx" dataset, please select at least 1 important variable for each data type (nominal, ordinal, interval, and ratio) and explain briefly why these selected variables are important to have. (30 pts) I El Human Resources_data_example.xlsx saction level as evaluation number project mandy hours 0.53 time spend company Work dident en promotion at Syars Department 0.38 2 157 1 0.8 0.86 3 6 ry low medium 5 O 0 0 262 222 1 0.11 0.88 7 4 1 0.72 0.87 5 223 0 1 0.52 2 0.37 0.41 5 3 159 0 1 Din owles Osalg O os Osale owles Oles O cas 0.5 2 153 O 1 medium low low low low Tow 8 0.77 6 247 0 1 0 0.85 5 3 4 S 5 259 0 1 so 1 S 224 D 1 low 0.53 2 142 2 0.45 3 0 1 Ows low 22 0.54 2 135 3 O 1 low 0.11 0.81 6 305 4 0 1 Osades low 0.84 0.92 4 234 S 0 1 Osales low 15 0.41 O.SS 2 148 3 0 1 Osales low 15 0.36 0.56 2 137 3 0 1 Osales low 17 0.38 0.54 2 143 3 O ale low 0.45 0.47 2 160 3 1 osales low 0.78 0.99 255 6 0 1 Osales low 20 0.45 0.51 160 3 1 1 1 sales low 21 0.76 0.89 5 262 5 0 1 sales Osales 22 0.11 0.83 6 282 4 0 1 low 0.38 0.55 2 147 3 0 1 o les low 24 0.09 0.95 6 304 4 0 1 low 25 0.46 0.57 2 139 3 0 1 Osales low 26 0.4 0.53 2 158 3 1 Osales low 27 0.89 0.92 5 242 5 0 1 28 0.82 0.87 4 239 5 low low low 29 0.4 0.49 2 135 3 0 1 30 0.41 0.46 2 128 0 Osales Osales oses O accounting O accounting O accounting Ohr low 31 0.38 0.5 2 132 0 32 0.09 0.62 low low low 6 294 0 33 0.45 0.57 2 134 Ohr 34 low 0.4 0.51 0 2 145 Ohr low 35 0.45 0.55 2. 140 Ohr 0.84 36 0.87 0 4 246 1 low low 37 0.94 0.1 0 6 255 low O technical technical O technical 0 38 0.46 1 0.38 2 137 low 0 39 0.45 0.5 2 126 HR comma sep + CellStyles FM 4 306 6 0.11 089 054 1 1 3 2 49 0.41 87 152 269 5 0 1 ORA 42 5 2 1 158 0.48 43 0.45 3 3 0 127 1 2 44 0.4 0.45 0.8 4 0 281 1 0.1 7 0 1 4 276 6 0.89 4 1 0.74 182 3 0 0 1 3 147 0.4 OSS 2 6 273 0.7 3 49 O 0 1 1 3 0.4 0.54 148 2 50 1 0 3 147 2 0.47 o technical low O technical low Technical low o technic low O technical low O technical low O technical low O technical low o support low opport low support low O support low support low O support low O support low o support low O support low o support low o support O technical low O technical low O technical low O management medium DIT medium 51 0.43 2 1 152 0.78 6 0.13 52 3 O 1 135 0.44 53 0.55 2 1 se 0.31 0.55 2 134 132 O O 1 2 SS 0.39 0.54 0.92 0 1 7 56 307 140 0 1 0.1 0.37 0.11 57 0.46 2 0 1 255 7 0.94 58 O 1 309 0.81 6 01 59 O 1 2 128 0.38 60 6 0.54 1 1 5 225 4 0.85 226 5 0 O D 0.85 0.91 5 7 1 1 308 0.93 63 0.11 medium 0 244 1 5 DIT OIT 64 0.1 medium O 132 1 2 65 0.36 0.56 4 @ 1 6 286 RSS C33863SBNNSSON 0.54 0.7 161 4 0 1 0.11 0.01 0.43 67 6 153 0 1 SE 054 2 264 D 1 0.9 4 1 1 5 223 70 1 135 2 098 0.86 0.5 0.99 0.77 0 O 2 0.76 0.43 0.74 0.09 0.45 DIT medium DIT medium 0 product_mng medium O producting medium O product meg medium o product_mng medium OIT medium product_mng medium 0 product_mng high 0 product_mngo 0 product_mng medium O product_mng medium 0 product_mng medium 277 2 0 1 S 275 73 1 0.49 2 74 149 295 O 1 0.09 0.87 7 75 0 277 0.97 0.11 5 1 1 75 0 306 0.79 0.11 77 1 295 TB 0.83 0.1 HR comma sep + > I 1 cul stres El forma 0.43 157 O 30 1 0.56 0.56 0.39 2 33 142 0 1 2 140 3 0 0.45 1 52 2 151 3 0 1 83 4 139 3 0 1 038 0.79 0.84 0.11 4 Oles (low O counting low o support O technic low 1 management low O marketing low o marating low o marketing low O ales IC 0.54 0.49 0.59 O.RS 0.77 0.87 4 249 6 O 1 SS 6 291 4 0 5 O 305 4 1 6 87 0.11 0 3 1 88 232 0.17 0.84 5 1 low 0.44 89 3 0.45 2 132 O se Oles D 0 0 1 low 2 3 0.37 0.57 130 90 low 4 1 0.1 0.75 291 6 D low 1 3 130 2 0.4 0.5 92 O ses les O se O les Oles 1 5 246 0.89 S 1 93 low low 0 143 1 3 0.48 2 0.42 94 low 0 1 129 95 0.46 0.55 2 O les 1 0.09 255 95 0.83 6 D 0 1 O ale low low low low 2 155 97 0.37 0.51 0 1 265 0.72 6 0.1 99 1 6 279 0.84 Oles Ows Osale Osales 99 0.1 low 4 284 1 6 100 0.11 0.97 medium 221 5 101 1 0.9 D 1 0 1 medium 2 154 102 0.52 0.38 medium 3 147 0 1 2 103 0.52 0.36 3 1 150 0.42 2 0.46 0 4 1 104 105 267 medium medium medium medium 7 0.94 0.09 3 158 0 1 0.52 2 0.43 0 5 1 106 107 224 Osales ses sal Osale o accounting o accounting O accounting Ohr Ohr hr 7 0.46 0.24 medium 5 0 1 257 4 medium 108 1 0.91 D1 148 2 medium 0.5 109 4 0 1 177 3 medium 110 0.87 0.71 3 0 1 155 2 medium 0.49 0 1 3 0.4 0.43 144 0.47 2 112 4 0 1 289 6 0.85 0.09 113 0 1 160 2 0.43 0.52 O 1 high low medium medium medium medium 0.hr technical O technical O technical Technical O technical 258 4 0.96 0.9 115 0 1 234 5 0.84 1 0 137 1 1 0.48 2 117 037 0.86 5 263 0368 HR comma sep + Cut Styles For 14 D 819 0.11 0 6 2 $20 251 133 1 0.37 057 1 0 0 0.4 0.46 2 112 1 122 0.14 0.62 4 158 4 1 123 0.4 0.46 2 135 1 1 224 4 216 6 0 1 0.75 0.11 1 0.84 225 6 300 5 1 126 0.45 0.49 2 3 127 0.11 0.92 6 4 0 1 260 132 128 038 0.49 3 O 1 2 3 129 0.7 0.89 181 S 1 130 0.00 0.82 6 250 4 0 1 Otacked low o technic low O technic low O technical low O technical low O technic low o support low port low support low 0 port low O wort low o support low o support low O support low support low wpport low O support low O technic low O technical low O technical low O management low O IT low QIT low 133 37 0.45 2 151 1 1 132 0.1 6 292 4 0 1 0.83 0.57 13 0.38 2 140 3 1 334 0.5 1 5 221 5 O 1 135 0.44 0.51 2 138 1 O 1 136 0.5 2 132 3 0 1 0.36 0.31 137 0.84 7 133 5 1 230 0.1 0.54 6 4 1 1 283 129 139 0.42 0.48 2 3 0 140 0.74 1 4 249 5 O 0 1 1 1 143 0.73 0.87 5 257 5 0.09 0.96 6 245 4 0 1 142 14 O IT OIT low low 0.45 0.53 2 155 1 0 1 144 0.11 0.5 6 256 4 0 1 145 0.37 2 152 3 D 0.47 0.99 146 084 4 267 5 0 1 147 0.41 0.46 2 151 0 1 148 0.76 0.92 4 239 O 1 149 0.11 0.87 6 306 0 1 084 150 0.88 263 4 S O IT low O product glow 0 product ng low O product ng low 0 product_ming low DIT low O marketing low o marketing low O marketing low O marketing low marketing low O marketing low low 1 1 151 0.39 0.5 2 147 0 1 152 0.11 0.91 6 278 o 1 153 0.45 0.56 1 154 2 2 D O 156 0.37 0.52 1 143 155 155 0.4 1 0.52 O 1 156 0 39 160 0.48 1 low o accounting 157 0.11 304 0.8 HR comma sep +