MCAT Estimator Spreadsheet (w/ Poll: How accurate was it for you?)

SDN Members don't see this ad. (About Ads)

This looks like a pretty cool spreadsheet. How did it compare to the AAMC tests' predictions for you guys?

Cool! Predicted 9 9 9, I ended up getting 8 11 12

Very similar predictions to my AAMC practice tests, though those ranged, I was averagely getting 9's heading into my test, but I guess the pressure of test day bumped me up a few points for VR and BS!

I input both my GPA's and my GRE scores (from 7 years ago).

I've taken the MCAT exactly one time and the Predictor did a perfect job of predicting my total score, but it over estimated my verbal score and underestimated my science scores.

Pretty cool!

Wow! This is awesome!
I see it supposedly predicts USMLE scores, which seems pretty much impossible. Has it been close to anyone's actual score? It sounds like it's pretty close on people's MCAT scores.... Hopefully I'll get the 35 or so this thing is predicting!

Wow, it predicted my composite score exactly! Breakdown was wrong.

Originally Posted by mmmcdowe

Wow, it predicted my composite score exactly! Breakdown was wrong.

Interesting. How "off" was your breakdown? It definitely tends to overestimate how well-rounded your scores will be. You'd have to be pretty lop-sided on your GPA and SAT scores, for instance, to get much different from all scores being the same +/- 1 point. To get the "classic SDN" unbalanced high MCAT w/ a low VR, for instance, 9VR/12PS/11BS (TTL 31) requires an ACT of 14 English/36 Math/20 Soc Sci/36 Nat Sci w/ 3.0 cGPA/4.0 sGPA & 520 Verbal/750 Math on the SAT. In other words, it doesn't tend to predict breakdowns well if they're not balanced. This is because, statistically, people who do well on one section tend to do well on the other sections as well. Additionally, the same things correlate strongly w/ all 3 sections.

Based on my GPA, GRE, and SAT, it predicts a 37. That'd be nice. I'll get back to you in June about my real score. Neat tool.

Originally Posted by Cinclus

Based on my GPA, GRE, and SAT, it predicts a 37. That'd be nice. I'll get back to you in June about my real score. Neat tool.

Look at the range as well but if you've been that strong consistently, you probably could pull a 37. Of course, actual preparation comes into play very strongly here. What would be nice would be to create a matrix of scores and find how it compares across scores...but I don't have that kind of time nor desire to put in that kind of effort in analysis.

Based on my GPA and SAT, it predicted 31-ish for me.

Originally Posted by Rabolisk

Based on my GPA and SAT, it predicted 31-ish for me.

Nice. Hopefully that'll come to fruition w/ some hard work!

Originally Posted by apumic

Nice. Hopefully that'll come to fruition w/ some hard work!

I already took it.

Originally Posted by Rabolisk

I already took it.

...aaand?

cool dude thanks

Originally Posted by GooseWing

...aaand?

And I've always thought that this tool was of little use.

Originally Posted by Rabolisk

And I've always thought that this tool was of little use.

I think the previous poster was wondering whether your score was close to what was expected. While you may not think it is useful, a tool that gives a general range of expected scores for someone can be a good estimation of whether you are performing at or near your prior level of performance. In addition, it gives an early estimate as to where you might sit in comparison with your peers.

As for its accuracy, n=146 at this point and the trend is that over 40% score within 1 point of its prediction. Another 41% score more than 1 point above the predicted score, while <1 in 5 score more than 1 pt below the predicted score. That gives people a good feel for what they can expect to reasonably hit. I want it to estimate on the slightly low side so that people are positively surprised and not negatively surprised if it is wrong.

I know what he was wondering, and I think, based on experience, I don't believe the tool to be that useful. It seems to underestimate the score if <20% score more than 1 pt below, but 41% score more than 1 point above. I don't think this deviation is huge, but it is statistically significant. Of course, if this is how it's meant to be, then it is what it is.

After putting in my GPA, I get PS 9, BS 9, VR 8= 27...After putting in my SAT, I get PS 9, BS 9, and VR 13 = 30, and after putting in GRE scores I get PS 12, BS 12, VR 13 = 37
my real MCAT was 36 with PS 9, BS 12, VR 13...so I guess in a way all of them were right on in some way.

Originally Posted by felixthekat

After putting in my GPA, I get PS 9, BS 9, VR 8= 27...After putting in my SAT, I get PS 9, BS 9, and VR 13 = 30, and after putting in GRE scores I get PS 12, BS 12, VR 13 = 37
my real MCAT was 36 with PS 9, BS 12, VR 13...so I guess in a way all of them were right on in some way.

Haha... well, and your scores have been all over the place so any approximation would be rough at best. Since you've scored "equivalent" to everything from 27-37, you'd be expected to score somewhere in that range. Nice job on the 36!!!

glad it was on the higher end of the 27-37 range though

WOW!! Pretty darn close. I put in SAT/GPA/ACT and it gave me a 34 VR:12 BS:11 PS:11 and I got a 35 VR:11 BS:12 PS:12

Originally Posted by Br33zy

WOW!! Pretty darn close. I put in SAT/GPA/ACT and it gave me a 34 VR:12 BS:11 PS:11 and I got a 35 VR:11 BS:12 PS:12

Congrats, that's an awesome score!

It's interesting -- the MCAT Estimator Spreadsheet's predictions appear to be almost equivalent to the AAMC exams in predictive value! (Check this poll.)

The main difference is that the Estimator tends to slightly favor predictions on the low side (which was by design), whereas the AAMC tests tend to err on the high side.

Originally Posted by Cinclus

Based on my GPA, GRE, and SAT, it predicts a 37. That'd be nice. I'll get back to you in June about my real score. Neat tool.

As promised, my real score turned out to be a 39. Two points higher than predicted, and I'm not complaining.

Did anybody look at the disclaimer? lmao

"Furthermore, by using this program, you promise to meet at least once/month individually with a PhD- or MD-level qualified pre-med advisor and discuss the results of this spreadsheet and/or your overall application with this person as well as regularly consult the MSAR..."

"If you cannot or will not agree to the above agreement you must immediately destroy this spreadsheet file from your computer and notify apumic through a PM of such action."

This is kind of ridiculous.

Originally Posted by Freigeist

Did anybody look at the disclaimer? lmao

"Furthermore, by using this program, you promise to meet at least once/month individually with a PhD- or MD-level qualified pre-med advisor and discuss the results of this spreadsheet and/or your overall application with this person as well as regularly consult the MSAR..."

"If you cannot or will not agree to the above agreement you must immediately destroy this spreadsheet file from your computer and notify apumic through a PM of such action."

This is kind of ridiculous.

I think it was meant to be over the top...maybe a little bit of a joke while still giving ridiculous legal "protection" -- kind of like the "Warning! Hot coffee may be very hot!" labels on McDonald's coffee cups.

From my ACT, predicted 31
From my SAT, 34
From GPA, 31

Got a 34 on the real thing, and the cumulative predicted a 34, so I would say this tool is very good for ballparking.

Incidentally, I think those who score way above their predicted value (more than 4 points above their predicted value) should share their MCAT study tips as it is possible they prepared in a better way. This is assuming, of course, that there weren't other explanations for the deviation ( i.e., "I was drunk the night before my SAT")

I would like the spreadsheet more if the colors didn't hurt my eyes

Wow 30-39 but my ACT/SAT give me around a 38 hahaha I wish I scored that high. We'll see in 9 days. I'll let you know how it goes.

Mine was off by 4 points

How do you get the password for the spreadsheet?

Bump.

have you thought of making one for scores on different AAMCs?

the mean scores of AAMCs this january didn't seem to be representative of the scores received on the real thing.

Predicted from spreadsheet: 36
Actual: 37

Seems relatively accurate to me.

Originally Posted by Bauman1535

Predicted from spreadsheet: 36
Actual: 37

Seems relatively accurate to me.

what stats did you use?

GPA Predicted: 34
SAT Predicted: 29
Overall Prediction: 32

Actual: 40......

Was not terribly accurate for me haha.

Originally Posted by MrNeuro

what stats did you use?

I had an ACT of 33, so that predicted something like a 36. Even though my GPA is in the mid to upper 3.8s, that predicted like a 32. Inputting my first four practice test scores brought it overall up to a 36 (helped having a 39 on AAMC 4 haha...)

Hm, it predicted a 35 for me (13V/11B/11P). I think it's being a little overly optimistic but I guess we'll see.

Sorry if it's already been covered but can someone explain what exactly the "Social Sciences" and "Natural Sciences" sections of the ACT are? As far as I remember there were 4 sections: Math, Reading, English, and Science Reasoning.

There was no section called Social Sciences or Natural Sciences, though the Reading portion of the ACT had 4 separate passages, 2 of which were "Social Science" passages and "Natural Science" passages. The other two were Prose Fiction and Humanities.

GPA- 31
SAT- 35
ACT- 37

Hopefully this bodes well for my June MCAT.

Wow! This estimate is pretty discouraging.... I mean I guess since I did average in the SAT and my GPA is pretty average too that it makes sense to predict an average MCAT... but I really hope all my studying bumps this prediction up by a LOT (like at least 4-5 points? please?)

Originally Posted by breeniee

Wow! This estimate is pretty discouraging.... I mean I guess since I did average in the SAT and my GPA is pretty average too that it makes sense to predict an average MCAT... but I really hope all my studying bumps this prediction up by a LOT (like at least 4-5 points? please?)

I think the SAT and ACT predictors are there based off of how well you are at standardized testing. GPA is a hard one to nail though as courses are a combination of your testing skill plus homework/labs/papers. So I would say don't get discouraged as the MCAT is largely knowledge based plus just a bit of testing skill (knowing how long you should be spending on each question and getting the main idea or focus of each question).

Originally Posted by MDschoolorbust

I think the SAT and ACT predictors are there based off of how well you are at standardized testing. GPA is a hard one to nail though as courses are a combination of your testing skill plus homework/labs/papers. So I would say don't get discouraged as the MCAT is largely knowledge based plus just a bit of testing skill (knowing how long you should be spending on each question and getting the main idea or focus of each question).

Yeah I know....I mean the overall score is kind of discouraging but the range isn't too bad. I know I'm putting effort into it and in the end I think it'll get me up there on the higher end of the range (and maybe beyond? *hopeful*)

SAT prediction: 34
GPA prediction (3.7--BME=hard!): 30
Overall: 31
range: 24-37
AAMC avg: 34.5 with max 37 and min 32
Actual 38!
Maybe there should be a section for difficulty of major bcuz a 3.7 in one major =/= 3.7 in easy major

This did not agree with me. The estimated verbal scores for me were 10+ and I got a 6. I usually get 6's and 7's on the verbal so I have no idea how they are able to relate the GPA to your performance on verbal...

ACT = 34
SAT = 33
GPA = 31

Actual MCAT = 34.

Pretty impressive tool. I imagined my GPA would low-ball me because my school is pretty big on grade deflation (thanks, a-holes).

Originally Posted by jhuskp

How do you get the password for the spreadsheet?

For all those puzzled by this, as I was: there is no password. Hit "OK" and the spreadsheet will open.

Originally Posted by i will be an md

For all those puzzled by this, as I was: there is no password. Hit "OK" and the spreadsheet will open.

Hmm it's not working for me?
It says "The Password you supplied is not correct." when i click "OK"

Any ideas?

Has this been redone with a formula for the new GRE?

So what exactly are the "Natural Sciences" and "Social Sciences" section of the ACT? There were no such sections on the previous ACT that I took, nor are they the sections on the current ACT.

Originally Posted by gbvan

Has this been redone with a formula for the new GRE?

I don't think so. I just used my percentile score and matched it up as closely I could with the percentiles from the old scoring system.