Answered step by step
Verified Expert Solution
Question
1 Approved Answer
PROBLEM 1: (20 Marks) The Excel file Credit Risk Data provides information about bank customers who had applied for loans. The data include the purpose
PROBLEM 1: (20 Marks) The Excel file Credit Risk Data provides information about 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. This file is posted on Sakai in the Data Folder. Answer each question in a separate worksheet. a) Compute the combined checking and savings account balance for each record in the database. Then sort the records by the number of months as a customer of the bank. From examining the data, does it appear that customers with a longer association with the bank have more as sets? Construct a scatter chart to validate your conclusions. (7 marks) b) Use Excel's filtering capability to extract all records for new-car loans. Construct a pie chart showing the marital status associated with these loans. (6 marks) ITIS 1P97 Fall 2021 c) Use Excel's filtering capability to extract all records for individuals employed less than 12 months. Can you draw any conclusions about the credit risk associated with these individuals? (7 marks)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started