Define countif function

Assignment Help Finance Basics
Reference no: EM131438417

Question: 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.

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: EM131438417

Questions Cloud

How much is the total transportation cost : Suppose a shipment of 20,000 lbs is originated from point I. An additional 50,000 lbs is to be combined with it at point J and both shipments are to move on to point K. The transportation rate from point I to point J is $0.5/cwt. How much is the tota..
Nist programs compared to the iso standard : What areas, if any, are missing from the NIST publications? Identify the strengths and weaknesses of the NIST programs compared to the ISO standard.
Describe the importance of problemsolving as a key component : Problem-solving was first described by Professor Herman Goldstein. He authored the book Problem-Oriented Policing and has been at the forefront of this topic since its inception. Goldstein's research concluded that police agencies generally respon..
Non-revenue-generating part of the business : HR was often seen as a non-revenue-generating part of the business, or simply overhead. That misconception has changed dramatically due to technology. While HR is still not revenue generating, it adds a great deal of value to the business. You have b..
Define countif function : 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.
A companys business strategy includes rapid growth : A company’s business strategy includes rapid growth, including a 50% increase in staff over the next 2 years. Describe/explain how the use of HR technology can support this strategy, as it relates to staffing (including forecasting and tracking).
Alternative dispute resolution process : Share your thoughts in 250 words on the most important principles about setting up an Alternative Dispute Resolution Process, which is a process that helps parties resolve disputes without going to trial.
Stakeholders in the contract execution process : What are the various stakeholders in the contract execution process, and what are their roles and responsibilities? Provide examples with contract execution.
What constitutes different type of fake news on the internet : You will need to research what constitutes different types of fake news and misinformation on the Internet and how it is spread through social media.

Reviews

Write a Review

Finance Basics Questions & Answers

  Prepare a loan amortization schedule showing the interest

jill borrowed 15000 at a 14 annual rate of interest to be repaid over 3 years. the loan is amortized into three equal

  According to brooks 2013 actuaries use statistical methods

according to brooks 2013 actuaries use statistical methods to estimate the timing and cost of future undesirable

  Why do corporations utilize different forms of equity

Why do corporations utilize different forms of equity?- On what balance sheet accounts does the issuance of common stock have an effect?

  How a firm can legitimately choose between two such projects

Suppose that a firm must choose between two mutually exclusive projects, both of which have negative NPVs. Explain how a firm can legitimately choose between two such projects.

  What kind of credit policy will you implement and why what

what kind of credit policy will you implement and why? what do you think your collection period will be? explain your

  A firm currently purchases economic order quantity q of the

a firm currently purchases the economic order quantity q of a particular item from its supplier. the supplier is

  Explain project evaluation through npv

Explain Project evaluation through NPV and ignore small rounding differences between your answer and the choices given

  Training at the newly open changi airport casino

Singapore's newly opened 3rd casino, CAC caters to the needs of travelers, tourists, and thrill-seekers on transit or holiday in Singapore.

  Computing average monthly payment for a car

You are the owner of a used car business near the York campus. Your company borrows money from a bank on a line of credit with a monthly interest rate of 0.50%.

  On a single graph plot the 1-year short-term 5-year and

on a single graph plot the 1-year short-term 5-year and 10-year intermediate-term and 20-year long-term yields of the

  What is the loss or gain to a swiss investor who holds this

What is foreign exchange risk? What does it mean for an FI to be net long in foreign assets? What does it mean for an FI to be net short in foreign assets? In each case, what must happen to the foreign exchange rate to cause the FI to suffer losses?

  What is your holding period return

You purchased 100 shares of General Motors stock at a price of $98.64 one year ago. You sold all stocks today for $100.44. During the year, the stock paid dividends of $5.60 per share. What is your holding period return?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd