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.

  1. 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?
  2. 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.
  3. 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?
  4. 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!