Announcement

Collapse
No announcement yet.

Statistical Tool for the MT Geeks

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • #46
    Re: Statistical Tool for the MT Geeks

    [quote author=Argumentative link=topic=2855.msg164282#msg164282 date=1204932422]
    That's all we need... cheerleaders, full scholarships and the Mock Trial BCS
    [/quote]

    Don't forget the coach buses, and mascots, and...oh it would be so exciting!
    Hello Harry, what sort of tomfoolery shall we get up to today? No tomfoolery today, Ron.

    Comment


    • #47
      Re: Statistical Tool for the MT Geeks

      For those inquiring about a Excel-based method to create tab summaries:

      Pete Allen, from University of Pittsburgh, and I have created a spreadsheet which automates a great deal of the Tab Summary process. A more basic version of it was used successfully at the Syracuse Regional. Since then, the visual layout of the Tab Summary has been improved signficantly and additional information is included on the Team Summaries.

      Brief description of features:

      By just selecting the opponent from a drop down menu and entering the point differentials for the two ballots from a given round, the sheet automatically calculates, W, L, or T. That then is used to calculate a running PD and W-L record. Starting in Round 2, it automatically calculates the CS for every team. It does the same after every round.

      All of this is automatically exported to a Tab Summary.

      As to the automation of Tie Breakers, that would be fairly simple for just Win/Loss and CS. However, I haven't figured out (and haven't been able to spend much time) how to automatically calculate the SOO (Strength of Opposition). If anyone has any ideas or thoughts, please PM me or email me at d.letrich@cornellmocktrial.org .

      As I mentioned, this was used to do the Tab Summary at the Syracuse Regional. It will also be used next weekend to do the Tab Summary at one of the National Tournaments. At the moment, this spreadsheet should only be used for Tab Summary purposes, but in the future, with AMTA approval, it might be a good 3rd check when running the tab room.

      Also, on it there is a means to calculate the Individual Awards automatically or if nothing else, provide a comprehensive list of every competitors ranks in the tournament.

      I'll post a link to what I'm working on in the next day or two.

      i (heart) my mock stars. Love, the five greatest rappers of all time.

      Comment


      • #48
        Has this ever been updated? Or is there some version of this floating around somewhere?

        Comment


        • #49
          Yes I'd be very interested in this program if someone uploaded it

          Comment


          • #50
            Originally posted by bawler View Post
            Has this ever been updated? Or is there some version of this floating around somewhere?
            Are you referring to the Arizona stats program or the Tab Summary one?
            If you want the Arizona one, I have a copy, which can be found here:
            http://dl.dropbox.com/u/1524657/JWGBallot.zip

            Additionally, I've created my own stats program, based in part on the Arizona. It is a work in progress, but I (admittedly biased) really like it. The latest version can be found here:
            http://dl.dropbox.com/u/1524657/MockStats.xlsx

            If you are referring to the Tab Summary sheet, I do not have a copy of that, though I would be very interested to see one. I am currently considering creating either an Excel sheet or a Java application to automate tab room calculations and pairings, and seeing the sheet described above would be helpful
            Ray Barr (the Amazing)
            University of Minnesota Law School
            Drake University, 2014
            "Bow ties are cool."

            Comment


            • #51
              Originally posted by captainbowtie View Post
              Additionally, I've created my own stats program, based in part on the Arizona. It is a work in progress, but I (admittedly biased) really like it. The latest version can be found here:
              http://dl.dropbox.com/u/1524657/MockStats.xlsx
              I have to second how great this stat sheet is, it's been really helpful! Thanks for sharing it with the Perjuries community.
              MLIMT

              Comment


              • #52
                Thank you captain bowtie! That is exactly what I wanted! Might I add that you are quite the genius. The updated program is intense but very helpful

                Comment


                • #53
                  I just got back from a cruise.

                  "What does this have to do with statistics," you say? Well during this cruise (and the flight to Seattle) I worked on my ballot and team statistics tool, and recently finished the changes I wanted to make before releasing the next version. While a more comprehensive list of the changes can be found in the file, here's an overview:
                  • Added metric for comparing scores relative to the team's average score. Before, it was just compared to the ballot's average score.
                  • Removed team and ballot percentage. These are redundant and convoluted.
                  • Added "Team Scores" to give a better idea of big picture things that need work.

                  The latest version, as always, can be found at the link below. If you have any suggestions for features, I'd love to hear them.

                  http://dl.dropbox.com/u/1524657/Files/MockStats.xlsx
                  Ray Barr (the Amazing)
                  University of Minnesota Law School
                  Drake University, 2014
                  "Bow ties are cool."

                  Comment


                  • #54
                    Originally posted by captainbowtie View Post
                    I just got back from a cruise.

                    "What does this have to do with statistics," you say? Well during this cruise (and the flight to Seattle) I worked on my ballot and team statistics tool, and recently finished the changes I wanted to make before releasing the next version. While a more comprehensive list of the changes can be found in the file, here's an overview:
                    • Added metric for comparing scores relative to the team's average score. Before, it was just compared to the ballot's average score.
                    • Removed team and ballot percentage. These are redundant and convoluted.
                    • Added "Team Scores" to give a better idea of big picture things that need work.

                    The latest version, as always, can be found at the link below. If you have any suggestions for features, I'd love to hear them.

                    http://dl.dropbox.com/u/1524657/Files/MockStats.xlsx
                    Nicely done sir. But, for the love of God, why were you working on this crap on a cruise? =P
                    "Call on God, but row away from the rocks." - Hunter S. Thompson

                    Comment


                    • #55
                      I've been working on and off on a new statistics tool for the past year or so, and its now in a state at least fit for initial release. Similar to my previous project, this allows for stat tracking across tournaments throughout the season. However, this one has several notable improvements:
                      • Infinite number of tournaments. Previously, the program was limited to the number of sheets included in the Excel file. By writing the program in Java, I was make an unlimited number of tournaments. (Technically limited to something like 2^32, but you'd have to go to 11 million tournaments a day to meet that limit)
                      • Fine grain analysis. You can now see scores just on things such as just prosecution opening or just Bowman witness scores.
                      • Season period differentiation. You can assign a tournament to pre-stack or post-stack. This is helpful to distinguish scores from first-year members early in the season from later scores, so the early scores aren't used in average calculations.


                      I am still in the process of writing documentation for the program, however, it can currently be downloaded and experimented with here:
                      https://dl.dropboxusercontent.com/u/.../MockStats.jar

                      The program requires Java to run.

                      Note that this is truly a program and that the data the program operates on are saved in separate files. To saved entered data, select the save option from the main menu. Changes are not saved automatically, you must save entered data to a file using this option. To load saved data, select load season when you first open the application. A sample season may be found here:
                      https://dl.dropboxusercontent.com/u/...e%20Stats.mock

                      Finally, here's a link to the source code, should anyone want it:
                      https://github.com/captainbowtie/MockStats
                      Last edited by captainbowtie; April 22nd, 2014, 01:28 PM. Reason: Added link to source code
                      Ray Barr (the Amazing)
                      University of Minnesota Law School
                      Drake University, 2014
                      "Bow ties are cool."

                      Comment


                      • #56
                        Looks like most of the links in this thread are outdated. Anyone have new ones or a recommendation for a statistical tool they use?

                        Comment


                        • #57
                          New? No. Updated links? Yes:

                          Download page for releases of the java program:
                          https://github.com/captainbowtie/MockStats/releases

                          Source code (same link):
                          https://github.com/captainbowtie/Moc...Stats-1-(Swing)

                          Sample File:
                          https://1drv.ms/u/s!Am1DC7SE-ro5js4g3Sqp6iPkj1gAig

                          Excel Sheet for Calculating Stats (unrelated to the above three links):
                          https://1drv.ms/x/s!Am1DC7SE-ro5jr0CiwtpJBRy-7mGQA
                          Ray Barr (the Amazing)
                          University of Minnesota Law School
                          Drake University, 2014
                          "Bow ties are cool."

                          Comment

                          Working...
                          X