Business Analytics (2nd Edition)
2nd Edition
ISBN: 9780321997821
Author: James R. Evans
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 2, Problem 4PE
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
5Based on Efraim Turban. Ranesh Sharda, Dursun Delen and David king Business Intelligence: A Managenal Approach. 2nd ed. (Upper Saddle River NJ: Prentice Hall, 2011).
- 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
- 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
Expert Solution & Answer
Trending nowThis is a popular solution!
Chapter 2 Solutions
Business Analytics (2nd Edition)
Ch. 2 - The Excel file Presidents Inn Guest Database...Ch. 2 - The worksheet Base Data in the Excel file Credit...Ch. 2 - A manager needs to identify some information from...Ch. 2 - Example 1.4 in Chapter 1 described a scenario for...Ch. 2 - Example 1.8 in Chapter 1 provided data from an...Ch. 2 - The following exercises use the Purchase Orders...Ch. 2 - Use INDEX and MATCH functions to fill in a table...Ch. 2 - Suppose that a company offers quantity discounts....
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Similar questions
Recommended textbooks for you
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillCollege Algebra (MindTap Course List)AlgebraISBN:9781305652231Author:R. David Gustafson, Jeff HughesPublisher:Cengage LearningCalculus For The Life SciencesCalculusISBN:9780321964038Author:GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.Publisher:Pearson Addison Wesley,
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning
Calculus For The Life Sciences
Calculus
ISBN:9780321964038
Author:GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:Pearson Addison Wesley,
Sampling Methods and Bias with Surveys: Crash Course Statistics #10; Author: CrashCourse;https://www.youtube.com/watch?v=Rf-fIpB4D50;License: Standard YouTube License, CC-BY
Statistics: Sampling Methods; Author: Mathispower4u;https://www.youtube.com/watch?v=s6ApdTvgvOs;License: Standard YouTube License, CC-BY