Altair Monarch Learning Series 2023 Exercise 3 Solution : FDIC Failed Bank List

Baba_Majekodunmi_703
Baba_Majekodunmi_703
Altair Employee
edited September 2023 in Altair RapidMiner

Exercise Info

  • Application (Classic vs Data Prep Studio): Data Prep Studio
  • Level of Difficulty (Beginner, Intermediate, Advanced): Beginner
  • Skills/Features Tested: Split, Group By, Duplicate, Analyze (Summary)
  • Systems of Record: Not Applicable
  • Estimated Time to Solve: 10 mins
  • Exercise files required are attached
    • FDIC Failed Bank List.txt

Exercise Overview

You are a new Financial Analyst at the FDIC and your manager has asked you to perform some analytics on the FDIC List of Failed Banks to answer the following questions:

  1. Which year had the most number of bank failures?
  2. Which state has had the most number of bank failures?
  3. Which bank has acquired the most failed banks?

Exercise Answer

Not sure you got the correct answer? No problem. Watch the video below for a demonstration of this exercise from start to finish.

 


Tagged:

Categories