Business, 15.02.2021 19:40 aliami0306oyaj0n

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.1. Use the COUNTIF function to determine (1) how many customers applied for new-car, usedcar, business, education, small-appliance, and furniture loans and (2) the number of customers with checking account balances less than $500.2. 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.

Answers: 3

Show answers

Other questions on the subject: Business

Business, 21.06.2019 15:30, shaelyn0920

Walter wants to deposit $1,500 into a certificate of deposit at the end of each ofthe next 6 years. the deposits will earn 5 percent compound annual interest. ifwalter follows through with his plan, approximately how much will be in his accountimmediately after the sixth deposit is made?

Answers: 1

continue

Business, 22.06.2019 01:00, reagriffis24

How does the economy of cuba differ from the economy of north korea? in north korea, the government’s control of the economy has begun to loosen. in cuba, the government maintains a tight hold over the economy. in cuba, the government’s control of the economy has begun to loosen. in north korea, the government maintains a tight hold over the economy. in north korea, there is economic uncertainty in exchange for individual choice. in cuba, there is economic security in exchange for government control. in cuba, there is economic uncertainty in exchange for individual choice. in north korea, there is economic security in exchange for government control.\

Answers: 2

continue

Business, 22.06.2019 14:30, SophieCasey

The state in which the manufacturing company you work for is located regulates the presence of a particular substance in the environment to concentrations ≤ x. recently-released, reliable research endorsed by the responsible federal agency conclusively demonstrates that the substance poses no risks at concentrations up to 5x. your company has asked you to consider designing a new process with a waste discharge stream containing up to 2x of the substance. based on the stated conditions, describe this possible.

Answers: 2

continue

Business, 22.06.2019 22:00, emilyswinge4421

Exercise 2-12 cost behavior; high-low method [lo2-3, lo2-4] speedy parcel service operates a fleet of delivery trucks in a large metropolitan area. a careful study by the company’s cost analyst has determined that if a truck is driven 120,000 miles during a year, the average operating cost is 11.6 cents per mile. if a truck is driven only 80,000 miles during a year, the average operating cost increases to 13.6 cents per mile. required: 1.& 2. using the high-low method, estimate the variable and fixed cost elements of the annual cost of truck operation. (round the "variable cost per mile" to 3 decimal places.)

Answers: 3

continue

You know the right answer?

The worksheet Base Data in the Excel file Credit Risk Data provides information about 425 bank custo...