RISING STAR ! The ultimate source to ace your NYPD Sergeant, Lieutenant, and Captain Exam Visit www.RisingStarPromotion.com to subscribe to our mailing list and get info on the next Sgt, Lt. or Captain Exam!

Members Login
Username 
 
Password 
    Remember Me  
Rising Star for the NYPD Sergeant, Lieutenant, and Captain Exam -> 2014 Captain Exam -> Post Test Spreadsheet - UPDATED - 9/19/14 @ 2040 hours
Post Info TOPIC: Post Test Spreadsheet - UPDATED - 9/19/14 @ 2040 hours
Gamblor


Senior Member

Status: Offline
Posts: 197
Date:
Post Test Spreadsheet - UPDATED - 9/19/14 @ 2040 hours
Permalink  

OK, the eighth release is ready.  It contains 37 keys.

 

Version 5 fixed the issue where users with older versions of Excel were getting #REF errors in the Most Likely field (Thank you to unborn who found the root cause of the problem).  Version 4 fixed the way the Best and Worst possible scores are calculated.  I had an issue as the range was too wide which was caused because I forgot to change something when I adapted this from the 2013 Sergeants test that had 30 research questions.  The Most Likely score is unchanged.

 

For those who are new to this, the spreadsheet works as follows:

 

Download the Excel file linked below.  Once you open it, enter your own answers in the space provided on the left.  The spreadsheet breaks down the test as follows:

1) It assigns a "Confidence Level" to each question.  High means that a vast majority of people selected that answer.  Moderate means that it is close but the top answer is still decently above the others.  Low means that it is still a potential double answer, or too close to call.

2) Your correct and wrong answers are broken down by these confidence levels, so you can easily see how you did on the questions that are most likely accurate and the others that are less so.

3) Potential double answers are also counted and how many where you have at least one.

4) Wrong answers are colored red on the left.  Doubles where you have the other one is colored orange.

5) The biggest thing here is the potential score.  I broke it down into three categories: Best Possible, Worst Possible, and Most Likely.  The Best and Worst are the two extremes (such as having all 20 of the research questions as wrong, getting all doubles; or having 20 research as right and losing doubles respectively).  The most likely scenario uses some general probability to determine how many of the research questions and doubles will affect you negatively.

Historically, this key ends up being about 90% accurate with the final published answer key from DCAS.  I try to account for a margin of error so the Most Likely score you see should be very close to what you actually get when the proposed key comes out.

http://www.ottrack.com/downloads/AnswerKey-2014-Capt.xlsx



-- Edited by Gamblor on Saturday 20th of September 2014 12:39:36 AM

__________________
youcallwebrawl


Veteran Member

Status: Offline
Posts: 90
Date:
RE: Post Test Spreadsheet
Permalink  

Thanks for doing the 2013 Sgts answer key bro, it was dead on!



__________________
Gamblor


Senior Member

Status: Offline
Posts: 197
Date:
Permalink  

Alright ladies and gentlemen, time to figure out if I, errr...I mean you guys, will be Captains.

I'll start putting together the answer key this evening. For those that are now arriving home, send me a PM with your answer selections. You can just type them out. If you need to, take a picture of your answers and send that and I'll transpose it.

Hopefully I get enough tonight that I can post something meaningful before I go to bed.

__________________
jons463


Member

Status: Offline
Posts: 20
Date:
Permalink  

PM ed it to you. Thanks again.



__________________
Gamblor


Senior Member

Status: Offline
Posts: 197
Date:
Permalink  

Come on people, where's the excitement? The last captain's test, I had about 15 keys on the first night. Does everyone really want to wait 5 weeks? You should be impatient like me.

Let's go...less drinking, more PMing.



-- Edited by Gamblor on Sunday 14th of September 2014 02:19:08 AM

__________________
tensixone


Senior Member

Status: Offline
Posts: 337
Date:
Permalink  

Lets go



-- Edited by tensixone on Sunday 14th of September 2014 03:31:49 AM

__________________
Gamblor


Senior Member

Status: Offline
Posts: 197
Date:
Permalink  

I have 6 so far, counting my own. That's a little light to use. I need at least 10, preferably 15 before it becomes somewhat reliable.

__________________
Captain Kangaroo


Newbie

Status: Offline
Posts: 3
Date:
Permalink  

I just PMed you



__________________
One porkchop


Veteran Member

Status: Offline
Posts: 85
Date:
Permalink  

Here's another



Attachments
__________________
stillwaiting


Veteran Member

Status: Offline
Posts: 54
Date:
Permalink  

I have pm you but don't know how to take it off from here



-- Edited by stillwaiting on Sunday 14th of September 2014 04:27:42 PM

Attachments
__________________
Gamblor


Senior Member

Status: Offline
Posts: 197
Date:
RE: Post Test Spreadsheet - UPDATED - 9/14/14 @ 1300 hours
Permalink  

Original post updated. Download link is there.

__________________
Abeyance


Senior Member

Status: Offline
Posts: 247
Date:
Post Test Spreadsheet - UPDATED - 9/14/14 @ 2320 hours
Permalink  

 

 

 

thanks, btw, how do you account for the 20 that do not count?



-- Edited by Abeyance on Monday 15th of September 2014 02:45:04 PM

__________________
Gamblor


Senior Member

Status: Offline
Posts: 197
Date:
RE: Post Test Spreadsheet - UPDATED - 9/14/14 @ 1300 hours
Permalink  

Basically, I use a percentage of the 20 questions against the total you have wrong to make a statistical guess on how many of your wrong answers would not actually count. Depending on how many you have wrong, the number applicable adjusts. It's mostly probability, so there is a margin of error, but it's fairly accurate. From the 2013 sergeants exam, where they had 30 research questions, my estimates of individuals' most likely score was either spot on, or one or two off.

__________________
bha78


Senior Member

Status: Offline
Posts: 127
Date:
Permalink  

I sent you mine as well. Thanks for all that you have done with this.

__________________
hollar


Guru

Status: Offline
Posts: 570
Date:
Permalink  

Answer sheet attached



Attachments
__________________
stillwaiting


Veteran Member

Status: Offline
Posts: 54
Date:
Permalink  

What's the percentage of the 20 questions in your opinion so that I could plug it in and compare to the difference with the other keys

__________________
EveryoneLovesChris


Member

Status: Offline
Posts: 17
Date:
Permalink  

Question...are you getting answer keys from hardcore studiers only? I didn't open the book do you still want mine? PS what kind of nerd comes up with a spreadsheet like this?!? Lol just kidding....but seriously....

__________________
Gamblor


Senior Member

Status: Offline
Posts: 197
Date:
Permalink  

EveryoneLovesChris wrote:

Question...are you getting answer keys from hardcore studiers only? I didn't open the book do you still want mine? PS what kind of nerd comes up with a spreadsheet like this?!? Lol just kidding....but seriously....

 

I'll take keys from anyone.  Really bad answers will get drowned out by the majority and those that you got right will reinforce the selection.  As for the type of nerd, it takes a special kind.

 

stillwaiting wrote:

What's the percentage of the 20 questions in your opinion so that I could plug it in and compare to the difference with the other keys

 

I'm not sure what you're asking.  The spreadsheet already factors in how many research questions will likely affect you.



__________________
iamdtm28


Newbie

Status: Offline
Posts: 3
Date:
Permalink  

I sent you my key, I would like to think I studied hard, but I know there are guys that did much more. According to the sheet Best is 100 worst is 55 and probable is 74.

__________________
stillwaiting


Veteran Member

Status: Offline
Posts: 54
Date:
Permalink  

I am still trying to figure out my score based on Gamblor keys can somebody please enlighten me. My breakdown is I got 34 different answer breakdown like this:

High=22

Low=4

moderate=8



-- Edited by stillwaiting on Sunday 14th of September 2014 08:30:06 PM

__________________
Gamblor


Senior Member

Status: Offline
Posts: 197
Date:
Permalink  

On the right, below where you are getting those numbers from, there is a box labeled, "Potential Score"

__________________
stillwaiting


Veteran Member

Status: Offline
Posts: 54
Date:
Permalink  

ok, thanks


__________________
Gamblor


Senior Member

Status: Offline
Posts: 197
Date:
RE: Post Test Spreadsheet - UPDATED - 9/14/14 @ 1640 hours
Permalink  

Updated the key. Same download link above.

__________________
wereinbacklog


Guru

Status: Offline
Posts: 1412
Date:
Permalink  

I think we can make this Key more precise.


__________________
wereinbacklog


Guru

Status: Offline
Posts: 1412
Date:
Permalink  

1 and 3 are definitely, C and A respectively if I remember correctly. PM me for discussion.

__________________
Inspector71


Veteran Member

Status: Offline
Posts: 62
Date:
Permalink  

Do you have another way to download the file because for some reason I can't access the link?



-- Edited by Inspector71 on Sunday 14th of September 2014 11:11:48 PM

__________________

"We don't choose to shoot people. People choose for us to shoot them." Polk County Sheriff Grady Judd

 

"The best way to not get shot by a New York City police officer is not carry a gun and not raise that gun toward them," William Bratton 
bha78


Senior Member

Status: Offline
Posts: 127
Date:
Permalink  

How many keys are you working with now Gamblor? And I would like to thank you for putting in all this work. Hope that you passed this test.

__________________
Gamblor


Senior Member

Status: Offline
Posts: 197
Date:
Permalink  

I only have one key more from the one that is already posted. I'll keep updating it as I get them.

At the moment, it looks good for me...Most Likely is 82.

__________________
King780


Veteran Member

Status: Offline
Posts: 75
Date:
Permalink  

I just pm'd you gambler, nice job btw



__________________
soccerpsyco32


Senior Member

Status: Offline
Posts: 342
Date:
Permalink  

Just so everyone here is aware, Gamblor's answer key spreadsheets have been very accurate from a historical standpoint. Go onto the 2013 SGT exam thread and other exams and you'll see that for countless people, Gamblor's spreadsheet had them within one or two points and in most cases it was dead on!

__________________
One porkchop


Veteran Member

Status: Offline
Posts: 85
Date:
Permalink  

I'm at most likely 69 with 4 possible doubles. ..I am the definition of on the fence...but man would that such if he's dead on. Let us pray



__________________
hollar


Guru

Status: Offline
Posts: 570
Date:
Permalink  

How did he come up with the double answer possibility?

__________________
wereinbacklog


Guru

Status: Offline
Posts: 1412
Date:
Permalink  

Gamblor wrote:

Basically, I use a percentage of the 20 questions against the total you have wrong to make a statistical guess on how many of your wrong answers would not actually count. Depending on how many you have wrong, the number applicable adjusts. It's mostly probability, so there is a margin of error, but it's fairly accurate. From the 2013 sergeants exam, where they had 30 research questions, my estimates of individuals' most likely score was either spot on, or one or two off.

 



__________________
Gamblor


Senior Member

Status: Offline
Posts: 197
Date:
RE: Post Test Spreadsheet - UPDATED - 9/14/14 @ 2320 hours
Permalink  

Key updated. Download link is the same and in the first post.

Sourcing 24 keys now.

__________________
TrYAGaiN


Veteran Member

Status: Offline
Posts: 62
Date:
Permalink  

hey. what's the formula for the most possible score? my worksheet took it out for some reason. i can get my most possible score. 



-- Edited by TrYAGaiN on Monday 15th of September 2014 12:13:05 PM



-- Edited by TrYAGaiN on Monday 15th of September 2014 12:36:02 PM

__________________
Gamblor


Senior Member

Status: Offline
Posts: 197
Date:
Permalink  

TrYAGaiN wrote:

hey. what's the formula for the most possible score? my worksheet took it out for some reason. i can get my most possible score. 



-- Edited by TrYAGaiN on Monday 15th of September 2014 12:13:05 PM



-- Edited by TrYAGaiN on Monday 15th of September 2014 12:36:02 PM

 If you have an older version of Excel, it may sometimes have an issue.  You can send me your answers and I'll run them for you.



__________________
Gamblor


Senior Member

Status: Offline
Posts: 197
Date:
RE: Post Test Spreadsheet - UPDATED - 9/15/14 @ 1820 hours
Permalink  

Spreadsheet updated. Same number of source keys, but changed the calculation on the best and worst possible scores (I forgot to change something when I adapted this from the 2013 Sergeants Exam). The Most Likely score was not affected so it is still the same as the previous version.

__________________
wereinbacklog


Guru

Status: Offline
Posts: 1412
Date:
Permalink  

My worst possible changed drastically in a good way. Any explanation for the adjustment?



-- Edited by wereinbacklog on Monday 15th of September 2014 11:56:47 PM

__________________
Gamblor


Senior Member

Status: Offline
Posts: 197
Date:
Permalink  

wereinbacklog wrote:

My worst possible changed drastically in a good way. Any explanation for the adjustment?



-- Edited by wereinbacklog on Monday 15th of September 2014 11:56:47 PM

 I still had 30 research questions factored in on the best and worst possible fields (I adapted the sheet I made for the 2013 Sergeant's exam).  I changed it from 30 to 20 everywhere else, but forgot about those two.  The change brought them both in by 10, closer towards the most likely score.



__________________
Gamblor


Senior Member

Status: Offline
Posts: 197
Date:
RE: Post Test Spreadsheet - UPDATED - 9/15/14 @ 2145 hours
Permalink  

Version 5 posted. Fixed the issue with the #REF error on older versions of Excel (thanks to unborn for finding the cause of the issue). Also added one more key.

__________________
King780


Veteran Member

Status: Offline
Posts: 75
Date:
Permalink  

Thanks Gamblor.  

 



__________________
NARC


Member

Status: Offline
Posts: 12
Date:
Permalink  

Hey Gamblor, here's two more answer sheets.IMG_0074.jpgIMG_2533.jpeg



Attachments
__________________
hollar


Guru

Status: Offline
Posts: 570
Date:
Permalink  

Why is the second answer sheet in red ink?

__________________
Twenty N Out


Veteran Member

Status: Offline
Posts: 32
Date:
Permalink  

Thank you Gamblor for all your hard work on this spreadsheet. My most likely puts me at barely passing right now. I hope it holds true. I have a question. Does DCAS have to identify which questions were for research before they administer the test?

__________________
Huh


Newbie

Status: Offline
Posts: 4
Date:
Permalink  

Here is mine!



Attachments
__________________
Gamblor


Senior Member

Status: Offline
Posts: 197
Date:
Permalink  

Twenty N Out wrote:

Thank you Gamblor for all your hard work on this spreadsheet. My most likely puts me at barely passing right now. I hope it holds true. I have a question. Does DCAS have to identify which questions were for research before they administer the test?

 I have no idea what DCAS' procedure is for identifying research questions.  I know that we don't find out until the protest review session.



__________________
Gamblor


Senior Member

Status: Offline
Posts: 197
Date:
RE: Post Test Spreadsheet - UPDATED - 9/16/14 @ 1850 hours
Permalink  

6th release is posted. Spreadsheet now contains 29 keys.

__________________
PatrolGuideismyBible


Guru

Status: Offline
Posts: 523
Date:
Permalink  

I am at 31 different answers.

Wrong answer breakdown
22 High
2 Moderate
6 Low

Best Possible: 91
Most Likely: 75
Worst Possible: 68

So if Gamblor is on the money yet again, its looking good...

__________________
bha78


Senior Member

Status: Offline
Posts: 127
Date:
Permalink  

Best possible-100
Most likely- 84
Worst possible-79

I'll take it. :)

__________________
Su Madre 24


Guru

Status: Offline
Posts: 1550
Date:
Permalink  

Gamblor please be of assistance come April for my lt exam.

Best of luck to all who took the Capts test.

__________________

67 on 2015 Lt Exam. DISGRACE!

 

Lt Exam Wars

Episode II : Vucinaj Strikes Back

2017
1 2  >  Last»  | Page of 2  sorted by
 
Quick Reply

Please log in to post quick replies.
Rising Star for the NYPD Sergeant, Lieutenant, and Captain Exam -> 2014 Captain Exam -> Post Test Spreadsheet - UPDATED - 9/19/14 @ 2040 hours
Tweet this page Post to Digg Post to Del.icio.us