Last visit was: 23 May 2024, 18:56 It is currently 23 May 2024, 18:56
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.
Close
Request Expert Reply
Confirm Cancel
SORT BY:
Date
User avatar
Intern
Intern
Joined: 25 Jun 2011
Posts: 39
Own Kudos [?]: 17 [5]
Given Kudos: 1
Location: United States
Concentration: Finance, Real Estate
GMAT 1: 630 Q40 V36
GPA: 3.13
WE:Real Estate (Real Estate)
Send PM
User avatar
Intern
Intern
Joined: 25 Jun 2011
Posts: 39
Own Kudos [?]: 17 [0]
Given Kudos: 1
Location: United States
Concentration: Finance, Real Estate
GMAT 1: 630 Q40 V36
GPA: 3.13
WE:Real Estate (Real Estate)
Send PM
User avatar
Intern
Intern
Joined: 25 Jun 2011
Posts: 39
Own Kudos [?]: 17 [0]
Given Kudos: 1
Location: United States
Concentration: Finance, Real Estate
GMAT 1: 630 Q40 V36
GPA: 3.13
WE:Real Estate (Real Estate)
Send PM
User avatar
Intern
Intern
Joined: 25 Jun 2011
Posts: 39
Own Kudos [?]: 17 [0]
Given Kudos: 1
Location: United States
Concentration: Finance, Real Estate
GMAT 1: 630 Q40 V36
GPA: 3.13
WE:Real Estate (Real Estate)
Send PM
Re: Calculate your chances of acceptance (Spreadsheet) [#permalink]
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.
User avatar
Manager
Manager
Joined: 17 Jan 2011
Status:Do not worry. You are not going to get out of this world alive anyway :)
Posts: 58
Own Kudos [?]: 14 [0]
Given Kudos: 9
Location: United States
Concentration: Entrepreneurship, Technology
GPA: 3.89
WE:Engineering (Computer Software)
Send PM
Re: Calculate your chances of acceptance (Spreadsheet) [#permalink]
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 :)
User avatar
Intern
Intern
Joined: 25 Jun 2011
Posts: 39
Own Kudos [?]: 17 [2]
Given Kudos: 1
Location: United States
Concentration: Finance, Real Estate
GMAT 1: 630 Q40 V36
GPA: 3.13
WE:Real Estate (Real Estate)
Send PM
Re: Calculate your chances of acceptance (Spreadsheet) [#permalink]
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]
Downloaded 105 times


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
Founder
Founder
Joined: 04 Dec 2002
Posts: 37474
Own Kudos [?]: 73345 [0]
Given Kudos: 19005
Location: United States (WA)
GMAT 1: 750 Q49 V42
GPA: 3
Send PM
Re: Calculate your chances of acceptance (Spreadsheet) [#permalink]
Expert Reply
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
User avatar
Intern
Intern
Joined: 25 Jun 2011
Posts: 39
Own Kudos [?]: 17 [0]
Given Kudos: 1
Location: United States
Concentration: Finance, Real Estate
GMAT 1: 630 Q40 V36
GPA: 3.13
WE:Real Estate (Real Estate)
Send PM
Re: Calculate your chances of acceptance (Spreadsheet) [#permalink]
When I get some time this weekend I'll color code and do a quick write up.
User avatar
Non-Human User
Joined: 01 Oct 2013
Posts: 915
Own Kudos [?]: 41 [0]
Given Kudos: 0
Send PM
Re: Calculate your chances of acceptance (Spreadsheet) [#permalink]
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.
GMAT Club Bot
Re: Calculate your chances of acceptance (Spreadsheet) [#permalink]