Based on the data, estimate a model that can explain administrators’ ability to complete a set of tasks.

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

Instructions: 

• This is an individual student assignment.

• Submit via Blackboard only. No email submissions will be accepted.

• Copy and paste any SAS codes/outputs nicely and refer to them in your answers.

• Type your answers below each question/sub-question. Do not remove this template.

• Bonus points will be given for good presentation of answers.

• Submit one file.

A. (30 points)

A management consultant is interested in understanding the effect of experience and training in an administrator’s ability to complete a set of tasks in a specified amount of time. The consultant has access to data (adminstrators.csv) on the performance of 75 randomly selected administrators. The variable Experience measures months of administrator experience and the variable Training measures the number of relevant training credits. The variable Completed captures whether administrator completed a set of tasks or not. 

Use SAS for your analysis.

1. Based on the data, estimate a model that can explain administrators’ ability to complete a set of tasks. Use the entire dataset for analysis. Comment on the model output and the results. 

2. Among those who completed the task, what is the percentage of administrators incorrectly classified as failing to complete the task? 

3. How much experience must be accumulated by an administrator with four units of training before the estimated probability of completing the task exceeds 0.5 for the administrator?

B. Read the article titled, “Pilgrim Bank (A): Customer Profitability” available in Coursepack and answer the following questions. Note: Use the excel file that is provided as an supplement with the case. I have also provided an excel version of the case. Refer to the case for the meaning of the variables. In the excel file that I have shared, the numbers 9 and 0 in the variable names refer to the year 1999 and 2000. (20 points).

1. What are the strategies that retail banks use to convert unprofitable customers into profitable customers? What strategy do banks pursue to increase retention of their highest profit customers? Briefly comment. 

2. Analyze the data and examine if profitability of customers affects their likelihood of being retained by the bank. Comment.  

Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme