Question: Experience Training Completed task 10.9 4 Yes 9.9 4 Yes 10.4 6 Yes 13.7 6 Yes 9.4 8 Yes 12.4 4 Yes 7.9 6 Yes
| Experience | Training | Completed task |
| 10.9 | 4 | Yes |
| 9.9 | 4 | Yes |
| 10.4 | 6 | Yes |
| 13.7 | 6 | Yes |
| 9.4 | 8 | Yes |
| 12.4 | 4 | Yes |
| 7.9 | 6 | Yes |
| 8.9 | 4 | Yes |
| 10.2 | 6 | Yes |
| 11.4 | 4 | Yes |
| 8.6 | 4 | Yes |
| 9.2 | 4 | Yes |
| 11.7 | 8 | Yes |
| 7.6 | 4 | Yes |
| 7 | 4 | Yes |
| 4.9 | 4 | No |
| 7.1 | 6 | No |
| 5 | 4 | No |
| 4.8 | 4 | No |
| 4.4 | 4 | No |
| 4.2 | 4 | No |
| 6.3 | 4 | No |
| 4.7 | 4 | No |
| 5.2 | 4 | No |
| 8.9 | 4 | No |
| 5.5 | 6 | No |
| 5.4 | 4 | No |
| 5.7 | 4 | No |
| 7.7 | 4 | No |
| 2.7 | 4 | No |
| 6.7 | 4 | No |
| 6.2 | 6 | No |
| 6.6 | 6 | No |
| 3.6 | 4 | No |
| 5 | 4 | No |
| 5.4 | 4 | No |
| 7.3 | 6 | No |
| 7.6 | 4 | No |
| 8.6 | 6 | No |
| 12.2 | 4 | No |
| 5.8 | 4 | No |
| 6.1 | 4 | No |
| 5.5 | 6 | No |
| 4.1 | 4 | No |
| 4.5 | 8 | No |
| 7.8 | 4 | No |
| 7 | 4 | No |
| 4.3 | 4 | No |
| 6.1 | 4 | No |
| 4.9 | 4 | No |
| 6.9 | 4 | No |
| 5.2 | 4 | No |
| 6.8 | 4 | No |
| 5.8 | 4 | No |
| 4.6 | 4 | No |
| 7.2 | 4 | No |
| 5.2 | 4 | No |
| 5.1 | 4 | No |
| 9.2 | 4 | No |
| 4.7 | 4 | No |
| 5.9 | 6 | No |
| 8 | 4 | No |
| 4 | 4 | No |
| 6.3 | 4 | No |
| 6.6 | 4 | No |
| 6.5 | 4 | No |
| 7.4 | 8 | No |
| 6.5 | 4 | No |
| 8.2 | 4 | No |
| 5.9 | 4 | No |
| 5.6 | 4 | No |
| 5.9 | 8 | No |
| 6.4 | 6 | No |
| 3.8 | 4 | No |
| 5.3 | 4 | No |
Identifying Good System Administrators. A management consultant is studying the roles played by experience and training in a system administrator's ability to complete a set of tasks in a specified amount of time. In particular, she is interested in discriminating between administrators who are able to complete given tasks within a specified time and those who are not. Data are collected on the performance of 75 randomly selected administrators. They are stored in the file SystemAdministrators.csv.
The attribute Experience measures months of full-time system administrator experience, while Training measures the number of relevant training credits. The target attribute Completed Task is either Yes or No, according to whether or not the administrator completed the tasks.
- Create and show a scatterplot of Experience versus Training using color or symbol to differentiate programmers who complete the task from those who did not complete it. Which predictor(s) appear(s) potentially useful for classifying task completion?
- Run a logistic regression model with both predictors using the entire dataset as training data. Show the screenshot of your logistic regression model and interpret it.
- Using the default threshold of 0.5 and the corresponding confusion matrix, answer the following. Among those who complete the task, what is the percentage of programmers who are incorrectly classified as failing to complete the task?
- To decrease the percentage in part (c), should the threshold probability be increased or decreased?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
