Summer Intern Series: Bank Rank with Jacob Ledbetter

Posted by Melissa Cichantek on 8/14/15 3:36 PM

--------------------------------------------------------

* Welcome to the fourth post in Summit's 2015 Summer Intern Series! See below for Summer Analyst Jacob Ledbetter’s essay. Click here to learn more about our Summer Analyst/Associate program. *

One year ago, I moved out of Alabama for the first time and quickly realized that I would not be able to keep banking at the local credit union where I opened an account when I was a kid. As I began searching for another bank, I discovered that there was no hub for banking information that took into account the consumer’s experience. Several online rating systems focus primarily on metrics such as the interest rate offered by the bank. However, with current interest rates near zero, income from checking account interest amounts to only a couple dollars each year. Why would a consumer make such a large decision based on this small amount of money?

To combat this issue, I pinpointed five metrics to quantify customer banking experiences and identified sources which spoke to each of these topics: 

ledbetter_pie_chart1
  1. Convenience: Number of branches by ZIP code, taken from a Data.Gov database
  2. Fundamental Confidence: 5-Star Rating from BankRate.com based on a bank’s capital adequacy, asset quality, profitability, and liquidity
  3. Consumer Complaints: Number of complaints registered with the Consumer Finance Protection Bureau, by branch location
  4. Employee Friendliness: Rating of the bank by its employees from Glassdoor.com
  5. Twitter Chatter: Sentiment analysis score based on tweets about the bank, gathered using Python
One of the most interesting tools I came across in this project is a sentiment analysis tool called VADER Sentiment, a Python package which quantifies the sentiment of text into a -4 to +4 rank, negative sentiment to positive sentiment, based on the definition of words and their contextual meaning.[1] Developed specifically for analyzing posts on microblogs such as Facebook and Twitter, this program also generalizes well to other texts and can be a useful tool for quickly quantifying the sentiment of normally exclusively qualitative text. 

After gathering the data, I combined these five metrics based on specific weights to create an index by which to judge each bank. Each bank’s score is a weighted sum of the scores they got in each category:

  • First, I standardized units by setting each category’s score to a percentage of the max value of that category.
  • Second, I multiplied each category’s score by the category’s weight before adding scores from different categories together for possible total of 7 points. Each category was added as a positive value, except for Consumer Complaints, which could subtract at most three points from the score. 

To test this ranking system, I looked at the 26 banks and credit unions in Albany, New York and generated the index value for each institution. The ranking clearly delimits the differences among banks based on their scores, solving the information problem among consumers. This type of consumer-focused ranking system could offer a better way to find a bank that best fits each person’s need.

ledbetter_bar_chart

[1] Hutto, C.J. & Gilbert, E.E. (2014). VADER: A Parsimonious Rule-based Model for Sentiment Analysis of Social Media Text. Eighth International Conference on Weblogs and Social Media (ICWSM-14). Ann Arbor, MI, June 2014. http://comp.social.gatech.edu/papers/icwsm14.vader.hutto.pdf

Topics: Summit Blog, summer interns

About the Summit Blog

Complexity simplified.

Summit is a specialized analytics advisory firm that guides clients as they decode their most complex analytical challenges. Our blog highlights the strategies and techniques we use, as well as relevant topics in current events.

Subscribe to Email Updates

Recent Posts

Posts by Topic