Post Test Spreadsheet - UPDATED - 9/19/14 @ 2040 hours
technocrat1 said
Sep 17, 2014
I'm hearing 300 actually sat for the exam, out of 400 that registered. Should be interesting to see how large this list is. In my classroom, after about the 4th hour 50% of the room was empty. I can't see how they were able to finish in that short amount time.
King780 said
Sep 17, 2014
Quick question. How many answer keys did it take to get such an accurate estimated score on the 2013 Captain Exam, and how did the spreadsheet work out for the 2013 Captain Exam.
Thanks again with the spreadsheet, getting an estimated score definitely helps with the post exam anxiety
One porkchop said
Sep 17, 2014
Was accurate for me .. we didn't have 20 extra ? To screw with our possibility
Quick question. How many answer keys did it take to get such an accurate estimated score on the 2013 Captain Exam, and how did the spreadsheet work out for the 2013 Captain Exam.
Thanks again with the spreadsheet, getting an estimated score definitely helps with the post exam anxiety
I had about 50 keys by the end of my updates for the 2013 test. The spreadsheet was pretty accurate for me. It told me I had a 63 and I ended up with a 62.
Gamblor said
Sep 19, 2014
Seventh release is posted. Spreadsheet now contains 33 keys.
One porkchop said
Sep 19, 2014
when I open it it says version 5...only 25 or 26 keys are posted...how do I get the updated key
One porkchop said
Sep 19, 2014
Is anyone else having an issue with the latest key...u am only seeing 25 keys instead of the 33 that it indicates...
itzzblade said
Sep 19, 2014
HERE IS ANOTHER KEY
itzzblade said
Sep 19, 2014
ANOTHER KEY IN ADDITION TO ONES I ALREADY PM YOU GAMBLER
Sorry, I had uploaded the wrong file last night. The issue has been fixed, and the spreadsheet has been updated to version 8, containing 37 keys.
itzzblade said
Sep 20, 2014
WE NEED MORE KEYS TO BE SUBMITTED TO GAMBLOR TO FILTER OUT THE LOW \MODERATE\ EVEN DOUBLE ANSWER QUESTIONS. TO GET A MORE OF A ACCURATE RANGE.
King780 said
Sep 20, 2014
I'm sure the more answer keys the better, but how you can get an estimated score with those extra unknown 20 questions is still puzzling to me, Gamblor is a wiz for coming up with this...Im hearing Gamblors 2 for 2 (2013 Sgt/2013 Capt)
Abeyance said
Sep 21, 2014
quick question for you Gamblor, I understand you are using laws of averages for the best/most likely/worst scores, but what is the exact percentage value for getting that score. In other words if my best is a 73, what is the probability in percentage that I will get that score in relation to the most likely and so forth. I hope I am making sense with my question
wereinbacklog said
Sep 21, 2014
Or what is the margin on error for the most likely score???
technocrat1 said
Sep 21, 2014
It appears that he's using a Normal (bell curve) distribution. The question is what is the Standard Deviation. That would give you an idea of the margin of error, without getting into complex statistical explanations.
Gamblor said
Sep 22, 2014
technocrat1 wrote:
It appears that he's using a Normal (bell curve) distribution. The question is what is the Standard Deviation. That would give you an idea of the margin of error, without getting into complex statistical explanations.
It is a bell curve distribution based on the probability of any particular wrong answer being a research question. I only calculate the most likely scenario, which is easy since 1 in 6 questions will be research. If you want to get into the probability of skewing away from the mean, then you have to factor in the chances of more or less than the average being research questions. For example, if you have 20 wrong answers out of 120, then the average person would have 3.3333 of those as research questions (rounded to 3), giving them a score of 83 with only 17 actually wrong answers (exclusive of other factors like potential doubles). Someone better than me can do the math on the odds of deviating from the norm.
King780 said
Sep 24, 2014
Math was never my strong subject but it sounds good to me. Do you guys think we have enough answer keys to make this accurate, If they say around 300+ sat for the exam. 3 more weeks we shall see.
One porkchop said
Sep 29, 2014
37 keys...do u have anymore or are you waiting for a certain amount before u post a 9th edition
Gamblor said
Sep 30, 2014
One porkchop wrote:
37 keys...do u have anymore or are you waiting for a certain amount before u post a 9th edition
I have one more that was emailed to me the other day. I haven't added it yet, but one more key won't really change the sheet at all.
Quick question. How many answer keys did it take to get such an accurate estimated score on the 2013 Captain Exam, and how did the spreadsheet work out for the 2013 Captain Exam.
Thanks again with the spreadsheet, getting an estimated score definitely helps with the post exam anxiety
Here's mine
Mine
I agree bro,....Gamblor's a genius
This is not a newly promoted Sergeant's forum
my submission
I had about 50 keys by the end of my updates for the 2013 test. The spreadsheet was pretty accurate for me. It told me I had a 63 and I ended up with a 62.
ANOTHER KEY IN ADDITION TO ONES I ALREADY PM YOU GAMBLER
I'm sure the more answer keys the better, but how you can get an estimated score with those extra unknown 20 questions is still puzzling to me, Gamblor is a wiz for coming up with this...Im hearing Gamblors 2 for 2 (2013 Sgt/2013 Capt)
It is a bell curve distribution based on the probability of any particular wrong answer being a research question. I only calculate the most likely scenario, which is easy since 1 in 6 questions will be research. If you want to get into the probability of skewing away from the mean, then you have to factor in the chances of more or less than the average being research questions. For example, if you have 20 wrong answers out of 120, then the average person would have 3.3333 of those as research questions (rounded to 3), giving them a score of 83 with only 17 actually wrong answers (exclusive of other factors like potential doubles). Someone better than me can do the math on the odds of deviating from the norm.
Math was never my strong subject but it sounds good to me. Do you guys think we have enough answer keys to make this accurate, If they say around 300+ sat for the exam. 3 more weeks we shall see.
37 keys...do u have anymore or are you waiting for a certain amount before u post a 9th edition
I have one more that was emailed to me the other day. I haven't added it yet, but one more key won't really change the sheet at all.