Class Rank Estimator Forum
-
- Posts: 87
- Joined: Sat Feb 05, 2011 6:01 pm
Re: Class Rank Estimator
Neat tool!
I tried a different methodology, using the actual grade distributions posted for our section's exams and running a simulation for a hypothetical class of 3,200 students. My free variable is the correlation of grades across courses each student. I hypothesized that there should be positive correlation, since students who do well in class x are more likely to do well in class y. Obviously, higher correlation pushes the cut-offs up a bit.
For the curious, here's a selection of estimated class rank cut-offs at GULC based on first semester 1L grades (in my section).
Top [x%]...Cut-off GPA
1%...3.91
2%...3.87
3%...3.84
4%...3.81
5%...3.78
6%...3.76
7%...3.75
8%...3.72
9%...3.71
10%...3.69 ***NOTE: I calibrated the correlation variable to hit this number***
15%...3.62
33%...3.44
50%...3.32
PM me if you're curious about the methodology and sensitivity. Spreadsheet is too cumbersome to post to GoogleDocs, unfortunately.
I tried a different methodology, using the actual grade distributions posted for our section's exams and running a simulation for a hypothetical class of 3,200 students. My free variable is the correlation of grades across courses each student. I hypothesized that there should be positive correlation, since students who do well in class x are more likely to do well in class y. Obviously, higher correlation pushes the cut-offs up a bit.
For the curious, here's a selection of estimated class rank cut-offs at GULC based on first semester 1L grades (in my section).
Top [x%]...Cut-off GPA
1%...3.91
2%...3.87
3%...3.84
4%...3.81
5%...3.78
6%...3.76
7%...3.75
8%...3.72
9%...3.71
10%...3.69 ***NOTE: I calibrated the correlation variable to hit this number***
15%...3.62
33%...3.44
50%...3.32
PM me if you're curious about the methodology and sensitivity. Spreadsheet is too cumbersome to post to GoogleDocs, unfortunately.
-
- Posts: 18
- Joined: Fri Jun 24, 2011 6:14 pm
Re: Class Rank Estimator
nice. thanks for doing the work on this!
-
- Posts: 10
- Joined: Mon May 09, 2011 9:11 pm
Re: Class Rank Estimator
NYC Law wrote:Should be good to go now. The editable class rank calc is the first page. If you click the tab at the bottom for the locked (protected copy) you can duplicate it. I've also integrated the combined GPA/Rank Calc into the spreadsheet.niederbomb wrote:So it won't let me change the values, nor does right clicking do anything.
Trying to operate it but I don't see anywhere I can calculate all my grades and possible rank (even though I only have grades from 1st semester)
- 3|ink
- Posts: 7393
- Joined: Wed Dec 16, 2009 5:23 pm
Re: Class Rank Estimator
The calculator assumes you have calculated your GPA.Baronessa_Esq wrote:NYC Law wrote:Should be good to go now. The editable class rank calc is the first page. If you click the tab at the bottom for the locked (protected copy) you can duplicate it. I've also integrated the combined GPA/Rank Calc into the spreadsheet.niederbomb wrote:So it won't let me change the values, nor does right clicking do anything.
Trying to operate it but I don't see anywhere I can calculate all my grades and possible rank (even though I only have grades from 1st semester)
- NYC Law
- Posts: 1561
- Joined: Thu May 26, 2011 3:33 pm
Re: Class Rank Estimator
There are two sheets, one if you have your gpa, and another one that calculates it (good for speculative grades). I haven't looked at the spreadsheet in a while though, so the second type of sheet might be buried under 100 copies of the first sheet.Baronessa_Esq wrote:NYC Law wrote:Should be good to go now. The editable class rank calc is the first page. If you click the tab at the bottom for the locked (protected copy) you can duplicate it. I've also integrated the combined GPA/Rank Calc into the spreadsheet.niederbomb wrote:So it won't let me change the values, nor does right clicking do anything.
Trying to operate it but I don't see anywhere I can calculate all my grades and possible rank (even though I only have grades from 1st semester)
Want to continue reading?
Register now to search topics and post comments!
Absolutely FREE!
Already a member? Login
- 3|ink
- Posts: 7393
- Joined: Wed Dec 16, 2009 5:23 pm
Re: Class Rank Estimator
Really? Yeah. It's long gone.NYC Law wrote:There are two sheets, one if you have your gpa, and another one that calculates it (good for speculative grades). I haven't looked at the spreadsheet in a while though, so the second type of sheet might be buried under 100 copies of the first sheet.Baronessa_Esq wrote:NYC Law wrote:Should be good to go now. The editable class rank calc is the first page. If you click the tab at the bottom for the locked (protected copy) you can duplicate it. I've also integrated the combined GPA/Rank Calc into the spreadsheet.niederbomb wrote:So it won't let me change the values, nor does right clicking do anything.
Trying to operate it but I don't see anywhere I can calculate all my grades and possible rank (even though I only have grades from 1st semester)
And how does it calculate your gpa? Does it make assumptions about quality point distribution per grade?
- crossarmant
- Posts: 1116
- Joined: Fri Jan 14, 2011 8:01 am
Re: Class Rank Estimator
Would anyone be able to get this spreadsheet working again or have another Rank placement calculator? This was working at the end of last semester, but isn't now for some reason. My school doesn't rank so it would help me get a better idea. Thanks.
- dailygrind
- Posts: 19907
- Joined: Wed Oct 22, 2008 11:08 am
Re: Class Rank Estimator
Use the manual workaround for now. I wrote it myself and will guarantee that the math is correct. If anyone else wants to create a shared spreadsheet, I would happily edit your link into the OP and give you credit.crossarmant wrote:Would anyone be able to get this spreadsheet working again or have another Rank placement calculator? This was working at the end of last semester, but isn't now for some reason. My school doesn't rank so it would help me get a better idea. Thanks.
- homestyle28
- Posts: 2362
- Joined: Thu Jun 04, 2009 12:48 pm
Re: Class Rank Estimator
Am I the only one getting an error on this? DIV/0 errordailygrind wrote:Use the manual workaround for now. I wrote it myself and will guarantee that the math is correct. If anyone else wants to create a shared spreadsheet, I would happily edit your link into the OP and give you credit.crossarmant wrote:Would anyone be able to get this spreadsheet working again or have another Rank placement calculator? This was working at the end of last semester, but isn't now for some reason. My school doesn't rank so it would help me get a better idea. Thanks.
- ilovesf
- Posts: 12837
- Joined: Wed Oct 20, 2010 5:20 pm
Re: Class Rank Estimator
It works for me but my rank changes slightly based on what data point I use- varies between 3%homestyle28 wrote:Am I the only one getting an error on this? DIV/0 errordailygrind wrote:Use the manual workaround for now. I wrote it myself and will guarantee that the math is correct. If anyone else wants to create a shared spreadsheet, I would happily edit your link into the OP and give you credit.crossarmant wrote:Would anyone be able to get this spreadsheet working again or have another Rank placement calculator? This was working at the end of last semester, but isn't now for some reason. My school doesn't rank so it would help me get a better idea. Thanks.
- dailygrind
- Posts: 19907
- Joined: Wed Oct 22, 2008 11:08 am
Re: Class Rank Estimator
You are doing something wrong.homestyle28 wrote:Am I the only one getting an error on this? DIV/0 error
Yeah, it's not the most precise thing in the world. The most accurate choice is the data point closest to your GPA.ilovesf wrote:It works for me but my rank changes slightly based on what data point I use- varies between 3%
- fatduck
- Posts: 4135
- Joined: Mon Sep 13, 2010 10:16 pm
Re: Class Rank Estimator
random math question
why does it estimate a higher percentile when you increase the median gpa? shouldn't it be the other way around?
why does it estimate a higher percentile when you increase the median gpa? shouldn't it be the other way around?
- dailygrind
- Posts: 19907
- Joined: Wed Oct 22, 2008 11:08 am
Re: Class Rank Estimator
You're tightening the standard deviations more than you're tightening the distance between your grade and median. You stud, you.
ETA: to everyone who doesn't understand teh maths, that was not proof that the formula doesn't work. It works.
ETA: to everyone who doesn't understand teh maths, that was not proof that the formula doesn't work. It works.
Register now!
Resources to assist law school applicants, students & graduates.
It's still FREE!
Already a member? Login
- fatduck
- Posts: 4135
- Joined: Mon Sep 13, 2010 10:16 pm
Re: Class Rank Estimator
well now i feel like a dickdailygrind wrote:You're tightening the standard deviations more than you're tightening the distance between your grade and median. You stud, you.
ETA: to everyone who doesn't understand teh maths, that was not proof that the formula doesn't work. It works.
- jess
- Posts: 18149
- Joined: Tue Mar 22, 2011 8:27 pm
- Mattalones
- Posts: 528
- Joined: Sun Dec 03, 2006 8:18 pm
Re: Class Rank Estimator
If anyone can get it to estimate without a median using only then following, I'll give them a high-five!
Top 10% - 3.67
Top 25% - 3.57
Top 33% - 3.53
GPA: 3.21 & 3.34
Top 10% - 3.81
Top 25% - 3.67
Top 33% - 3.61
GPA: 3.50
Top 10% - 3.67
Top 25% - 3.57
Top 33% - 3.53
GPA: 3.21 & 3.34
Top 10% - 3.81
Top 25% - 3.67
Top 33% - 3.61
GPA: 3.50
-
- Posts: 94
- Joined: Mon Apr 02, 2012 12:33 pm
Re: Class Rank Estimator
Nice thread! Thank you for this information.
Get unlimited access to all forums and topics
Register now!
I'm pretty sure I told you it's FREE...
Already a member? Login
-
- Posts: 27
- Joined: Tue Oct 20, 2009 11:17 pm
Re: Class Rank Estimator
Color me confused. Here are the stats. Help please?
Top 10% 3.62
Top 25% 3.47
Top 33% 3.44
Top 50% 3.32
GPA 3.51
Top 10% 3.62
Top 25% 3.47
Top 33% 3.44
Top 50% 3.32
GPA 3.51
- thesealocust
- Posts: 8525
- Joined: Mon Oct 20, 2008 8:50 pm
Re: Class Rank Estimator
I'm too lazy to look at your spreadsheet, but can it calculate based on two data points instead of one data point and the mean? Because that's mathematically possible (just did it long-hand) but a friend told me this thread wasn't helpful with only the two data points and not the mean (...so I did the math then asked instead of reading the thread...)
-
- Posts: 694
- Joined: Tue Jul 06, 2010 12:17 pm
Re: Class Rank Estimator
deleted.
Last edited by Total Litigator on Fri Jan 04, 2013 6:40 pm, edited 1 time in total.
-
- Posts: 694
- Joined: Tue Jul 06, 2010 12:17 pm
Re: Class Rank Estimator
anchuldigs wrote:Color me confused. Here are the stats. Help please?
Top 10% 3.62
Top 25% 3.47
Top 33% 3.44
Top 50% 3.32
GPA 3.51
anchuldigs: I did this the mentally handicapped way by drawing a graph. You are top 20% +/- 1%.
Communicate now with those who not only know what a legal education is, but can offer you worthy advice and commentary as you complete the three most educational, yet challenging years of your law related post graduate life.
Register now, it's still FREE!
Already a member? Login
- thesealocust
- Posts: 8525
- Joined: Mon Oct 20, 2008 8:50 pm
Re: Class Rank Estimator
The front page is a fucking tool to do it for yourself. And two of them are so close to top 10% that a calculation would be less accurate than eyeballing it.redsox550 wrote:can someone please claculate this for me, here are the stats from last year
3.81 = 10%
3.335 = 50%
~185 students
calculate for these 3 numbers please 3.77, 3.42, 3.86
- dailygrind
- Posts: 19907
- Joined: Wed Oct 22, 2008 11:08 am
Re: Class Rank Estimator
Nah. I think I know how to rewrite so that it could do that calculation, but to be perfectly honest I'm no longer practiced enough with the math to make that a fun use of my time. I could give it an hour or so if there's high demand, though.thesealocust wrote:I'm too lazy to look at your spreadsheet, but can it calculate based on two data points instead of one data point and the mean? Because that's mathematically possible (just did it long-hand) but a friend told me this thread wasn't helpful with only the two data points and not the mean (...so I did the math then asked instead of reading the thread...)
- LSATSCORES2012
- Posts: 770
- Joined: Mon Jul 02, 2012 2:12 pm
Re: Class Rank Estimator
Just figured I'd stumble in here and let you all know that there is now a calculator using the formula in the OP up at http://mylsn.info/class_rank.php
Note that it will store the known rank/percentile that you use for future users to use (but it will not store your own rank).
Thanks to dailygrind for editing it into the OP
Note that it will store the known rank/percentile that you use for future users to use (but it will not store your own rank).
Thanks to dailygrind for editing it into the OP
Seriously? What are you waiting for?
Now there's a charge.
Just kidding ... it's still FREE!
Already a member? Login