Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. problem 1: (20 marks) the excel file credit risk d

PROBLEM 1: (20 Marks) The Excel file Credit Risk Data provides information about bank customers...

50.1K

Verified Solution

Question

Accounting

image
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)

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

Muscle types do differ in their anatomies; we’ve learned only about the most common types. Mark...

Medical Sciences
Q

Show how the Splaying techniques (Zig, Zag, Zig-Zag, Zag-Zig, Zig-Zig, Zag-Zag) works in Splay Trees Insertion...

Programming
Q

2.5 Use the de Broglie relation λ=h/p to find the wavelength of electrons with kinetic energy...

Physics
Q

iv In a Young s double slit experiment the slit separation is doubled To maintain...

Physics
Q

Determine the currents I I and I for the electrical network shown in the figure...

Basic Math
Q

2 An embankment having a volume of 420 000 yd3 is to be constructed from...

Basic Math
Q

2.2 Merry Motors specializes in the manufacture of small capacity motors. The following information is...

Accounting
Q

Please identify one of the most commonly used accounting methods? Cash Basis Financial Accounting Short-term...

Accounting
Q

Hazelton Corporation uses a periodic inventory system and the LIFO method to value its inventory....

Accounting
Q

Caicuiate the discount period for the bank to wait to receive its money: (Use Days...

Finance
Q

Question 16 3 pts Your friend has asked you to evaluate profitability of his plan...

Finance
Q

Star Company completed the below transactions during 2020. Record the journal entries. a. Owners...

Accounting