Question: Extract the records for business loans in the Excel file Credit Risk Data and code the non-numerical data. Apply discriminant analysis to classify the credit

Extract the records for business loans in the Excel file Credit Risk Data and code the non-numerical data. Apply discriminant analysis to classify the credit risk for the business loans in the Records to Classify worksheet.

Step by Step Solution

★★★★★

3.40 Rating (162 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Credit Risk Data Loan Purpose Checking Savings Months Customer Months Employed Gender Marital Status Age Housing Years Job Credit Risk Discriminant Score Business 0 533 14 2 1 0 27 0 1 0 0 00670 Busin... View full answer

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

Refer to the Kelson Sporting Equipment problem (Chapter 2, Problem 24). Letting R = number of regular gloves C = number of catcher's mitts Leads to the following formulation: Max 5R + 8C s.t. R +...

Number the rows in the Excel file Credit Risk Data to identify each record. The bank wants to sample from this database to conduct a moredetailed audit. Use the Excel Sampling tool to find a simple...

The Excel file Credit Risk Data provides information about bank customers who had applied for loans. 6 The data include the purpose of the loan, checking and savings account balances, number of...

The Excel file Credit Risk Data provides a database of information about loan applications along with a classification of credit risk in column L. Convert the categorical data into numerical codes as...

Extract the records for business loans in the Excel file credit risk data and code the non-numerical data. Apply discriminate analysis to classify the credit risk for the business loans in the...

Extract the records for business loans in the Excel file Credit Risk Data and code the non-numerical data. Apply discriminant analysis to classify the credit risk for the business loans in the...

Chapter 10 question 16PE from James R. Evans Business Analytics. Provide data results and how to create the model. Also, include thorough analysis of results. Business Analytics (2nd Edition) E...

all needed information is supplied. Please show steps and processes in excel Using the approach described In 10.6, classify the first record in the worksheet Records to Classify In the Excel file...

7. Using the approach described in Example 10.6, clas- sify first record in the worksheet Records to Classify in the Excel file Credit Risk Data using the k-NN algorithm for k = 1 to 5. Use only...

The Excel file Credit Risk Data provides information about bank customers who had applied for loans. The data include the purpose of the loan, checking and savings account balances, number of months...

Use the Excel file credit risk data that was introduced in this chapter to perform the following activities: A ) Compute the combine checking and savings account balance for each record in the base...

How does adjusted exponential smoothing differ from exponential smoothing?

List one advantage and one disadvantage of the account classification method.

Maria wants to sell her 6 0 0 shares of Aena stock at the going market price after the stock drops below $ 4 2 a share. Aena is currently trading at $ 5 0 per share. Which type of order should she...

=+20. House prices, part 2. Exercise 18 shows computer output examining the association between the sizes of houses and their sale prices.

Hams Used Cars sells cars with an upward trend based on time and the degree of bad weather. Weather is scored with 1 being bad weather and 5 being great weather. Using the following multiple...

A linear regression model is Units = 3,014 0.639*Week. For week 38, what is the forecast for the number of units?

A small airplane company called Just In Time flies between cities in Florida. It is trying to decide whether to add one extra plane to its fleet next year. Passenger demand that last four quarters...

You are looking to buy a car. You can afford $640 in monthly payments for five years. In addition to the loan, you can make a $740 down payment. If interest rates are 8.25 percent APR, what price of...

Consider a T - bill with a rate of return of 5 percent and the following risky securities: Security A : E ( r ) = 0 . 1 5 ; Variance = 0 . 0 4 Security B : E ( r ) = 0 . 1 0 ; Variance = 0 . 0 2 2 5...

If Benji had received a loan with 10 year amortization instead of 5 year amortization, but the loan was still due in 5 years (this is called a "balloon loan"), how much principal would be owed by...