Finding Patterns in Customer Data of Online Page Visits

TaxHawk is an online tax filing service here in Provo and this semester they ordered an On-Campus Internship to preform statistical analyses to determine what makes a user of their service either complete their taxes or abandon the process before completing.  One of the things they wanted us to examine is if any of the order pattern in which users hit the pages had any statistical significance. This is the problem I attempted to answer. They gave us data from users and the order they hit each page and I created a Visual Basics Sub Procedure that compares each user with all other users in the data set and finds any common patterns in the order they hit the pages. The Sub Procedure asks for a csv file containing user data, then finds the patterns among the users included in that sample, and finally returns a csv file including a list of all users and the found patterns marking the users that followed the patterns.

• http://files.gove.net/shares/files/15f/tannerwj/Final.zip
• http://files.gove.net/shares/files/15f/tannerwj/Macro.xlsm
• http://files.gove.net/shares/files/15f/tannerwj/Project.pdf
• http://files.gove.net/shares/files/15f/tannerwj/test1.csv