Question
A management consultant is studying the roles played by experience and training in a system administrator's ability to contest a list of tasks in a
A management consultant is studying the roles played by experience and training in a system administrator's ability to contest a list of tasks in a specific amount of time. In particular, she is interested in discriminating between administrators who are able to complete given tasks within a specific time and those who are not. Data are collected on the performance of 75 randomly selected administrators. Data link is attached below
Data link: https://docs.google.com/spreadsheets/d/1IT5QtJkNCt85OLF6gw4cg6n6-sOc3H2ebwuhSO3ZqOM/edit?usp=sharing
The variable Experience measures months of full-time system administrator experience, while Training measures the number of relevant training credits. The dependent variable Completed is either Yes or No, according to whether or not the administrator completed the tasks.
a. Make a scatter plot 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 used for classifying task completion?
b. Run a logistic regression model with both predictors using the entire dataset as training data. Among those who complete the task, what is the percentage of programmers who are incorrectly classified as failing to complete the task?
c. To decrease the percentage in part (c), should the cutoff probability be increased or decreased?
d. How much experience must be accumulated by a programmer with 4 years of training before his or her estimated probability of completing the task exceeds 50%?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started