in reply to Re^3: Querying Saints in our Book (2)
in thread Querying Saints in our Book (2)

Sure, using median might help, as would grouping. Any suggestions as to the criteria? :)

I'd like to see a XP per response level stat ( Re^n: ), but accessing the DB is outside of your possibilities.

Yeah, if only i had db access. It'd be fun to write and run all those queries.

Replies are listed 'Best First'.
Re^5: Querying Saints in our Book (2) (updated)
by LanX (Saint) on May 17, 2016 at 21:36 UTC
    Well you can work around it...

    ... you can easily order a monks writeups by reputation.

    And if you cast votes at certain thresholds (like quantiles) you can even tell the vote range and calculate a statistically solid estimation.

    But I wouldn't expect tye to be too happy if you do this automatically and at large scale ;)

    update

    e.g. after ordering your 863 posts best first and voting in a logarithmic scale I see

    Rank Votes 430 5 215 8 107 13 53 18 26 21 13 26 7 30

    you are deciphered my friend ;-)

    Cheers Rolf
    (addicted to the Perl Programming Language and ☆☆☆☆ :)
    Je suis Charlie!

      Ya know, that sounds cool and stuff. But, i sadly have to admit, have no idea what any of it means.

      Ordering Writeups by rep works even if you cannot see the rep? That is, is it accurate?

      And if you cast votes at certain thresholds (like quantiles)

      Please explain that a bit more. I keep thinking i know what you mean, but i don't.

      I wouldn't expect tye to be too happy if you do this automatically and at large scale

      The purpose of the above query is just on SioB, the one static page, and the data that is there. It might be fun for more pages to include queries but that would not be large scale. Eventually, though, i might use the xml for all the polls and poll ideas to have some fun querying with that.

      after ordering your 863 posts best first and voting in a logarithmic scale

      And my voting? What exactly are you doing? Admittedly, the big words make it sound interesting. :P

      you are deciphered my friend

      I will neither confirm nor deny the veracity of that statement, though i think you meant to add a comma to it. :)

        > And if you cast votes at certain thresholds (like quantiles)

        > Please explain that a bit more. I keep thinking i know what you mean, but i don't.

        Prerequisites:

        Normally I don't know how many votes your posts got, because I am LanX and not chacham and havent voted on all your writeups.

        Approach
        • I can order your writeups by votes and I (normally) see immediately the reply level by parsing the /Re:^(\d+)/ part
        • After voting at the middle of the 863 entries list at position 430 I see how many votes you got there +1 (here 4)
        • All following posts in this ordering have less or equal votes which is in a narrow margin (here <=4)
        • After voting at the middle of the upper list at position 215 I see how many votes you got there +1 (here <=7)
        • that means all posts between 215 and 430 have 4<=x<=8 votes
        • repeat these upper steps for 12.5%, 6.75%, ... and so on (here position 107 53 26 13 7 ...)
        • you get a logarithmic scale with narrow margins of votes
        Result
        Now you can pretty well approximate how many votes someone got for different reply levels

        For instance between 7th and 15th writeup there is only one level 2 post so you get @levelcount= (3, 4, 1) with votes 26<=x<=30

        Consequence

        You get a very good approximation of votes per level for one user after only casting votes on 1% of his writeups.

        Additionally you can also approximate the percentage of XP he got by votes cast by himself.

        Clearer now? :)

        Cheers Rolf
        (addicted to the Perl Programming Language and ☆☆☆☆ :)
        Je suis Charlie!

        Some fodder for your endeavour.

        A summary of my post scores:

        Which will allow you to test the logarithm hypothesis; and would allow you a datapoint for determining how much of the XP is down to votes cast by others; and how much down to the votes I cast and the daily freebies.

        Except that the calculated total shows that SioB undervalues my contributions to PM by 42%!


        With the rise and rise of 'Social' network sites: 'Computers are making people easier to use everyday'
        Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.
        "Science is about questioning the status quo. Questioning authority". I knew I was on the right track :)
        In the absence of evidence, opinion is indistinguishable from prejudice.