Calculating the median of a MySql table column
Continue reading "Calculating the median of a MySql table column" »
Continue reading "Calculating the median of a MySql table column" »
Continue reading "How to browse the Internet perfectly anonymously" »
In what may be Governor Schwarzenegger's most sympathetic move yet to make housing more affordable for potential home-buyers in California, he does what he can to encourage young Californians to migrate away from the state, thus setting the stage for home-prices to spiral downwards.
With already ailing education budgets slashed even further, convicted criminals let loose to terrorize innocent citizens and 20% of state parks closed, the Governor hopes that more productive Californians will be encouraged to seek domicile in Oregon and nearby states. This calculated and clever move will enable property prices eventually to reach levels where the 22,000 inmates, who will be in dire need of good housing after their early releases, can afford them.
Forget OLAP cubes and pivot tables! As is the case most of the time, 90% of the insight can be gleaned from very simple data plots. To be sure, the remaining 10% does shed valuable new light, but is also orders of magnitude relatively more tedious to distill.
One of my favorite tools for performing quick sanity checks on data and even for inferring high-level trends is a histogram; it simply partitions your data points into a fixed number of buckets, with each bucket holding points that fall within a given range. The resultant bucket sizes are then available to eye-ball, often plotted as bars whose lengths are proportional to the number of elements in the corresponding buckets.
Today, Linux is a beautiful thing and I typically waste no opportunity to evangelize it to friends considering a new desktop purchase. I mean, if the average user today calculates how much of his or her computer time is spent either on-line or within office applications, it seems like common-sense to buy a Linux desktop with Firefox and Open Office rather than buy expensive Microsoft products. Homer Simpson captures the sentiment best in the opening line of the latest Bart Simpson flick. Why would someone pay hard-earned cash to get something we can get for free? We're all giant suckers!
Continue reading "Fixing Fontconfig on Linux with strace (Unable to load default config file)" »
Last weekend, as I was munching away on a sweet home grown carrot from our own backyard, I let my mind wander with the wind and ponder pointless profoundities. An interesting, but totally useless statistical question occurred to me.
That we are all ultimately made of dust from the distant stars is indisputable. But what, I pondered, might be the odds that an atom of carbon in my crunchy carrot was the same atom in a molecule of CO2 I had exhaled earlier?
If you could see the individual molecules of air in a perfectly still room, you would see that the molecules are anything but still. They are moving in all directions, apparently randomly. Each has its own spin, and its own story to tell. Yet the room itself, made up of millions of these molecules, has the picture of perfect calmness as though nothing in it is even stirring. In the calm of this room lies buried the solution to the most pressing problem in objective journalism.
Continue reading "A Metaphorical Essay - Google News, Air, and TCP/IP" »
Yesterday, we decided that my wife and son would go to see Harry Potter, while I would take our daughter Katya, too young for Potter, to see Shrek the third. That we were unaware of Shrek no longer playing in theaters signifies the inordinate infrequency with which we have been to cinemas lately, the last one being the rather unremarkable "Charlotte's Web". This time we were spurred into action by pressure from a long-standing promise we had made to the kids. Since Shrek was out, we decided that Mathangi and Panini (wife and son) would watch Potter and then snack, while Katya and I would snack and watch Ratatouille (in that order to fit slight mismatches in the movie schedules). Unfortunately, Katya was too young for Ratatouille also, for she said there was too much "talking" in the film; but fortunately, I was aged just right for it, or at any rate I enjoyed it so much that this is certainly one for my DVD collection.
The following are films I have enjoyed, and recommend if your persuasion intersects with mine. I hope to write a review someday because the film lets me say something about an issue about which I have strong feelings.
...
First appeared in San Jose Mercury News Forums, Nov 18, 2006.
"The sex of your baby predicted CHEEP! Guaranteed Results. 150% REFUND for wrong predictions"
There you have it - a simple and sweet business plan if ever there was one. But people who ponder can promptly peer past its imposturous garb. This is just gambling in disguise. Suppose the service costs $1.00 and a thousand naive couples paid for it. On average, five hundred of them will receive a refund of $1.50; the rest will presumably be happy to have been told the sex of their baby. Despite the refunds, however, the service provider is $250 better off than she was before, and for no more effort than flipping a coin for each customer. Immediately, one can tell that the scheme is a rip-off, aimed at defrauding innocent parents-to-be of precious baby-dollars.
To the uninitiated, that is exactly how CPA advertising is being framed by ad-networks steeped in profiting from traditional methods: "Give us your ads. We'll show them. You only pay for ads that result in a sale, but not a cent on the rest." On the surface, yes; this does look like a scam. But fortunately, this is not what CPA is about. In fact, CPA represents the exact opposite. CPA ad-networks don't just flip a coin to show an ad. Considerable effort and investment go into determining where each ad is most likely to appeal, and, of course, web real-estate on which to show ads does not come free either. A CPA network will actually "lose" money if you don't make it and therefore it is in their best interest to make sure you are successful.