Fit and evaluate regression model with data replacement

Assignment Help Business Management

Reference no: EM131226316

Enterprise Business Intelligence SAS Enterprise Miner Assignment-

Task -

Business Case: A financial services company offers a home equity line of credit to its clients. The company has extended several thousand lines of credit in the past, and many of these accepted applicants (approximately 20%) have defaulted on their loans. By using geographic, demographic, and financial variables, the company wants to build a model to predict whether an applicant will default.

After analyzing the data, the company selected a subset of 12 predictor (or input) variables to model whether each applicant defaulted. The response (or target) variable BAD indicates whether an applicant defaulted on the home equity line of credit. These variables, along with their model role, measurement level, and description are shown in the following table.

The SAMPSIO.HMEQ data set contains 5,960 observations for building and comparing competing models. The data set is split into training, validation, and test data sets for analysis.

Tasks

1. Create a project, library, identify the data source

2. Identify your input data using the table above

3. Partition the data by adding the data partition node (Training - 40% Validation - 30% and Test - 30%)

4. Inspect the distribution of the values in the input data for each variable

5. Fit and evaluate regression model with data replacement by adding a regression model to the diagram

6. Is this model useful? (Hint: If the model is useful, the proportion of individuals that defaulted on a load is relatively high in the top deciles and the plotted curve is decreasing).

7. Explore the DEBTINC variable, are there missing values and what is the implication for a regression model?

8. Do you think imputation is required and if yes for what reason?

9. Use the Impute node to impute missing values in the input data set if it requires imputation to properly fit the regression model

10. Set the value of Type to Single to create a single indicator variable that indicates whether any variable was imputed for each observation. Set the value of Type to Unique to create an indicator variable for each original variable that identifies if that specific variable was imputed. For this example, set the value of Type to None

11. Add a new regression node and connect to impute node and run

12. Comment on the new statistics for the first decile

a. What is the cumulative % response

b. What is the % response

c. Cumulative lift

13. Finally relate responses to the business problem and comment on the business implication.

Attachment:- Data.rar

Reference no: EM131226316

Questions Cloud

Ensure expectations are being met : What are we talking about in practice when it comes to organize resources, control the results, and ensure expectations are being met?

Discuss the organizational culture and diversity : Discuss the single most significant lesson you learned in this course that relates to leadership and management or organizational culture and diversity.

What is the purpose of trade sales promotions : What is the purpose of trade sales promotions? Identify three types of trade sales promotions that Frito-Lay should use to increase sales. Specifically how should these be implemented?

What are marcuss ethical obligations to the company : What, if any, are the ethical considerations in this situation? What are Marcus's ethical obligations to the company? To his friend?

Fit and evaluate regression model with data replacement : BUS5EBI Enterprise Business Intelligence SAS Enterprise Miner Assignment. Inspect the distribution of the values in the input data for each variable. Fit and evaluate regression model with data replacement by adding a regression model to the diagram

Draft a accounting memo discussing the accounting treatment : Draft a single accounting memo discussing the accounting treatment of each issue below. Specifically, determine whether actual adjustment of the December 31, 2015 financial statements.

Discuss the reach of each communication channel : Evaluate the merits and drawbacks of the channel options in relation to the target audience, your product or service, and the timing of the launch phase.

Write metric prefix and unit name for each of abbreviations : Write the metric prefix and unit name for each of the abbreviations shown. - MW - nA - uJ - mS - K ohm symbol - GHz.

Explain how the account of biblical creation can be viewed : Explain how the account of biblical creation can be viewed as a model for innovative and creative leaders when managing chaos.

Reviews

len1226316

9/30/2016 3:40:44 AM

This is an individual assignment and it covers of the total assessment for BUS5EBI. The submitted work should include the following: SAS Enterprise Miner Assignment File. Please copy the entire folder, and not just the project.emp file. Naming Format (EBIAssignment_StudentID) and the online Academic integrity module and statement of student responsibility will suffice for the individual statements of authorship so do not worry about attaching a copy. You will find data in SAS. According to assignment, The SAMPSIO.HMEQ data set contains 5,960 observations for building and comparing competing models. The data set is split into training, validation, and test data sets for analysis. Just also I want mention that should use (SAS Enterprise Miner). Also I want to help me and make ppt file for presentation.

Write a Review

Required(*) Message

User Account

All Pages