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