Sheldon himself isn't real but he is a decent representation of otherwise smart people who turn a practically Canadian level of dumb when it comes to the math on aliens. Drake's equation, cited by the character Sheldon, is real. It is meant to convince people that there must be millions of alien cultures out there, but in fact it proves there are none.