Pages:
Author

Topic: Analysis - Merited on multiple Subsections and the Correlation Matrix - Updated (Read 1088 times)

legendary
Activity: 3234
Merit: 5637
Blackjack.fun-Free Raffle-Join&Win $50🎲
I have to admit that I somehow missed this topic at the time it was posted, but I can totally agree with everyone else that this is a very interesting analysis, and I’m sure quite a bit of effort has been put into it all. I was also surprised when I saw I got merits in as many as 13 subsections, but also that the number of members who got them in more than 10 is quite modest considering the number of active forum members.

Keep up the good work and more interesting analyzes👨‍💻
legendary
Activity: 2268
Merit: 16328
Fully fledged Merit Cycler - Golden Feather 22-23
<…> Or is it possible to add as a new tab on The Merit Dashboard?
Over a year and three months later, I managed to get this analysis onto the Merit Dashboard (not precisely RAD)…

Well, I guess that months were very useful to me, as opening the tab I saw my name on the top.

I guess that much of this has been due to my focus on various local boards thanks to threads that were written following this:

Help me translate my best posts in your Local Board

I ventured in quite diverse local boards!

Ah, shame on me, I almost forgot I got merit on the alt-coins board. But that is my little known dirty secret.
legendary
Activity: 2338
Merit: 10802
There are lies, damned lies and statistics. MTwain
<…> Or is it possible to add as a new tab on The Merit Dashboard?
Over a year and three months later, I managed to get this analysis onto the Merit Dashboard (not precisely RAD)…
 
I actually really just wanted to see one specific correlation figure, and rather than update the thread again (or simply keep it to myself), I added the data as a Tab on the Merit Dashboard (which should be updated every week alongside the other tabs):
https://public.tableau.com/views/BitcointalkMeritDashboard/CorrelationMatrix?:language=es&:display_count=y&publish=yes&:origin=viz_share_link

I added a couple of filters to the tab:
- Rank: Delimits the information per rank, allowing to see how the correlation number change per rank (similar to the last manual update I did on the Merit Dashboard).

- Total Merits: To exclude or delimit the data to users with a certain amount of Merits.

- Name: To search for a given profile, although the Correlation Matrix barely makes sense for a single profile, unless we focus on the number of merited subsections per user (excluding Deleted).

The Correlation Matrix is expressed now both in absolute terms (number of profiles) and relative terms (% of profiles in subsection x (rows) are also merited on subsection y (columns)).

The concepts are the same as those described in the OP.
legendary
Activity: 2338
Merit: 10802
There are lies, damned lies and statistics. MTwain
Getting 10+ merits on as many boards as possible is definitely my new year’s resolution for 2020.
Star Trek just came to my mind here, exploring new frontiers …

<…>
well I was thinking it does help to speak multiple languages .if you are fluent in three languages getting merits In two local boards should be easy. Then of course english as your third language makes for a lot of subsections to post.
True, although in the OP I’ve treated all local boards as one, meaning that they are only accounted for once.

I recall looking at some point at which forum members had been merited on multiple local boards (not going into language that have a thread rather than a board). Looking at this specific element now, it turns out that:
Code:
user_id   Name                     Rank                nSections banned
1267993   Leteravian               Full Member         9         
459836    LoyceV                   Legendary           5         
507936    DarkStar_                Legendary           4         
1606609   Furgon Chino             Member              4         
1067333   micgoossens              Legendary           4         
1038373   narghat                  Jr. Member          4         
389306    bitrefill                Jr. Member          3         
1852120   fillippone               Hero Member         3         
1210969   JSRAW                    Hero Member         3         
1018610   luna2017                 Member              3         Banned
522205    mr.relax                 Hero Member         3         
263246    pazor_true               Legendary           3         
217199    sbogovac                 Legendary           3         
1311641   tvplus006                Hero Member         3         
1891055   vladimirhf               Member              3         
131333    wwzsocki                 Legendary           3         
2143453   1miau                    Hero Member         2         
877396    AdolfinWolf              Legendary           2         
2162672   aga0685                  Member              2         
1975036   AirdropsMob              Jr. Member          2         
86549     alexrossi                Legendary           2         
1107844   amishmanish              Sr. Member          2         
1215537   Arrrvin                  Member              2         
1580039   asche                    Hero Member         2         
2101964   aseemhamza               Jr. Member          2         
954325    BARADED                  Full Member         2         
1224889   Becassine                Full Member         2         
257004    big_daddy                Sr. Member          2         
2221461   Bitzlato                 Jr. Member          2         
1976275   blokklanc                Jr. Member          2         
353488    Boinkit                  Full Member         2         
1445331   bozicso                  Member              2         
964086    CharlieCox               Member              2         
1061308   chem96                   Full Member         2         
353680    chronicsky               Legendary           2         
482277    cloakteam                Sr. Member          2         
154563    Cloudbet                 Legendary           2         
1324004   coinliker                Member              2         
463354    coupable                 Sr. Member          2         
1760060   cryptobaro               Full Member         2         
2323298   cryptofarid10            Member              2         
27470     cygan                    Legendary           2         
85033     d5000                    Legendary           2         
1223580   DanielRR1997             Member              2         
509189    dannybrown               Hero Member         2         
901661    Darker45                 Hero Member         2         
1325560   Denlv                    Member              2         
2049993   DoriangrayTW             Member              2         
2615217   DragonDance              Member              2         
2373346   DTalk                    Member              2         
1168192   dushanya                 Member              2         
1759251   Dzeronimo                Full Member         2         
2312909   epidemia                 Full Member         2         
1888186   Eric01120                Member              2         
314792    examplens                Legendary           2         
1208052   frankbitcoin             Sr. Member          2         
75953     goddog                   Member              2         
1076069   guelmi92                 Full Member         2         
1053119   Halab                    Staff               2         
1827294   Husna QA                 Hero Member         2         
2204241   ICOEthics                Sr. Member          2         
885730    ihnattm                  Sr. Member          2         
1167826   JohnSilver               Sr. Member          2         
319562    JohnUser                 Hero Member         2         
2313339   Jrashid                  Member              2         
1856852   katanic97                Member              2         
1732244   Keeshan                  Member              2         Banned
1082600   kenzawak                 Hero Member         2         
1288254   Komodor                  Newbie              2         
1806798   kusanagi01               Jr. Member          2         
805820    Lafu                     Legendary           2         
7779      layer1gfx                Legendary           2         
1091302   libert19                 Full Member         2         
2344286   Little Mouse             Full Member         2         
176461    Lydian                   Hero Member         2         
2456348   mahmuterdem              Jr. Member          2         
23092     malevolent               Staff               2         
1867778   mamad.sky                Member              2         
787736    marlboroza               Legendary           2         
1067296   marv1n                   Full Member         2         
1162086   maxweel                  Member              2         
1973597   mbsyahia                 Member              2         Banned
962182    mela65                   Sr. Member          2         
98639     Melnik                   Legendary           2         
103262    mike0182                 Full Member         2         
1135313   moneva                   Member              2         
502133    nara1892                 Hero Member         2         
2445907   nicunicu                 Jr. Member          2         Banned
64400     nikkus                   Legendary           2         
221114    Noolz39                  Hero Member         2         
1115212   nuna                     Member              2         
1268845   Oygen                    Member              2         
18312     phantastisch             Legendary           2         
112493    Pmalek                   Legendary           2         
985133    rebel92                  Sr. Member          2         Banned
512663    Redones                  Sr. Member          2         
904446    RuslanFork               Sr. Member          2         
2647304   Ryutaro                  Member              2         
975910    Saint-loup               Hero Member         2         
1232646   salavat111               Member              2         Banned
1735080   SergiuDemerji            Member              2         
2426786   ShadowPresidentOfUkraine Jr. Member          2         
1215351   Slavyanskiy              Member              2         Banned
2151185   slocker                  Full Member         2         Banned
2067609   spatialiste              Member              2         
2033265   SuperTA                  Sr. Member          2         
679341    TheFuzzStone             Legendary           2         
35        theymos                  Administrator       2         
863921    timotron                 Sr. Member          2         
916376    Ukraine2020              Sr. Member          2         Banned
1321484   unihamburg               Member              2         Banned
64734     vitruvio                 Sr. Member          2         Banned
903830    vlad2323                 Sr. Member          2         
2088368   Vs225655                 Member              2         
125677    Waldschrat2              Full Member         2         
1925737   wwhity                   Member              2         
897509    xtraelv                  Hero Member         2         
1069571   yazher                   Sr. Member          2         
909172    yla1974                  Sr. Member          2         Banned
140827    yogg                     Legendary           2         
1194518   Yuliya2404               Member              2         Banned
1109190   zickle                   Full Member         2         
1920279   zimochka                 Member              2         Banned
Note: Not all post are necessarily written in the local language.
full member
Activity: 416
Merit: 125
<…>
When I created the OP, I thought it was not easy to be merited outside one’s, let’s call it, comfort zone (or subsection). As such, I went for a boolean approach, to list whether people that were merited on multiple boards, which was also the basis for the Merit Matrix later on.

Nevertheless, a 10 merit minimum per merited board is indeed interesting, and the numbers shrink in accordance to the difficulty of the task. For comparison reasons, I’ve therefore added a tab called “Number of Merited Subsections per User (+10 Merits)” on the OP Google Sheet link, which displays the list with the above criteria (count of subsections where the profile obtained at least 10 merits).

As you mentioned, your profile goes from being merited on 10 subsections to 4 (mine goes from 12 to 5, and the top case, @suchmoon goes from 20 to 14). Still pretty good for many of the listed cases …

https://docs.google.com/spreadsheets/d/1CFMvMD4lDMnnkxWl9p02k0ZoJW044eRY4EGEqkYd-8I/edit?usp=sharing
   well I was thinking it does help to speak multiple languages .if you are fluent in three languages getting merits In two local boards should be easy. Then of course english as your third language makes for a lot of subsections to post.
legendary
Activity: 2268
Merit: 16328
Fully fledged Merit Cycler - Golden Feather 22-23
<…>
When I created the OP, I thought it was not easy to be merited outside one’s, let’s call it, comfort zone (or subsection). As such, I went for a boolean approach, to list whether people that were merited on multiple boards, which was also the basis for the Merit Matrix later on.

Nevertheless, a 10 merit minimum per merited board is indeed interesting, and the numbers shrink in accordance to the difficulty of the task. For comparison reasons, I’ve therefore added a tab called “Number of Merited Subsections per User (+10 Merits)” on the OP Google Sheet link, which displays the list with the above criteria (count of subsections where the profile obtained at least 10 merits).

As you mentioned, your profile goes from being merited on 10 subsections to 4 (mine goes from 12 to 5, and the top case, @suchmoon goes from 20 to 14). Still pretty good for many of the listed cases …

https://docs.google.com/spreadsheets/d/1CFMvMD4lDMnnkxWl9p02k0ZoJW044eRY4EGEqkYd-8I/edit?usp=sharing

Getting 10+ merits on as many boards as possible is definitely my new year’s resolution for 2020.
legendary
Activity: 2338
Merit: 10802
There are lies, damned lies and statistics. MTwain
<…>
When I created the OP, I thought it was not easy to be merited outside one’s, let’s call it, comfort zone (or subsection). As such, I went for a boolean approach, to list whether people that were merited on multiple boards, which was also the basis for the Merit Matrix later on.

Nevertheless, a 10 merit minimum per merited board is indeed interesting, and the numbers shrink in accordance to the difficulty of the task. For comparison reasons, I’ve therefore added a tab called “Number of Merited Subsections per User (+10 Merits)” on the OP Google Sheet link, which displays the list with the above criteria (count of subsections where the profile obtained at least 10 merits).

As you mentioned, your profile goes from being merited on 10 subsections to 4 (mine goes from 12 to 5, and the top case, @suchmoon goes from 20 to 14). Still pretty good for many of the listed cases …

https://docs.google.com/spreadsheets/d/1CFMvMD4lDMnnkxWl9p02k0ZoJW044eRY4EGEqkYd-8I/edit?usp=sharing
sr. member
Activity: 1050
Merit: 416
Buy Bitcoin
Things that standout:

a)   158 (27 last time) people have been merited on 10 or more subsections. That is a very difficult achievement, which implies a good knowledge in multiple areas as well as communication skills. This feat is in the hands of the following:
Code:
user_id   Name                          nSubSections
1235090   akhjob                       10
The list with the actual subsections where the above have been merited can be found here:
https://docs.google.com/spreadsheets/d/1CFMvMD4lDMnnkxWl9p02k0ZoJW044eRY4EGEqkYd-8I/edit?usp=sharing (second tab).
Each person has his own mix of subsections that contribute to his total received sMerit with different weight. I’ve included the column PMerit (percentage of Merit) to show this.I've now extended this information (on the Google Sheet) to all merited profiles, not just those listed here.

I'm very much happy and surprised to see my name on the list. So, I checked my stats in your spreadsheet and saw that I got merited in the following subsections - Altcoin Discussion (9), Announcements (Altcoins) (2), Bitcoin Discussion (2), Bitcoin Development & Technical Discussion (3), Economics (36), Marketplace (27), Trading Discussion (1), Indian (26), Beginners & Help (5) & Meta (94)

As you can see, most of my merits came from Meta, Economics(WO), Marketplace and Local(India) Boards that's only 4 subsections. Earning 1 or 2 merit in each section is considered as a easy task for most in the list. So I would suggest that you exclude subsections were the earned merits are less than 10 so that we could get a list of users who are truly excelling in all subsections. PS: Just my thoughts  Smiley
legendary
Activity: 2338
Merit: 10802
There are lies, damned lies and statistics. MTwain
<...>
Back in August 2018, you were merited on 6 different subsections (I went through the Google Sheet I created back then:
https://docs.google.com/spreadsheets/d/1EzhU2vE5oRxPaVi8-2Cw7wb4CzoG5H1TY26uNcD8Cas/edit#gid=588590585).
Now, as you say, the spectre has more than doubled, reaching 13 subsections in total. Not bad right? …

If you want to check it out every now and then, one option is to see it here (updated weekly):
https://public.tableau.com/shared/GYDTZ3T36?:display_count=y&:origin=viz_share_link.
The bottom left of the screen displays the Received Subsections mentioned in the OP, but it allows us to see a bunch of other interesting stuff too (awarded merits to 16 different subsections – excluding Deleted – and so on).
legendary
Activity: 4256
Merit: 8551
'The right to privacy matters'
I’ve updated this OP, which was elaborated in August 2018,.recalculating all the data, and additionally included the merit matrix by rank. All with data is now as of 20/12/2019.

In order to allow comparison between then and now, I’ve archieved the old version of the OP here: http://archive.ph/R2owd

Note: I've finally gone with updating the OP, rather than creating a new one.


hmm i missed this back in august.

i wondered if my number rose to 13 from

whatever number it was when you did it in august.

I know I post like mad.

I know I have finally earned 1000 merits. first 1000 was air dropped.

I really did not think I would be in 13 subsections.

I thought I would be 9 or 10 tops. Nice read. Thanks.
legendary
Activity: 2338
Merit: 10802
There are lies, damned lies and statistics. MTwain
I’ve updated this OP, which was elaborated in August 2018,.recalculating all the data, and additionally included the merit matrix by rank. All with data is now as of 20/12/2019.

In order to allow comparison between then and now, I’ve archieved the old version of the OP here: http://archive.ph/R2owd

Note: I've finally gone with updating the OP, rather than creating a new one.
legendary
Activity: 2338
Merit: 10802
There are lies, damned lies and statistics. MTwain
<...>
Good, me too! (I want to see the changes in distrubutions and so on). I've got, in theory, a couple of weeks of holidays now, so I should be able to squeeze some linear time to do it amidst a bunch of hefty social opulent food & turrones coated family reunions.

The Dashboard is ideal to update information easily, and is great for information that does not require too much explanation (Tableau does allow for collaborative commenting, but that’s on the paid version). It’s also really nice for slicing and dicing information. The Correlation Matrix is likely pretty static from week to week, and may be better as a one-shot task every now and then. The OP did include some lists though which may be interesting to consider placing on the Dashboard. I’ll give it a thought after creating the analysis. Thanks for the suggestion though.
legendary
Activity: 2268
Merit: 16328
Fully fledged Merit Cycler - Golden Feather 22-23
I am still interested.
It’s ok to post it on a new thread with some comment, instead of a tab in the merit dashboard.
I proposed this alternative as I thought it would have been easier for your!
legendary
Activity: 2338
Merit: 10802
There are lies, damned lies and statistics. MTwain
<...>
If your still interested I can take a look into it over the xmas holidays. I've located all the stuff I used at the time, so that's part of the path covered. It would be better if I do it on another thread, and I would like to see it broken down by rank too.

Note: I’m not sure (yet) about putting it on the Dashboard. Perhaps after the analysis, since an analysis should try to provide some comments with insights, which a bunch of numbers often lack if just presented.
legendary
Activity: 2310
Merit: 4085
Farewell o_e_l_e_o
Bumping this very old thread from the depths.
Is it time for an update?
Or is it possible to add as a new tab on The Merit Dashboard?
It is for your local board (Italian). See
legendary
Activity: 2268
Merit: 16328
Fully fledged Merit Cycler - Golden Feather 22-23
Bumping this very old thread from the depths.
Is it time for an update?
Or is it possible to add as a new tab on The Merit Dashboard?
legendary
Activity: 2338
Merit: 10802
There are lies, damned lies and statistics. MTwain
<…>
Thanks there. Yes, the key to it all is to put some constant effort into it all. Most unmerited lower ranks simply do not make an effort, and therefore will remain hopelessly meritless. Where you post, with what content, style, section/subsection and so on are secondary to willing to spend some time thinking things through. Their loss …

The core of it all is the merit file which is officially released by the forum every Friday by the forum, and that contains data relative to all the sMerit TXs that have taken place over the last 120 days (https://bitcointalk.org/merit.txt.xz). Since the data within is limited to 120 days, I (and some other forum members) have my own cumulative database, keeping track of all sMerit TXs since day one.
The file is insufficient on its own to perform this analysis, so in addition, I scrape the site to download merited profiles and some information related to the merited messages. That all adds up to a bit of weekly time, but it allows me to have a decent enough base to perform this kind of analysis and update the Merit Dashboard  and  User Merit Network weekly.
legendary
Activity: 3052
Merit: 1273
Hey Ddmr, couldn't stop myself from bumping this.
Thanks for the most interesting data I've been trying to find all over the forum. Everything is now clear and easy to find that which section/subsection is really worth working on to get better number of merits, especially for newbies (not saying that sections other than those are not useful but they probably need proper knowledge and skills as you said, because as an example here, it is mostly tough for a native French speaker to earn a merit in an Indonesian local board if they ever try to do so.) While people roam here and there trying to post shit and increase their post count thereby trying to increase their merits with it, they should put in some effort to be really eligible for those merits. Some user here said that you really work hard for your merits and earn them, everyone should take a morale from this post and put in a lot of efforts and make us give that damn merit to them. I have a question here that I'm all confused about, where did you get all the data that you used in order to create these tabs with such a well-determined explanation? I mean from where did you get those numbers of users and their merits based on which you made all your calculations?
legendary
Activity: 2338
Merit: 10802
There are lies, damned lies and statistics. MTwain
<…>This is probably because in some countries the penetration of internet access is much higher. In the USA it is 85%, in Africa it is only 10%.[/url]
But the expectation is that the world will be completely connected in the next 10 years. That is, if the Bitcoin-related communities know how to open the doors to these people, instead of always trying to close them, we would have disruptive power over the banks. This has always been the concept of Bitcoin intended by Satoshi. And opening doors does not mean talking: learn English or disappear. It means allowing the growth of these communities.
Actually, you’ve got a good point there which may be interesting to talk about as a topic on it’s own (on Serious Discussion or so). It’s not just access to internet that is required. Things like a higher awareness of crypto (not just bounties for a quick buck please), mainstream/easy usage and a rather more stable price in relation to FIAT would play their role.
Many that are in crypto from, let’s say, first world countries, can play by the "invest what you can afford to lose" rule. This non-written rule may not seem as appealing to many non-first world citizens, as crypto is too volatile and what they can afford to lose is rather measly if anything at all.

In relation to the forum, the impression I get is that it’s members are not against non-english people coming along for the ride, but rather that if their command of English is not good, then communication suffers for both parties (poster and readers), and thus it is "better" if they stick to their local board. As seen on the list in the OP, half of the top forum members that get merited across multiple subsections do so also on a local section (and are probably non-native English in origin, but have good command of it).
Signature Campaigns sometimes exclude local boards, driving people to go out of their natural language local board and write in very broken English on the general boards.
Ideally, local boards should boost over the next few years (I guess Forum management will have this in mind), and further thought has to be put to them at some point.

In terms on local merit sources, we’ve discussed this on Meta a few times recently, but to sum-up the way I see it, if a local community finds that it is well under merited, they need to shout-out with something solid in order to be heard (i.e. longish lists with un/under merited posts). They can also apply to become a merit source for the local board. Perhaps the main problem will be precisely being capable (from the Forum’s management side) of telling how un/under-merited the local board is, due to the language barrier (from management to local).
From my local forum's perspective, I don't find too many unmerited posts in my areas of interest, buy they are often undermerited (i.e.1 sMerit instead of 3 or 5), and generally merited by 1 or 2 people at most.

<…> Regarding locals, I haven' t take a look at my local yet (Spanish, I guess), so I don' t know what is going on there. <…>
We’re in luck here, for there is a stat for our local Spanish forum specifically: Análisis del sMérito en el foro en español.

member
Activity: 80
Merit: 71


The results in that post are very interesting, as we can see which subsections have the highest/lowest merit to post ratio. But again, context is important when interpreting the data. For example, Meta (0,3) , Serious Discussion (0,349)  and Bitcoin Development & Technical Discussion (0,286) have the largest merit/post ratio, but the degree of effort in the post there in general terms are noticeable. Market Place Altcoins (0,001) and Altcoin Discussion (0,009) has one of the lowest ratios, which is no surprise.

Thanks for that. Somehow, I feel quite a relief once I understood that, in fact, the Serious Discussion board is the most merited per number of posts then. As discussed on the other thread, the information actually is showing up that the merit system is working just fine, for the more merited boards are those in which the people put more effort or help others, or create some good informative posts.
Regarding locals, I haven' t take a look at my local yet (Spanish, I guess), so I don' t know what is going on there. I will and see, then, so I can obtain a complete vision, of course with my language limitation, of what you guys are pointing-up about local' s problems.
Anyway, thanks again for the patience and for being so kind when explaining to me the information. As said I'm quite brute when reading stats.
Pages:
Jump to: