NEW HERE? LEARN MORE
closeclose
Last visit was: 23 Apr 2024, 22:15 It is currently 23 Apr 2024, 22:15
Decision Tracker
My Rewards
New posts
New comers' posts

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.
Go to My Error Log Learn more
Close
Request Expert Reply
Confirm Cancel

GMAT Prep Analysis Tool

SORT BY:
Date
Kudos
 1   2   
User avatar
Hussain15
Retired Moderator
Joined: 18 Jun 2009
Status:The last round
Posts: 1078
Own Kudos [?]: 3046 [59]
Given Kudos: 157
Concentration: Strategy, General Management
Schools: Stanford '14 (D) Booth '14 (D) Johnson '14 (D)
GMAT 1: 680 Q48 V34
Send PM
GMAT ToolKit User
GMAT Prep Analysis Tool [#permalink] New post   14 Oct 2010, 05:10
38
Kudos
21
Bookmarks
Hi members, it was the end of June when I was shocked with my very first gmat prep experience. I got a 590 in that test & that very result made me realize that I had to work hard & plan more. It was that time when I decided to take leave from workplace & give some real time to the beast. After 15 days of study, I gave another shot to gmat prep & was shocked again to have a score of 710. Though I knew that 710 was partially because of my luck, I wanted to know the critical factor that made my score jumped up. I had gone through the bsd_lover’s gmat prep analysis but wanted to have a little analysis of my own. So I decided to enter my gmat prep results data in an excel file, so that I may review the details later (No wonder being a finance guy, I love Excel). It took hardly 15 minutes to enter the data in the input sheet & then I analyzed the patterns of question recurrence, mistakes sequence & % of each question type. I did the same analysis for three of my gmat prep tests & gained some very useful insight. I planned to share that stuff at the forum but couldn’t do so mainly because of the fact that I used a very rough data file, which in no way was suitable to share. I have worked on that analysis tool of mine now so that it may get the required form to be shared. So attached is that tool. I hope the said tool will help you guys in knowing the gmat question patterns & the importance of first 10-13 questions.

My Findings


1.GMAT Prep Score 630

1. I got a fantastic Q score of 50 but a poor verbal score of 25 spoiled my overall score.
2. The Q score of 50 with 7 mistakes made me realized that the Q section of the gmat test has a soft corner. :)
3. Also, the first 10 Q questions had no mistake; hence this was also a big reason for high Q score.
4. Having consistent mistakes in verbal section was the sole reason of low verbal score. It also made me clear that one can’t afford to have as many mistakes in verbal as one can in Q section.
5. I also got the pattern and count of each question type as shown in the charts below.





2.GMAT Prep Score 710

1. A high jump in verbal score was only because of the fact that I got the first 14 verbal questions correct. In comparison to my 630 performance I only made 5 less mistakes but got a 15 point improvement in my verbal score.
2. The quantitative drop to 47 was mainly because of consistent mistakes. The interesting point is that my 15 mistakes got me a Q score of 47 while the 15 mistakes in verbal section during my 630 experience got me a score of V25. :shock:
3. Total # of each question type was surprisingly the same as was in 630 experience.
4. The question recurrence patterns were different in comparison to the ones I saw in the case of 630.





How to use the tool

1. Download the attached excel sheet.
2. After taking the gmat prep & seeing the score on your screen, just note down that socre in your analysis tool or somewhere else. Don’t skip the score report screen, as when you click the “Next” button, the score report will never be available again.
3. You need to fill in the “Data Input “sheet only, the other two sheets will be updated accordingly. This will hardly take 10-15 minutes.
4. Fill in the "answer" & "question type" columns in Q & V sections along with the raw score cells of Q & V.
5. You can then go through the two analysis sheets to find the details.


Imp Note:


1. I totally agree that gmat is a CAT and the number of right & wrong answers doesn’t make much difference but still there are some points that one need to remember & the biggest of which is the importance of first 10-12 questions.
2. I am using some soft & standard chart colors of gmat club here in this post. The attached excel file has the regular chart graphics.

Edit: Version-2 of the tool added with a new analysis sheet showing the count of correct/incorrect answers of each question type.

Attachments

GMAT Prep Analysis Tool-V-2.xlsx [36.3 KiB]
Downloaded 2303 times

GMAT Prep Analysis Tool-V-1.xlsx [27.25 KiB]
Downloaded 910 times

User avatar
kissthegmat
Retired Moderator
Joined: 21 May 2010
Status:<strong>I wish!</strong>
Posts: 700
Own Kudos [?]: 759 [0]
Given Kudos: 33
Send PM
Re: GMAT Prep Analysis Tool [#permalink] New post   14 Oct 2010, 05:47
Hussian bhai remarkable job! I liked the excel sheet. It's amazing tool to analyse mistakes and will definitely use it.

Thank you bro! +1
User avatar
gurpreetsingh
SVP
SVP
Joined: 12 Oct 2009
Status:<strong>Nothing comes easy: neither do I want.</strong>
Posts: 2279
Own Kudos [?]: 3593 [0]
Given Kudos: 235
Location: Malaysia
Concentration: Technology, Entrepreneurship
Schools: ISB '15 (M)
GMAT 1: 670 Q49 V31
GMAT 2: 710 Q50 V35
Send PM
Reviews Badge
Re: GMAT Prep Analysis Tool [#permalink] New post   14 Oct 2010, 16:24
With 10 mistakes in verbal I got v34 :-D - I had 4 mistakes in first 10 questions.
=> its very important to nail the first RC. :P

Its definitely worth to spend more time initially in Verbal.

Thanks Hussain.
User avatar
Hussain15
Retired Moderator
Joined: 18 Jun 2009
Status:The last round
Posts: 1078
Own Kudos [?]: 3046 [0]
Given Kudos: 157
Concentration: Strategy, General Management
Schools: Stanford '14 (D) Booth '14 (D) Johnson '14 (D)
GMAT 1: 680 Q48 V34
Send PM
GMAT ToolKit User
Re: GMAT Prep Analysis Tool [#permalink] New post   14 Oct 2010, 21:04
Thanks for all the comments.

It will be great, if anyone taking the gmat prep can fill the results in input sheet & paste the snapshots of the analysis sheets on this thread. This will help all of us in having an overview of different score patterns.
User avatar
prashantbacchewar
Manager
Manager
Joined: 20 Apr 2010
Posts: 154
Own Kudos [?]: 248 [0]
Given Kudos: 28
Concentration: Finacee, General Management
Schools:ISB, HEC, Said
 Q48  V28
Send PM
Re: GMAT Prep Analysis Tool [#permalink] New post   15 Oct 2010, 00:05
Great Work Hussain +1 to you.
I will be writing GMAT prep surely will post the analysis
User avatar
prashantbacchewar
Manager
Manager
Joined: 20 Apr 2010
Posts: 154
Own Kudos [?]: 248 [1]
Given Kudos: 28
Concentration: Finacee, General Management
Schools:ISB, HEC, Said
 Q48  V28
Send PM
Re: GMAT Prep Analysis Tool [#permalink] New post   15 Oct 2010, 00:07
1
Kudos
I am not able to save the XLS that you have attached. Please check
User avatar
Hussain15
Retired Moderator
Joined: 18 Jun 2009
Status:The last round
Posts: 1078
Own Kudos [?]: 3046 [0]
Given Kudos: 157
Concentration: Strategy, General Management
Schools: Stanford '14 (D) Booth '14 (D) Johnson '14 (D)
GMAT 1: 680 Q48 V34
Send PM
GMAT ToolKit User
Re: GMAT Prep Analysis Tool [#permalink] New post   15 Oct 2010, 00:13
prashantbacchewar wrote:
I am not able to save the XLS that you have attached. Please check


Hi prashant, thanks for pointing the issue. Some bug was there. I have re-attached the file. Kindly do check now.
User avatar
suyashjhawar
Senior Manager
Senior Manager
Joined: 18 Feb 2008
Posts: 327
Own Kudos [?]: 256 [0]
Given Kudos: 66
Location: Kolkata
Send PM
Re: GMAT Prep Analysis Tool [#permalink] New post   15 Oct 2010, 01:03
Great work Hussain bhai....will update as i give my gprep soon and would request others to share their exp....
avatar
radicaltp
Intern
Intern
Joined: 12 Oct 2010
Posts: 5
Own Kudos [?]: [0]
Given Kudos: 11
Send PM
Re: GMAT Prep Analysis Tool [#permalink] New post   15 Oct 2010, 04:12
wow a jump from 590 to >700 is rockign . great work with the tool development. I will definitely use it . my test is on 3 rd of November .
User avatar
L
bb
Founder
Founder
Joined: 04 Dec 2002
Posts: 37300
Own Kudos [?]: 72862 [1]
Given Kudos: 18857
Location: United States (WA)
GMAT 1: 750 Q49 V42
GPA: 3
Send PM
GMAT ToolKit User CAT Tests Forum Quiz Mode
Re: GMAT Prep Analysis Tool [#permalink] New post   15 Oct 2010, 21:07
1
Kudos
Expert Reply
Kudos for this beautiful and very useful post!
User avatar
B
nusmavrik
Senior Manager
Senior Manager
Joined: 26 Nov 2009
Status:Impossible is not a fact. It's an opinion. It's a dare. Impossible is nothing.
Affiliations: University of Chicago Booth School of Business
Posts: 470
Own Kudos [?]: 2377 [0]
Given Kudos: 36
Location: Singapore
Concentration: General Management, Finance
Schools: Chicago Booth - Class of 2015
Send PM
GMAT ToolKit User
Re: GMAT Prep Analysis Tool [#permalink] New post   15 Oct 2010, 22:51
Am I correct?

1. Verbal depletes the score faster than the Quant.

2. more than 10 mistakes in Verbal. Astalavista Baby!. Do the gmat again ! Ohh what a CAT :shock:

3. Initial 15 questions matter the most in both sections.

4. Final 7 questions matter the least in both sections.
User avatar
B
nusmavrik
Senior Manager
Senior Manager
Joined: 26 Nov 2009
Status:Impossible is not a fact. It's an opinion. It's a dare. Impossible is nothing.
Affiliations: University of Chicago Booth School of Business
Posts: 470
Own Kudos [?]: 2377 [0]
Given Kudos: 36
Location: Singapore
Concentration: General Management, Finance
Schools: Chicago Booth - Class of 2015
Send PM
GMAT ToolKit User
Re: GMAT Prep Analysis Tool [#permalink] New post   16 Oct 2010, 04:38
Thanks Hussain15 ! It makes a lot of sense. And awesome work on the excel.
User avatar
AtifS
Manager
Manager
Joined: 20 Jan 2010
Status:Not afraid of failures, disappointments, and falls.
Posts: 217
Own Kudos [?]: 447 [0]
Given Kudos: 260
Concentration: Technology, Entrepreneurship
Schools: Haas '19 Darden '19 INSEAD Jan '19 Stanford '19 Anderson '19 HBS '19
WE:Operations (Telecommunications)
Send PM
GMAT ToolKit User
Re: GMAT Prep Analysis Tool [#permalink] New post   17 Oct 2010, 02:43
Kudos! Nice tool, thanks for sharing and definitely gonna use it when time comes for practicing CATs.
User avatar
Topaz
Manager
Manager
Joined: 21 Aug 2010
Posts: 50
Own Kudos [?]: 6 [0]
Given Kudos: 2
Location: United Kingdom
GMAT Date: 06-28-2014
Send PM
Re: GMAT Prep Analysis Tool [#permalink] New post   17 Oct 2010, 03:42
Great excel analysis..will definately help...congrats for such a great improvement!....
User avatar
PTK
VP
VP
Joined: 02 Jul 2009
Status:mission completed!
Posts: 1139
Own Kudos [?]: 2129 [1]
Given Kudos: 622
GPA: 3.77
Send PM
GMAT ToolKit User Reviews Badge
Re: GMAT Prep Analysis Tool [#permalink] New post   18 Oct 2010, 21:57
1
Kudos
I will do the same analysis and will post my results here.
User avatar
cano
BSchool Moderator
Joined: 19 Feb 2010
Posts: 271
Own Kudos [?]: 521 [2]
Given Kudos: 76
Send PM
Re: GMAT Prep Analysis Tool [#permalink] New post   19 Oct 2010, 23:47
2
Kudos
Nice work Hussain! +1

I'm uploading screen shots of my analysis for everyone to see. I took GMATPrep back on Feb 09. You can see how I bombed the Quant with so many mistakes in the first 13 questions. I also think I had more than usual DS questions. And 3 of the 4 RC had only 3 questions. I personally prefer to have more questions for each passage, to make up the reading time.

Hussain, there is a small mistake in the Verbal chart in the Analysis1 page, the range of last questions is 31-41 instead of 31-37.

A small suggestion: it would be great to see in the chart how many DS or PS were wrong, and how many SC, CR and RC were wrong. I also include this questions in my error log, but just in case if anyone wants to quickly see which type of questions had more trouble with during the test.
Attachments

Analysis2.jpg
Analysis2.jpg [ 61.43 KiB | Viewed 15692 times ]

Analysis1.jpg
Analysis1.jpg [ 60.21 KiB | Viewed 15633 times ]

User avatar
PTK
VP
VP
Joined: 02 Jul 2009
Status:mission completed!
Posts: 1139
Own Kudos [?]: 2129 [1]
Given Kudos: 622
GPA: 3.77
Send PM
GMAT ToolKit User Reviews Badge
Re: GMAT Prep Analysis Tool [#permalink] New post   19 Oct 2010, 23:59
1
Kudos
Quote:
A small suggestion: it would be great to see in the chart how many DS or PS were wrong, and how many SC, CR and RC were wrong.


Good point cano, but i would suggest just to disclose this info just in writeen without graphs as it would be too much graph info.
User avatar
cano
BSchool Moderator
Joined: 19 Feb 2010
Posts: 271
Own Kudos [?]: 521 [0]
Given Kudos: 76
Send PM
Re: GMAT Prep Analysis Tool [#permalink] New post   20 Oct 2010, 00:24
Pkit wrote:
Quote:
A small suggestion: it would be great to see in the chart how many DS or PS were wrong, and how many SC, CR and RC were wrong.


Good point cano, but i would suggest just to disclose this info just in writeen without graphs as it would be too much graph info.


You are right, that would be the best way. +1
I didn't mean to make a separate graphic. But anyways iIf the current graphic is too full of info then maybe the best place is in nearby cells below the Analysis2 # of Q Graphic.

If members will post their screen shots so we could compare to each other, it would be good to have the number of wrong questions each had. Even when having the same number of wrong questions doesn't mean the same score, it would reflect more convincingly how adaptive the GMATPrep is. For example, I had 17 mistakes in the verbal section and someone else had also 17, then comparing in which sub range of questions each had the mistakes will give us the difference in the verbal score, and we can see the limits of each score for a given number of mistakes.

The real challenge will be to gather the data from each member and make a big spreadsheet comparing all the results. But first we need the individual analysis. Please collaborate!
User avatar
Hussain15
Retired Moderator
Joined: 18 Jun 2009
Status:The last round
Posts: 1078
Own Kudos [?]: 3046 [0]
Given Kudos: 157
Concentration: Strategy, General Management
Schools: Stanford '14 (D) Booth '14 (D) Johnson '14 (D)
GMAT 1: 680 Q48 V34
Send PM
GMAT ToolKit User
Re: GMAT Prep Analysis Tool [#permalink] New post   20 Oct 2010, 00:51
cano wrote:
Hussain, there is a small mistake in the Verbal chart in the Analysis1 page, the range of last questions is 31-41 instead of 31-37.

A small suggestion: it would be great to see in the chart how many DS or PS were wrong, and how many SC, CR and RC were wrong. I also include this questions in my error log, but just in case if anyone wants to quickly see which type of questions had more trouble with during the test.


Thanks for pointing. I have fixed the typo.

I am working on your suggestion. Will revert back & update soon!
User avatar
Hussain15
Retired Moderator
Joined: 18 Jun 2009
Status:The last round
Posts: 1078
Own Kudos [?]: 3046 [1]
Given Kudos: 157
Concentration: Strategy, General Management
Schools: Stanford '14 (D) Booth '14 (D) Johnson '14 (D)
GMAT 1: 680 Q48 V34
Send PM
GMAT ToolKit User
Re: GMAT Prep Analysis Tool [#permalink] New post   20 Oct 2010, 02:55
1
Kudos
cano wrote:
Hussain, there is a small mistake in the Verbal chart in the Analysis1 page, the range of last questions is 31-41 instead of 31-37.

A small suggestion: it would be great to see in the chart how many DS or PS were wrong, and how many SC, CR and RC were wrong. I also include this questions in my error log, but just in case if anyone wants to quickly see which type of questions had more trouble with during the test.


Typo error fixed & a new analysis sheet is added showing the count of correct/incorrect answers of each question type.

Do let me know if it serves the purpose.
GMAT Club Bot
gmatclubot
Re: GMAT Prep Analysis Tool [#permalink]
20 Oct 2010, 02:55
 1   2   

Powered by phpBB © phpBB Group | Emoji artwork provided by EmojiOne
Main navigation
GMAT Resources
Partners
MBA Resources
www.gmac.com|www.mba.com | | GMAT Club Rules | Terms and Conditions