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  
Post Info TOPIC: Answer Key Statistics and Spreadsheet


Senior Member

Status: Offline
Posts: 197
Date:
Answer Key Statistics and Spreadsheet


I was bored and decided to create a spreadsheet breaking out all of the answer keys that have been posted here.  It assigns a "confidence level" to all questions based on how many individuals selected a particular answer.  If you input your answers (Just clear mine and put in yours), it will break down how many you have correct or incorrect in each of the applicable categories.

Feel free to improve on it if you want, or if something amazing happens, I will update it as necessary.

 

I cannot attach it to this post so just go to the following link and download it.

http://www.ottrack.com/downloads/AnswerKey.xlsx



__________________


Senior Member

Status: Offline
Posts: 196
Date:

doesnt work bro

__________________


Guru

Status: Offline
Posts: 677
Date:

Well I guess i figured out who made the ottrack program. Good job with this.


__________________


Senior Member

Status: Offline
Posts: 197
Date:

unborn wrote:

Well I guess i figured out who made the ottrack program. Good job with this.


 Thanks.  Yeah, I needed to use something to host the file and the OT track server seemed as good a place as any.

 

IhaveNoHook wrote:

doesnt work bro


 

It should.  Make sure you are using Excel 2007 or 2010.  If you are still using 2003, install the 2007 compatability pack and it should work fine.



__________________


Senior Member

Status: Offline
Posts: 194
Date:

nice breakdown, thanks

__________________


Senior Member

Status: Offline
Posts: 338
Date:

Wow- I thought I had no life.

Just kidding, thanks for the effort.

 

I think the next thing would be trying to figure out which questions are the low/moderate ones.  I have absolutely not idea which is which, but I think you could guess which ones they are based on the old threads with the arguments about the "controversial" questions.



-- Edited by NYPD231 on Monday 7th of November 2011 03:53:50 AM

__________________


Veteran Member

Status: Offline
Posts: 26
Date:

Well done. I trust you got more of the math questions correct than I did.

 

72 (60, 4, 8) by your system. Hope that works.



__________________


Senior Member

Status: Offline
Posts: 407
Date:

Nice, does it add youre answers to the rest of list when it calculates ? Can this somehow be centralized ?



-- Edited by NYG37 on Monday 7th of November 2011 04:04:42 AM

__________________


Senior Member

Status: Offline
Posts: 338
Date:

So I have 6 wrong that are marked as "high." The other 10 marked wrong are either low or moderate. Then some that I had originally marked as correct that are now showing as low or moderate. What are there, 25 low or moderate total? I don't know how to interpret that. I think I'm giving up and just waiting for the 28th. Careful, this chart might make it on to the next LT's test.

__________________
CRS


Member

Status: Offline
Posts: 6
Date:

Nice Job! Thanks..........crash.gif

 



__________________


Senior Member

Status: Offline
Posts: 158
Date:

Pretty Impressive

__________________

 



Guru

Status: Offline
Posts: 975
Date:

this is amazing, job well done, i hope this is as close to accurate as it can get before the real key is out,

__________________


Senior Member

Status: Offline
Posts: 197
Date:

It is based on the 25 or so answer keys posted on this site. The way it determines the confidence level is by looking at the most selected answer and comparing it to the next highest. If the highest is at least double the next highest, it gets a high confidence rating. A moderate rating requires at least a 1.5x over the next highest answer. A low rating is everything lower than 1.5x.

Tomorrow I will see if I can match up some of the questions to the ratings. As for centralizing, I can do that in Excel, but it is overly complicated. It would be easier to just build a database where people can input their scores. I will look into it and if I have time, I will see what I can do.

__________________


Guru

Status: Offline
Posts: 975
Date:

Gamblor you are amazing, thank you for taking the time to do this,

__________________


Member

Status: Offline
Posts: 5
Date:

Gamblor:

Kudos for your work. We need to protest "Low Confidence" answers with cogent argument. Consequently, most people will benefit.

Keep up the good work.

__________________


Senior Member

Status: Offline
Posts: 200
Date:

Thanks

__________________


Guru

Status: Offline
Posts: 570
Date:

I cannot open or find the file

__________________


Veteran Member

Status: Offline
Posts: 49
Date:

either can i



__________________


Member

Status: Offline
Posts: 14
Date:

Nice work; I'm going to make special note of the following to see what was up for the protest.
About 18 questions based on your chart break down for possible double answers (bad), and another 8 appear to be all over the place, possible bad questions for a throw out.

Bad questions?
25- a/c/d
37- b/c/d
50- a/b/c
56- a/b/d
58- b/c/d
64 a/b/c/d/ = w t f ? no
68- a/c/d
83- a/b/d

Bad/Double Answers?
4- c/d
18- c/d
19- b/d
21- c/d
24- a/d
26- a/c
28- c/d
29- a/b
35- a/b
41- c/d
46- a/b
52- a/b
60- a/d
77- b/c
85- a/c
89- b/c
90- b/c
100- a/c

It should help narrowing down the problem questions and possible bad answers. Thanx. wink



__________________


Senior Member

Status: Offline
Posts: 402
Date:

64 a/b/c/d/ = w t f ?

7 questions with four answers on the last Capt. Exam.


__________________


Veteran Member

Status: Offline
Posts: 54
Date:

for the noobs who cant view the file



download link http://imageshack.us/photo/my-images/406/143y.jpg/



download link http://imageshack.us/photo/my-images/411/4486.jpg/



download link http://imageshack.us/photo/my-images/545/87100.jpg/

__________________


Senior Member

Status: Offline
Posts: 338
Date:

For all the threads about the judgement questions, 19 of the 25 moderate/low questions are from the patrol guide portion.

__________________
HB


Senior Member

Status: Offline
Posts: 486
Date:

This chart is nice and all but doesnt prove anything

__________________


Senior Member

Status: Offline
Posts: 153
Date:

Almost as confusing as the nine squad chart I heard about. There is a moderately high chance I got a low score. Can anyone wait for the answer key in 3 weeks.

__________________


Senior Member

Status: Offline
Posts: 388
Date:

Just wait until the 28th. All these answer keys and spread sheets will make you insane. My Sgt's test final answer key was 15 off of the rising star/academy key.

__________________


Guru

Status: Offline
Posts: 975
Date:

It really isn't that hard to understand the chart

__________________


Veteran Member

Status: Offline
Posts: 33
Date:

Thanks for all the hard work. I am right on the cusp, 67 according to this, many of the low confidence answers I have wrong, so hopoefully I pick up a few.

__________________


Guru

Status: Offline
Posts: 727
Date:

65/75 on the "high confidence". Should be fine.


__________________


Guru

Status: Offline
Posts: 523
Date:

There only are 75 total "high confidence" which is what makes this answer key all over the place. I hope its accurate, it would give me an 80 (64hc,8mc,8lc) raw score, I would take that in a second with this brutal test.

__________________


Veteran Member

Status: Offline
Posts: 62
Date:

Who s to even say the high confidence answers are even right. This is the one test where you really can't go by this master key because the questions were that off the wall . This wasn't an open book test like that 2011 sgt test

__________________
Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.

Tweet this page Post to Digg Post to Del.icio.us