Check GMAT Club Decision Tracker for the Latest School Decision Releases http://gmatclub.com/AppTrack

 It is currently 24 Jan 2017, 16:21

GMAT Club Daily Prep

Thank you for using the timer - this advanced tool can estimate your performance and suggest more practice questions. We have subscribed you to Daily Prep Questions via email.

Customized
for You

we will pick new questions that match your level based on your Timer History

Track

every week, we’ll send you an estimated GMAT score based on your performance

Practice
Pays

we will pick new questions that match your level based on your Timer History

Events & Promotions

Events & Promotions in June
Open Detailed Calendar

Author Message
TAGS:

Hide Tags

Intern
Joined: 25 Jun 2011
Posts: 39
Location: United States
Concentration: Finance, Real Estate
GMAT 1: 630 Q40 V36
GPA: 3.13
WE: Real Estate (Real Estate)
Followers: 1

Kudos [?]: 17 [3] , given: 1

Show Tags

03 Oct 2011, 18:20
3
KUDOS
2
This post was
BOOKMARKED
Here is a spreadsheet I made for my use that I figured I'd share, now its rough and I'm not a math genius, but it works for my purposes. It is broken down by International and Domestic applicants, and will show your chances according to the type of applicant you are.

Feel free to poke holes in my math and make changes!

edit 3: Big update I will keep the original one in place, feel free to make changes or give suggestions

Attachment:
MBAchances.xls [11 KiB]

Old File

Attachment:
MBAchances.xls [14.5 KiB]

New One

Now of course this does not take into account any GPA or GMAT factors its only meant to be used as a rough guesstimate as to your chances if you are either an International or Domestic student.

A mathematical assumption was made using the %'s of the matriculated 2011 class profile, that the breakdown would be the same with overall acceptances.

Obviously a lot more goes into getting that acceptance to the school you are looking at, but this spreadsheet might be a good way for either an international or domestic student to further target a school where their chances may be greater.

Oh and Texas A&M was used for the current numbers. Just need to edit the raw numbers using figures from your school of choice located here:

edit: fixed error in spreadsheet... will update if I find anymore
edit 2: Ok now it should be good lol
edit 3: Big update I will keep the original one in place, feel free to make changes or give suggestions

What I did was come up with a base 100% extrapolated from the Mean GMAT/GPA/Work Experience. If you are the super average student who hits each mean number then you will have an 100% chance of acceptance. Unfortunately that is fleeting moment as your acceptance % is then calculated against the application data. Some schools have very large International to Domestic splits which causes some massive number shifts (IE Uni. of Illinois, Michigan State and Purdue). In my spreadsheet I uploaded you can see my profile against Michigan State (Broad). Looking at the data below you can see that I'm very close to being the average student attending Broad as a domestic student. Unfortunately it seems that only the best of students are taken from the international pool, which is no fun if your an international student.

CHANCES OF BEING ACCEPTED ACCORDING TO THE 2011 CLASS PROFILE

International Applicants
13.07%

Domestic Applicants
71.4%

% of Total Applicants of Accepted
29.4%

GMAT/GPA/Work Combined %
112.22%

Total International Acceptance %
14.66%

Total Domestic Acceptance %
80.13%

You can see that I'm slightly below the mark overall for Broad as my total chances to be accepted were 80.13% which was just above the average 71.4% pace which domestic applicants are accepted overall.

Once again this is a ball parking application. Not meant for a true measure of your ability to be accepted.

I weighted the GMAT at 34% consideration and the GPA/Work at 33% respectively. Those are adjustable.

For the GMAT I assumed a 2% shift for every point above or below the mean (IE 34%*1.02 = 34.68%)
For your GPA I assumed a 3% shift for every .01 shift above or below the mean
For your Work Experience I assumed a 2% shift for every point above or below the mean

GMAT
GPA
Work Experience/Quality of Work Experience

Existing Variables not considered:

Interview
Legacy
How the size of the 80% Spread affects final numbers
Recommends
Essays

Last edited by Rommeliv on 04 Oct 2011, 17:58, edited 5 times in total.
Intern
Joined: 25 Jun 2011
Posts: 39
Location: United States
Concentration: Finance, Real Estate
GMAT 1: 630 Q40 V36
GPA: 3.13
WE: Real Estate (Real Estate)
Followers: 1

Kudos [?]: 17 [0], given: 1

Show Tags

03 Oct 2011, 18:36
I fixed errors, hopefully it should be good now
Intern
Joined: 25 Jun 2011
Posts: 39
Location: United States
Concentration: Finance, Real Estate
GMAT 1: 630 Q40 V36
GPA: 3.13
WE: Real Estate (Real Estate)
Followers: 1

Kudos [?]: 17 [0], given: 1

Show Tags

03 Oct 2011, 18:55
K I swear... that was the last fix lol
Intern
Joined: 25 Jun 2011
Posts: 39
Location: United States
Concentration: Finance, Real Estate
GMAT 1: 630 Q40 V36
GPA: 3.13
WE: Real Estate (Real Estate)
Followers: 1

Kudos [?]: 17 [0], given: 1

Show Tags

03 Oct 2011, 19:40
So one thing I noticed when doing a run down is that not all schools release their yield or full application pool data, which unfortunately makes it difficult to get accurate numbers. In the Top 15 its rather hit or miss but after that most the data is there for the taking usually.
Manager
Status: Do not worry. You are not going to get out of this world alive anyway :)
Joined: 17 Jan 2011
Posts: 58
Location: United States
Concentration: Entrepreneurship, Technology
GPA: 3.89
WE: Engineering (Computer Software)
Followers: 0

Kudos [?]: 14 [0], given: 9

Show Tags

04 Oct 2011, 10:16
This is a great idea ... and if you could add GPA/GMAT and add consideration of a few more schools, this would be one of the most used spreadsheets on the site
Just my opinion
Intern
Joined: 25 Jun 2011
Posts: 39
Location: United States
Concentration: Finance, Real Estate
GMAT 1: 630 Q40 V36
GPA: 3.13
WE: Real Estate (Real Estate)
Followers: 1

Kudos [?]: 17 [2] , given: 1

Show Tags

04 Oct 2011, 17:14
2
KUDOS
I was thinking of giving it a go anyways, so I took a shot. Now this is some very very rudimentary math I used to come up with these numbers.

Attachment:
MBAchances.xls [14.5 KiB]

What I did was come up with a base 100% extrapolated from the Mean GMAT/GPA/Work Experience. If you are the super average student who hits each mean number then you will have an 100% chance of acceptance. Unfortunately that is fleeting moment as your acceptance % is then calculated against the application data. Some schools have very large International to Domestic splits which causes some massive number shifts (IE Uni. of Illinois, Michigan State and Purdue). In my spreadsheet I uploaded you can see my profile against Michigan State (Broad). Looking at the data below you can see that I'm very close to being the average student attending Broad as a domestic student. Unfortunately it seems that only the best of students are taken from the international pool, which is no fun if your an international student.

CHANCES OF BEING ACCEPTED ACCORDING TO THE 2011 CLASS PROFILE

International Applicants
13.07%

Domestic Applicants
71.4%

% of Total Applicants of Accepted
29.4%

GMAT/GPA/Work Combined %
112.22%

Total International Acceptance %
14.66%

Total Domestic Acceptance %
80.13%

You can see that I'm slightly below the mark overall for Broad as my total chances to be accepted were 80.13% which was just above the average 71.4% pace which domestic applicants are accepted overall.

Once again this is a ball parking application. Not meant for a true measure of your ability to be accepted.

I weighted the GMAT at 34% consideration and the GPA/Work at 33% respectively. Those are adjustable.

For the GMAT I assumed a 2% shift for every point above or below the mean (IE 34%*1.02 = 34.68%)
For your GPA I assumed a 3% shift for every .01 shift above or below the mean
For your Work Experience I assumed a 2% shift for every point above or below the mean

GMAT
GPA
Work Experience/Quality of Work Experience

Existing Variables not considered:

Interview
Legacy
How the size of the 80% Spread affects final numbers
Recommends
Essays
Founder
Affiliations: AS - Gold, HH-Diamond
Joined: 04 Dec 2002
Posts: 14469
Location: United States (WA)
GMAT 1: 750 Q49 V42
GPA: 3.5
Followers: 3730

Kudos [?]: 23076 [0], given: 4517

Show Tags

05 Oct 2011, 15:30
Kudos. Could you perhaps write out instructions how one is to use it and frame them? People tend not to read much and just skim these days, would help quite a bit to know which cells to change what should stay locked/etc.

Something like this:

STEP 2: Find the data on business week
STEP 3: Plug in data into cells highlighted in Yellow
STEP 4: See your result/chances in Cell XX
_________________

Founder of GMAT Club

US News Rankings progression - last 10 years in a snapshot - New!
Just starting out with GMAT? Start here...
Need GMAT Book Recommendations? Best GMAT Books

Co-author of the GMAT Club tests

GMAT Club Premium Membership - big benefits and savings

Intern
Joined: 25 Jun 2011
Posts: 39
Location: United States
Concentration: Finance, Real Estate
GMAT 1: 630 Q40 V36
GPA: 3.13
WE: Real Estate (Real Estate)
Followers: 1

Kudos [?]: 17 [0], given: 1

Show Tags

06 Oct 2011, 00:54
When I get some time this weekend I'll color code and do a quick write up.
Non-Human User
Joined: 01 Oct 2013
Posts: 553
Followers: 72

Kudos [?]: 13 [0], given: 0

Show Tags

02 Jan 2016, 23:26
Hello from the GMAT Club MBAbot!

Thanks to another GMAT Club member, I have just discovered this valuable topic, yet it had no discussion for over a year. I am now bumping it up - doing my job. I think you may find it valuable (esp those replies with Kudos).

Want to see all other topics I dig out? Follow me (click follow button on profile). You will receive a summary of all topics I bump in your profile area as well as via email.
Similar topics Replies Last post
Similar
Topics:
What are my chances of being accepted into these Masters? 3 22 Mar 2014, 18:36
46 Be realistic - What are your chances 7 21 Jul 2013, 09:47
Aringo Admissions Chances Calculator 1 18 Jul 2013, 18:44
1 better chance of acceptance for reapplicants? 4 22 Dec 2008, 05:39
Consulting spreadsheet 7 14 Oct 2008, 01:10
Display posts from previous: Sort by