Discover and read the best of Twitter Threads about #FAKEDATA
Most recents (2)
All right folks, quick stats lesson. (Thread)
There's a meme floating because of this article 👇 that "China must be faking their Coronavirus data because you never see R^2 = 0.99 with real data".
barrons.com/articles/china…
There's a meme floating because of this article 👇 that "China must be faking their Coronavirus data because you never see R^2 = 0.99 with real data".
barrons.com/articles/china…
If you run a regression of cumulative deaths reported in China in the first half of February, and look at the residuals, you get a magic parabola like this: 
"Oh my gosh," you say to yourself. "FAKE DATA!!!" So you add in a quadratic term to the regression, and get R^2 = 0.9999 or something like that. You've cracked the code! It's a smoke signal from a Chinese researcher! Time to call Barron's!
TIL there's lots of ways of #seeding #fakedata into a #SQL #database. You can either
A. Seed it with purely random data all the way
B. Seed it with realistic data
C. Seed it initially with random data, but tie that data into other tables realistically
A. Seed it with purely random data all the way
B. Seed it with realistic data
C. Seed it initially with random data, but tie that data into other tables realistically
When you seed a database, you start off with enum (that's like a dictionary that doesn't change in size). If you look at a database schema, it's the tables that are only connected one time.
Then you focus on tables that have only have 1 foreign key tied, tied to an enum
Then you focus on tables that have only have 1 foreign key tied, tied to an enum
Example with a basic HR database schema. Start seeding the outlier tables first, starting with the bottom-left most and bottom-right most tables, followed by bottom-middle.
