Given the positive responses from fellow math aficionados regarding my last post which introduced the Advanced Quizzer Rating, I decided to push my luck with one more technical article. Plus, many who have downloaded the revised Naz Quiz Scoresheet have asked “what do all these new numbers mean?” So, consider this post your instruction manual as we navigate through each tab and explain the changes.
The "Average" total represents all quizzers in all games in the file. “AVERAGES” TAB (NEW: TOTAL AVERAGE, POINTS PER WIN, WIN PROBABILITIES)
For all of the games tracked in the file, this page displays the tournament average and scores per game for the individuals and teams you specify. Names entered here will automatically populate the “Details” and “Dashboard” tabs.
The table for the individuals now displays the average for all of the quizzers in all of the games at the bottom of the Average column. Keep in mind that your quizzers influence about half of that number since they are represented in every game in the file.
For all of the games tracked in the file, this page displays the tournament average and scores per game for the individuals and teams you specify. Names entered here will automatically populate the “Details” and “Dashboard” tabs.
The table for the individuals now displays the average for all of the quizzers in all of the games at the bottom of the Average column. Keep in mind that your quizzers influence about half of that number since they are represented in every game in the file.
Click to enlarge To the right of the Team Scores table are two new columns: Estimated Win % and Win Probability.
With your team in the first row, the “Estimated Win %” value for each team predicts that team’s win percentage for the tournament using a probability distribution based solely on how your team performs against them compared to the other teams you play.
The “Win Probability” value is the probability that your team will win your next game against that team based on your prior performance against that team.
Below the Team Scores table are the overall Average Points per Game and your Opponents’ Average Points per Game (assuming your team is in the first row). There is also a calculation of the Estimated and Actual Points per Win (PPW) for all of the matches. This is the score necessary to have a greater than 50% chance of winning a game.
“DETAILS” TAB (NO CHANGES)
No changes were made to this table. It continues to show the total number of correct Toss-Ups for each type of question for each of the players.
“SUMMARY” TAB (NO CHANGES)
No changes were made to this table, either. It shows the number of correct Toss-Ups for each type of question in each match. It also provides a bar chart summarizing the Toss-Up accuracy of each question type for all of the games in the file.
With your team in the first row, the “Estimated Win %” value for each team predicts that team’s win percentage for the tournament using a probability distribution based solely on how your team performs against them compared to the other teams you play.
The “Win Probability” value is the probability that your team will win your next game against that team based on your prior performance against that team.
Below the Team Scores table are the overall Average Points per Game and your Opponents’ Average Points per Game (assuming your team is in the first row). There is also a calculation of the Estimated and Actual Points per Win (PPW) for all of the matches. This is the score necessary to have a greater than 50% chance of winning a game.
“DETAILS” TAB (NO CHANGES)
No changes were made to this table. It continues to show the total number of correct Toss-Ups for each type of question for each of the players.
“SUMMARY” TAB (NO CHANGES)
No changes were made to this table, either. It shows the number of correct Toss-Ups for each type of question in each match. It also provides a bar chart summarizing the Toss-Up accuracy of each question type for all of the games in the file.
“DASHBOARD” TAB (EVERYTHING IS NEW)
This is the big one. All of it is new. Let’s break it down column-by-column:
This is the big one. All of it is new. Let’s break it down column-by-column:
The entirety of the new "Dashboard" tab. Click to enlarge. Averages (per game played) – As opposed to some tournaments that calculate individual averages based on the number of a team’s matches, this calculates each individual’s average based only on the matches in which they participated.
WARP100 – This is a new statistic. Wins Above Replacement Player (WARP) attempts to calculate a player’s contribution to their team's wins above a typical bench (replacement) player extrapolated over 100 games. Since this stat looks at a player's Net Points game-by-game, consistency matters. For example, say Calvin and Hobbs both finish a 5-game tournament with a 20 average. However, Calvin got all 100 of his points in the first two games while Hobbs scored 20 in every game. According to WARP, Hobbs contributed more wins to the team than Calvin.
Ignoring all other considerations, putting those with the highest WARP factor (can I call it that?) on the same team should win the most games. The caveat here is that you know the strengths of the students better than the spreadsheet. For example, if the quizzers with the best WARP factors are all Memory Verse specialists, you might not want to put them all on the same team.
AQR (Advanced Quizzer Rating) – The next two columns calculate each quizzer’s Advanced Quizzer Rating (AQR). The AQR is a composite statistic that takes into account five variables: Correct per Attempt (toss-ups and bonuses), Points Gained per Attempt (toss-ups and bonuses), Points Lost per Toss-Up Attempt, Quiz Outs per Toss-Up Attempt, and Net Points per Game. The AQR in the first column is calculated using the tournament’s average for each of those five variables. To use your own averages (your season-to-date stats, for example), enter those values in the designated row below the table to calculate the Custom AQR shown in the next column. To understand how this math works, check out the previous blog post.
Correct per Attempt (Intellect) – The total number of correct Toss-Ups and Bonuses divided by the total number of Toss-Ups and Bonuses attempted. This is simply the percent of all questions the quizzer answers correctly.
Points Gained per Attempt (Impact) – Total points gained from Toss-Ups, Bonuses, perfect game bonuses, and the player's share when contributing to 3rd-, 4th-, and 5th-person bonuses. For example, if Quizzers A, B, and C correctly answer the Toss-Up to questions 2, 5, and 10 respectively, then all three quizzers earn 3.33 points (10 pts/3 quizzers) for the 3rd quizzer bonus that was awarded on question 10. If Quizzer D answers the Toss-Up on question 13, then all four quizzers earn 2.5 points (10 pts/4 quizzers) for the 4th quizzer bonus.
Points Lost per Toss-Up Attempt (Discipline) – Total points lost from error-out penalties, errors on questions 16-20, errors when the team has accumulated 5 or more errors before question 16, and points gained by the other team resulting from the player’s error. As in game situations, error points are not cumulative for certain situations (an error-out on question 17, for example). However, any opposing team’s points from answering a Bonus does get included with any point deduction (if there is one) on that question.
Quiz Outs per Toss-Up Attempt (Glory) – Total number of Quiz Outs divided by the total number of Toss-Up attempts (jumps).
Net Points per Game (Valor) – Points Gained minus Points Lost per game. This stat provides a lot of insight when compared to the quizzer’s average points per game. If it is significantly lower than the student's average points per game, that implies they either made a lot of errors that resulted in Bonus points for the opposing team and/or they made errors late in the game that resulted in a loss of team points.
Net Points per Toss-Up Attempt – Points Gained minus Points Lost per Toss-Up attempt (jump).
Toss-Up Accuracy – Total number of correct Toss-Ups divided by the total number of Toss-Ups attempted (jumps). A lower than average number here could indicate the quizzer is jumping quicker or more often than they should given their grasp of the material at this event. Doing so is taking opportunities away from their teammates and gifting the other team with Bonus questions.
Bonus Accuracy – Total number of correct Bonuses divided by the total number of Bonuses attempted.
WARP100 – This is a new statistic. Wins Above Replacement Player (WARP) attempts to calculate a player’s contribution to their team's wins above a typical bench (replacement) player extrapolated over 100 games. Since this stat looks at a player's Net Points game-by-game, consistency matters. For example, say Calvin and Hobbs both finish a 5-game tournament with a 20 average. However, Calvin got all 100 of his points in the first two games while Hobbs scored 20 in every game. According to WARP, Hobbs contributed more wins to the team than Calvin.
Ignoring all other considerations, putting those with the highest WARP factor (can I call it that?) on the same team should win the most games. The caveat here is that you know the strengths of the students better than the spreadsheet. For example, if the quizzers with the best WARP factors are all Memory Verse specialists, you might not want to put them all on the same team.
AQR (Advanced Quizzer Rating) – The next two columns calculate each quizzer’s Advanced Quizzer Rating (AQR). The AQR is a composite statistic that takes into account five variables: Correct per Attempt (toss-ups and bonuses), Points Gained per Attempt (toss-ups and bonuses), Points Lost per Toss-Up Attempt, Quiz Outs per Toss-Up Attempt, and Net Points per Game. The AQR in the first column is calculated using the tournament’s average for each of those five variables. To use your own averages (your season-to-date stats, for example), enter those values in the designated row below the table to calculate the Custom AQR shown in the next column. To understand how this math works, check out the previous blog post.
Correct per Attempt (Intellect) – The total number of correct Toss-Ups and Bonuses divided by the total number of Toss-Ups and Bonuses attempted. This is simply the percent of all questions the quizzer answers correctly.
Points Gained per Attempt (Impact) – Total points gained from Toss-Ups, Bonuses, perfect game bonuses, and the player's share when contributing to 3rd-, 4th-, and 5th-person bonuses. For example, if Quizzers A, B, and C correctly answer the Toss-Up to questions 2, 5, and 10 respectively, then all three quizzers earn 3.33 points (10 pts/3 quizzers) for the 3rd quizzer bonus that was awarded on question 10. If Quizzer D answers the Toss-Up on question 13, then all four quizzers earn 2.5 points (10 pts/4 quizzers) for the 4th quizzer bonus.
Points Lost per Toss-Up Attempt (Discipline) – Total points lost from error-out penalties, errors on questions 16-20, errors when the team has accumulated 5 or more errors before question 16, and points gained by the other team resulting from the player’s error. As in game situations, error points are not cumulative for certain situations (an error-out on question 17, for example). However, any opposing team’s points from answering a Bonus does get included with any point deduction (if there is one) on that question.
Quiz Outs per Toss-Up Attempt (Glory) – Total number of Quiz Outs divided by the total number of Toss-Up attempts (jumps).
Net Points per Game (Valor) – Points Gained minus Points Lost per game. This stat provides a lot of insight when compared to the quizzer’s average points per game. If it is significantly lower than the student's average points per game, that implies they either made a lot of errors that resulted in Bonus points for the opposing team and/or they made errors late in the game that resulted in a loss of team points.
Net Points per Toss-Up Attempt – Points Gained minus Points Lost per Toss-Up attempt (jump).
Toss-Up Accuracy – Total number of correct Toss-Ups divided by the total number of Toss-Ups attempted (jumps). A lower than average number here could indicate the quizzer is jumping quicker or more often than they should given their grasp of the material at this event. Doing so is taking opportunities away from their teammates and gifting the other team with Bonus questions.
Bonus Accuracy – Total number of correct Bonuses divided by the total number of Bonuses attempted.
The check boxes in the iOS Numbers version of the spreadsheet. Click to enlarge this photo. Those six fancy charts – Use the check boxes (or the True/False drop-down in Excel) to turn on and off the stats of multiple players. The six charts will update automatically with the combined values of the selected students. Want to see how many Toss-Ups your team is averaging? Or your team’s total accuracy for the different types of questions? Or how many points they gave away in each game? Just check the boxes.
If a chart is not displaying data, be sure all of the names you select participated in at least 1 quiz match.
If a chart is not displaying data, be sure all of the names you select participated in at least 1 quiz match.
Want to give it a try? Please do and let me know what you think, if it was useful, or if you have any questions.
Naz Quiz Scoresheet for iOS Numbers (2-team quizzing)
Naz Quiz Scoresheet for iOS Numbers (3-team quizzing)
On an iPad, after the link opens choose the export button (the button to the right of the address bar) and select "Copy to Numbers". If you have trouble, try the Excel link below and export that to Numbers.)
Naz Quiz Scoresheet for MS Excel (2-team quizzing)
Naz Quiz Scoresheet for MS Excel (3-team quizzing)
Naz Quiz Scoresheet for iOS Numbers (2-team quizzing)
Naz Quiz Scoresheet for iOS Numbers (3-team quizzing)
On an iPad, after the link opens choose the export button (the button to the right of the address bar) and select "Copy to Numbers". If you have trouble, try the Excel link below and export that to Numbers.)
Naz Quiz Scoresheet for MS Excel (2-team quizzing)
Naz Quiz Scoresheet for MS Excel (3-team quizzing)
RSS Feed