Noise canceling headphones

Some 9 months ago I left my noise canceling headphones on a plane. Since then I’ve though I’d just self suffer for my carelessness, and I’d decided the next set I would buy would be Bose. The problem is, Bose make two brands, The over ear 2 model and the on ear 3 model . I could never decide which one to order without first trying. They do offer a return policy but that’s just more hassle.

So eventually I get to the Bose store in the Time Warner building at Columbus Circle , try them both, can’t really decide either way and settle for the over ear 2. Some facts in my decision is basically the case is the same size, the 2 model has a recharger, while the 3 uses AAA batteries.

I then head of the the NY apple store for some smaller purchases, and I notice that all the sample headphones for the iPods are Bose. You can even buy them there. So treking across NY in the rain could have been easier?

In other Apple news, the MacBook Air is not as light as I would have thought, being 3 pounds, still it’s a cool geek thing and I was tempted even though I’d just just purchased my own Macbook recently. And of course they released a new macbook yesterday as well. Go figure.

Tagged with: Apple MacBook

Producing IQR and Outlier statistics with SQL

The interquartile range (IQR) measures the spread of the middle 50% of a distribution — the distance between the first quartile (Q1) and the third quartile (Q3). Combined with Tukey’s 1.

Producing Mode statistics with SQL

The mode is the value or values that appear most frequently in a dataset. Unlike the mean or median, it applies naturally to categorical and ordinal data — star ratings, product codes, survey responses — and reveals what is most common, not what is average.

Extending MySQL Capabilies with UDFs, Plugins and Components - Part 2

MySQL offers three different approaches to extending the SQL capabilities with the default product you download and install. These are: User Defined Function (UDF) MySQL Manual MySQL Plugin MySQL Manual MySQL Component MySQL Manual In my prior post I provided a new uuidv function that accepted a numeric argument to return a string of the version of UUID specified.