Find all School-related info fast with the new School-Specific MBA Forum

It is currently 03 May 2016, 14:24
GMAT Club Tests

Close

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
Your Progress

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

Not interested in getting valuable practice questions and articles delivered to your email? No problem, unsubscribe here.

Events & Promotions

Events & Promotions in June
Open Detailed Calendar

Calculate your chances of acceptance (Spreadsheet)

  new topic post reply Question banks Downloads My Bookmarks Reviews Important topics  
Author Message
TAGS:

Hide Tags

3 KUDOS received
Intern
Intern
User avatar
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 [?]: 16 [3] , given: 1

Calculate your chances of acceptance (Spreadsheet) [#permalink]

Show Tags

New post 03 Oct 2011, 19:20
3
This post received
KUDOS
1
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]
Downloaded 280 times
To download please login or register as a user

Old File

Attachment:
MBAchances.xls [14.5 KiB]
Downloaded 173 times
To download please login or register as a user

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:

http://www.businessweek.com/bschools/ra ... index.html

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

Variables which were added:

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, 18:58, edited 5 times in total.
Intern
Intern
User avatar
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 [?]: 16 [0], given: 1

Re: Calculate your chances of acceptance (Spreadsheet) [#permalink]

Show Tags

New post 03 Oct 2011, 19:36
I fixed errors, hopefully it should be good now :)
Intern
Intern
User avatar
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 [?]: 16 [0], given: 1

Re: Calculate your chances of acceptance (Spreadsheet) [#permalink]

Show Tags

New post 03 Oct 2011, 19:55
K I swear... that was the last fix lol
Intern
Intern
User avatar
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 [?]: 16 [0], given: 1

Re: Calculate your chances of acceptance (Spreadsheet) [#permalink]

Show Tags

New post 03 Oct 2011, 20: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
Manager
User avatar
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

Re: Calculate your chances of acceptance (Spreadsheet) [#permalink]

Show Tags

New post 04 Oct 2011, 11: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 :)
2 KUDOS received
Intern
Intern
User avatar
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 [?]: 16 [2] , given: 1

Re: Calculate your chances of acceptance (Spreadsheet) [#permalink]

Show Tags

New post 04 Oct 2011, 18:14
2
This post received
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]
Downloaded 61 times
To download please login or register as a user



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

Variables which were added:

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
Expert Post
Founder
Founder
User avatar
Affiliations: AS - Gold, HH-Diamond
Joined: 04 Dec 2002
Posts: 13701
Location: United States (WA)
GMAT 1: 750 Q49 V42
GPA: 3.5
Followers: 3231

Kudos [?]: 18442 [0], given: 4220

GMAT ToolKit User Premium Member CAT Tests
Re: Calculate your chances of acceptance (Spreadsheet) [#permalink]

Show Tags

New post 05 Oct 2011, 16:30
Expert's post
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 1: Download the file
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 2008 - 2017 Rankings progression - 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
Intern
User avatar
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 [?]: 16 [0], given: 1

Re: Calculate your chances of acceptance (Spreadsheet) [#permalink]

Show Tags

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

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

Premium Member
Re: Calculate your chances of acceptance (Spreadsheet) [#permalink]

Show Tags

New post 03 Jan 2016, 00: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.
Re: Calculate your chances of acceptance (Spreadsheet)   [#permalink] 03 Jan 2016, 00:26
    Similar topics Author Replies Last post
Similar
Topics:
What are my chances of being accepted into these Masters? JNSousa 3 22 Mar 2014, 19:36
40 Experts publish their posts in the topic Be realistic - What are your chances Aringo 6 21 Jul 2013, 10:47
Aringo Admissions Chances Calculator daedalus1989 1 18 Jul 2013, 19:44
1 better chance of acceptance for reapplicants? fooFighter 4 22 Dec 2008, 06:39
Consulting spreadsheet zhl226 7 14 Oct 2008, 02:10
Display posts from previous: Sort by

Calculate your chances of acceptance (Spreadsheet)

  new topic post reply Question banks Downloads My Bookmarks Reviews Important topics  


GMAT Club MBA Forum Home| About| Terms and Conditions| GMAT Club Rules| Contact| Sitemap

Powered by phpBB © phpBB Group and phpBB SEO

Kindly note that the GMAT® test is a registered trademark of the Graduate Management Admission Council®, and this site has neither been reviewed nor endorsed by GMAC®.