February 22, 2008

Calculating the median of a MySql table column

My staff are amazingly efficient at automating the various slices and dices of data for me. They like to do it in SQL scripts, MySql in specific, and as a consequence, the data I want to look at is automatically generated every night into various MySql tables. I, in turn, have my own scripts, and ye old console, to extract the information I want. However, one issue that bugged me early on was getting at the median of a set of numbers.

Continue reading "Calculating the median of a MySql table column" »

February 20, 2008

How to browse the Internet perfectly anonymously

Related website: Pippini.com
"Tell me Mr. Jones," said the public prosecutor, "All the evidence points to the fact that you were indeed contemplating the murder of your lover on that night. Were you not? Remember that you are under oath, and that your polygraph results have betrayed your innermost thoughts. You had the motive, ability and, in your judgment, sufficient anonymity to carry out the macabre act with impunity. And I admit that were it not for this mass of incontrovertible evidence we uncovered by following your intent, you might well have succeeded in pulling the wool over our eyes! Is this not what you are thinking?"
There it is. Fragment from a mystery novel as it were, when you gauge your own mental reaction as you read the passage, you will find it to be a clear example: Most reasonable people would not think twice about sanctioning techniques, including the administration of polygraph tests, that authorities may use to probe into and conclude on the conents of that innermost repository of our private thoughts - our mind. Yet, it appears unreasonable to most of us if authorities claim to have the ability, much less to use it, to determine probable intent in criminal behavior from one's behavior on the Internet. Is the Internet that different in people's perceptions as a place where absolute anonymity may be enjoyed regardless of disposition and intent? Indeed, do people honestly believe it is ok to probe one's mind, but not one's online behavior?

Continue reading "How to browse the Internet perfectly anonymously" »

January 10, 2008

Governor Schwarzenegger helps to make Bay Area housing affordable

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.

January 8, 2008

On Data Analysis

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.

Continue reading "On Data Analysis" »

August 18, 2007

Fixing Fontconfig on Linux with strace (Unable to load default config file)

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)" »

August 3, 2007

Communing with Carrots

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?

Continue reading "Communing with Carrots" »

July 29, 2007

A Metaphorical Essay - Google News, Air, and TCP/IP

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" »

July 22, 2007

Ratatouille (2007)

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.

Continue reading "Ratatouille (2007)" »

Enjoyed, and plan to review

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.

Jun '07

  1. Mr and Mrs Iyer (2002)
  2. Castle in the sky (1986)
  3. Contact (1997)

...


November 18, 2006

The CPA Nube Lube Tube

Grease to ease the transition of newbies into the fascinating world of Cost-Per-Action (CPA) advertising

First appeared in San Jose Mercury News Forums, Nov 18, 2006.

Consider the following ad, the likes of which we are all only too used to routing promptly into our spam buckets.

"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.

Continue reading "The CPA Nube Lube Tube" »

Powered by
Movable Type 3.35