Modify the accompanying credit risk data using IF functions to include new columns, classifying the checking...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Modify the accompanying credit risk data using IF functions to include new columns, classifying the checking and savings account balances as low if the balance is less than $250, medium if at least $250 but less than $2000, and high otherwise Click the icon to view the Credit Risk data. Classify the checking and savings account balances as low, medium, or high A B C D E F G 1 Loan Purpose Checking Savings Gender Marital Checking Savings Account Status Account Status Status Single Married Single Single Divorced 2 Education 3 Business 800 4 New Car 250 5 Furniture 91 3 Small Appliance 400 690 600 Business Education 880 Retraining 344 Small Appliance 100 Repairs 0 4500 800 250 4871 300 3000 800 2000 10000 700 M F M F M M F M F M Single Married Single Single Divorced ▼ ▼ ▼ ▼ ▼ V ▼ ▼ ▼ ▼ ▼ ▼ Credit Risk Data Loan Purpose Checking Savings 4500 800 250 4871 300 3000 800 2000 10000 700 Education 600 Business 800 New Car 250 Furniture 91 Small Appliance 400 Business 690 Education 880 Retraining 344 Small Appliance 100 Repairs 0 Print Gender M FMFNZLZL N M Done Marital Status Single Married Single Single Divorced Single Married Single Single Divorced U X omework ← 2 Education 3 Business Classify the checking and savings account balances as low, medium, or high. A B C E 1 Loan Purpose Checking Savings Gender Marital Status Single Married Single Single Divorced Modify the accompanying credit risk data using IF functions to include new columns, classifying the checking and savings account balances as low if the balance is less than $250, medium if at least $250 but less than $2000, and high otherwise. Click the icon to view the Credit Risk data. 600 800 250 5 Furniture 91 6 Small Appliance 400 7 Business 690 8 Education 880 9 Retraining 344 10 Small Appliance 100 11 Repairs 0 4 New Car 4500 800 250 4871 300 3000 800 2000 10000 700 M F M F M M lu F MF M < Single Married Question 5, 2.3.19 > Single Single Divorced F Checking Savings Account Status Account Status G Medium Low HW Score: 50.23%, 50.23 of 100 points Points: 0 of 10 High Save Modify the accompanying credit risk data using IF functions to include new columns, classifying the checking and savings account balances as low if the balance is less than $250, medium if at least $250 but less than $2000, and high otherwise Click the icon to view the Credit Risk data. Classify the checking and savings account balances as low, medium, or high A B C D E F G 1 Loan Purpose Checking Savings Gender Marital Checking Savings Account Status Account Status Status Single Married Single Single Divorced 2 Education 3 Business 800 4 New Car 250 5 Furniture 91 3 Small Appliance 400 690 600 Business Education 880 Retraining 344 Small Appliance 100 Repairs 0 4500 800 250 4871 300 3000 800 2000 10000 700 M F M F M M F M F M Single Married Single Single Divorced ▼ ▼ ▼ ▼ ▼ V ▼ ▼ ▼ ▼ ▼ ▼ Credit Risk Data Loan Purpose Checking Savings 4500 800 250 4871 300 3000 800 2000 10000 700 Education 600 Business 800 New Car 250 Furniture 91 Small Appliance 400 Business 690 Education 880 Retraining 344 Small Appliance 100 Repairs 0 Print Gender M FMFNZLZL N M Done Marital Status Single Married Single Single Divorced Single Married Single Single Divorced U X omework ← 2 Education 3 Business Classify the checking and savings account balances as low, medium, or high. A B C E 1 Loan Purpose Checking Savings Gender Marital Status Single Married Single Single Divorced Modify the accompanying credit risk data using IF functions to include new columns, classifying the checking and savings account balances as low if the balance is less than $250, medium if at least $250 but less than $2000, and high otherwise. Click the icon to view the Credit Risk data. 600 800 250 5 Furniture 91 6 Small Appliance 400 7 Business 690 8 Education 880 9 Retraining 344 10 Small Appliance 100 11 Repairs 0 4 New Car 4500 800 250 4871 300 3000 800 2000 10000 700 M F M F M M lu F MF M < Single Married Question 5, 2.3.19 > Single Single Divorced F Checking Savings Account Status Account Status G Medium Low HW Score: 50.23%, 50.23 of 100 points Points: 0 of 10 High Save
Expert Answer:
Related Book For
Business Analytics Methods Models and Decisions
ISBN: 978-0321997821
2nd edition
Authors: James R. Evans
Posted Date:
Students also viewed these accounting questions
-
Modify the accompanying credit risk data using IF functions to include new columns, classifying the checking and savings account balances as low if the balance is less than $250, medium if at least...
-
A B C D E F G 1 Suppose the risk free interest rate is 4%. Calculate the following using the EXCEL functions. 2 3 Having $500 today is equivalent to having what amount in one year? 4 Present value...
-
The MidLands Trucking Company based in Louisville has eight trucks located throughout the Mideast that have delivered their loads and are available for shipments. Through their Internet logistics...
-
Consider a situation with two countries that have abatement cost functions : for j=L and j=H. The countries have identical damage functions D(E)= d.E.For each country the parameters s j are drawn...
-
When the effective interest rate is higher than the stated interest rate on a bond issue, will the bond sell at a discount or premium? Why?
-
Find two numbers whose difference is 15 and whose product is a minimum.
-
Consider the gasoline mileage performance data in Table B.3. a. Use the all-possible-regressions approach to find an appropriate regression model. b. Use stepwise regression to specify a subset...
-
Where, if at all, should the following items be classified on a balance sheet? (a) Goods out on approval to customers. (b) Goods in transit that were recently purchased f.o.b. destination. (c) Land...
-
Required information [The following information applies to the questions displayed below.] In January, Tongo, Incorporated, a branding consultant, had the following transactions. a. Received $18,400...
-
Ellen considered saving $10,000 per year for her retirement. Although $10,000 is the most she can save in the first year, she expects her salary to increase each year so that she will be able to...
-
There is an (intentional) error in the 10/01/2024 bond quotation. Compare the Coupon rate, the Asked price, and the Asked yield. What is the error? 3 t 0 8 Table 9.1 Date 15-Sep 10-Nov Table 9.2 t...
-
A dressmaker can sew 800 garments with 160 bolts of fabric and 3,000 hours of labor. Another dressmaker can sew 800 garments with 200 bolts of fabric and 2,000 hours of identical labor. Fabric costs...
-
A major survey conducted by economists David Levine and Laura Tyson found that in most reported cases the introduction of substantive shop floor participation (job redesign and participatory work...
-
The cost of setting up a steel mill is enormous. For example, a Gary, Indiana, hot-strip mill would cost an estimated $1.5 billion to build. Using this information and the cost concepts from the...
-
When economist Jacob Viner first developed the envelope relationship, he told his draftsman to make sure that all the marginal cost curves went through both (1) the minimum point of the short-run...
-
In the book Why Not? Yale professors Barry Nabalof and Ian Ayres suggest that computers that record driver behavior (similar to the black boxes in planes that record crashes) be installed in cars. In...
-
Compute the employer's payroll benefit expense based on the following totals found on a completed payroll register dated November 15. Gross pay=$41,400.00 Deductions: Income Tax=$6,350.00;...
-
The following information is available for Partin Company: Sales $598,000 Sales Returns and Allowances 20,000 Cost of Goods Sold 398,000 Selling Expense 69,000 Administrative Expense 25,000 Interest...
-
A financial consultant has an average of 7 customers he consults with each day, which are assumed to be Poisson distributed. The consultants overhead requires that he consult with at least 5...
-
Use Analytic Solver Platform to fit the hurricane data to a discrete distribution? Does the Poisson distribution give the best fit? The number and frequency of Atlantic hurricanes annually from 1940...
-
A popular soft drink is sold in 2 liter (2,000milliliter) bottles. Because of variation in the filling process, bottles have a mean of 2,000 milliliters and a standard deviation of 18, normally...
-
Give some examples of models in which the dependent variable is a count variable.
-
Explain why estimation of a supply and demand model requires an alternative to ordinary least squares (OLS).
-
Describe what is meant by the phrase "sample selection."
Study smarter with the SolutionInn App