farcasterunion

How many of these folks cast consistently? (5 days in a row!)

11,558

How many of them are considered quality casters? (Level 2 spam labels)

2,110

https://dune.com/queries/4742322
Epic query by @mvr

@mvr even added a graph to it. I have looked at the multiple correlations with regression analyses.
- When I calculate the multiple correlation of 0 or 2 with other variables, they appear to have no significant correlation between 0 en 2. These are clearly different groups.
- In a regression analysis between 1 and the other variables (0, 2 and time), all variables are significant and 2 plays a greater role than 0.
This seems to indicate that in label 1 the chance of spammy accounts is greater than for non-spammy accounts (a factor of 5.6).
Strictly speaking, too simplistic, but still an indication in my opinion.

hamst.art $hamster /hamster 
martinvr.eth 
deploy.degen.eth

Interests: crypto, economics, TA & blockchain related innovations | Links: https://linktr.ee/cryptonjal

Just to make sure, I mean that my analyse is simplistic.

Just have to say that label 1 is not much better than knowing nothing at all. In the complete data set with all casters, the factor between label 0, and 2 is 3.6.

This is some fabulous analysis! Thank you for sharing!

1000 $DEGEN