Question: Identifying Good System Administrators. A management consultant is studying the roles played by experience and training in a system administrators ability to complete a set

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 is either Yes or No, according to whether or not the administrator completed the tasks.

a. Create a scatter plot of Experience vs. Training using color to distinguish programmers who completed the task from those who did not complete it. Which predictor(s) appear(s) potentially useful for classifying task completion?

b. Run a logistic regression model with both predictors using the entire dataset as training data. Among those who completed the task, what is the percentage of programmers incorrectly classified as failing to complete the task?

c. To decrease the percentage in part (b), should the probability threshold be increased or decreased?

d. How much experience must be accumulated by a programmer with four years of training before his or her estimated probability of completing the task exceeds 0.5?

Step by Step Solution

3.43 Rating (162 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

a To create a scatter plot of Experience vs Training and distinguish between administrators who completed the task and those who did not you can use a plotting library like Matplotlib in Python The co... View full answer

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 Essentials Business Analytics Questions!