How many customers applied for new-car

Assignment Help Computer Engineering

Reference no: EM133702939

The worksheet Base Data in the Excel file Credit Risk Data provides information about 425 bank customers who had applied for loans. The data include the purpose of the loan, checking and savings account balances, number of months as a customer of the bank, months employed, gender, marital status, age, housing status and number of years at current residence, job type, and credit-risk classification by the bank.5

a. Use the COUNTIF function to determine (1) how many customers applied for new-car, used-car, business, education, small-appliance, and furniture loans and (2) the number of customers with checking account balances less than $500.

b. Modify the spreadsheet 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 between $250 but less than $2000, and high otherwise.

Reference no: EM133702939

Questions Cloud

What would the impact be if ivk keeps ivan korsky : What would the impact be if IVK keeps Ivan Korsky? Consider both to IVK as well as to the IT Department.

Write unit tests for your newly refactored system : Write unit tests for your newly refactored system Add new functionality to your system using Test-Driven Development

Describes how pediatric health history : Which best describes how pediatric health history and physical exam are different from adults?

What is president bidens foreign policy : Why is the U.S. involved with Ukraine? What is President Biden's foreign policy? How does different media report on U.S. policy towards Ukraine?

How many customers applied for new-car : How many customers applied for new-car, used-car, business, education, small-appliance, and furniture loans and (2) the number of customers with checking

What is role of dopamine and addiction in new technology : According to the article we just read, what is the role of dopamine and addiction in the new advertising technology?

Economic and financial outlook of public health initiative : For the Scholar-Practitioner, you take an in-depth look at the long term economic and financial outlook of a public health initiative

Which type of display ad is described : rotate the product around to see the product from different angles. The goal is to provide an immersive, interactive experience. Which type of display ad

How would you conclude the relationship : Based on your results, how would you conclude the relationship between attentional capacity and performance?

User Account

All Pages