Off-campus South Dakota State University users: To download campus access theses, please use the following link to log into our proxy server with your South Dakota State University ID and password.
Non-South Dakota State University users: Please talk to your librarian about requesting this thesis through interlibrary loan.
Thesis - University Access Only
Master of Science (MS)
Department / School
Mathematics and Statistics
By exploring a cluster analysis, a company can segment their customers to create more effective marketing strategies. They can also design products to fit each segment of customers. Cluster analysis involves placing similar objects into groups. In this project, a cluster analysis was completed on the customer portfolio of a community bank. Community banks tend to have fewer resources than large national banks, and they achieve goals by creating relationships with their customers to help spur economic growth within their community. This cluster analysis examined both demographic and account activity information of active customers throughout the year 2013. Using the bank’s database, a query was written to obtain 22 variables portraying 31,108 individual customers. Once the data was gathered, necessary variables were transformed and normalized in order to bring the variables closer to normal distribution, as well as provide equal weight to each variable during the analysis. After exploring multiple options, the clustering method applied was hierarchical clustering using Ward’s minimum variance criterion with Euclidean distances. As a result, five clusters were formed. Key variables in the analysis were found to be average balance and number of transactions for different account types. Cluster A was characterized by customers with high savings balances and number of transactions. Customers in Cluster B can be described as having high loan balances and number of transactions. If a customer has high CD balance and number of transactions, that customer tends to belong in Cluster C. Cluster D can be distinguished by customers who participate in online banking and receive e-statements. Lastly, Cluster E consists of customers with characteristics of a checking account, but little to no other products. These five clusters were validated by comparing multiple random selections of the dataset. It was seen that this cluster analysis provides insight into the different customer types found within a community bank. Because product types characterize the clusters, the customer segments are product driven. From this analysis, the marketing and retail departments in the bank can better align their strategies based upon the customer segments they are working with.
Library of Congress Subject Headings
Includes bibliographical references (page 68)
Number of Pages
South Dakota State University
In Copyright - Non-Commercial Use Permitted
Cundy, Lance, "Customer Portfolio Cluster Analysis in a Community Bank" (2014). Electronic Theses and Dissertations. 1557.