Trying to Compare BL% to Cost-Scholarship -- Need Help
Posted: Mon Nov 23, 2015 2:16 am
Okay, so I started a spreadsheet to try and rank schools based on costs and big law percentage over the last 3 years. I took the BL rate over the last three years and averaged it. Then I subtracted this number from 100%. I looked at mylsn to find the average scholarship a student with my numbers (splitter) got over the last three years, subtracted that from the total costs, and multiplied that number by the average non-BL number to get the following figures:
W/M: $101.8k
Cornell: $119.2k
Alabama: $125.49k
WUSTL: $133.28k
Texas: $146.88k
etc.
The problem is I don't think this ranking makes sense for someone who is aiming for big law. I need to change the formula somehow to give BL% a bigger impact. Can someone tell me how these numbers are inaccurate or potentially a better way of doing this? Or is this kind of analysis silly to attempt? (If so, why and what is the better way of doing it?)
Thanks
W/M: $101.8k
Cornell: $119.2k
Alabama: $125.49k
WUSTL: $133.28k
Texas: $146.88k
etc.
The problem is I don't think this ranking makes sense for someone who is aiming for big law. I need to change the formula somehow to give BL% a bigger impact. Can someone tell me how these numbers are inaccurate or potentially a better way of doing this? Or is this kind of analysis silly to attempt? (If so, why and what is the better way of doing it?)
Thanks