Monthly Archives October 2007

Quick tip - how to extract audio from youtube videos

Here is a quick tip for extracting audio from youtube videos. I assume you have a reasonably recent linux distribution. (Things might work on other operating systems as well as all the applications that I mention below are ported to other operating systems)
Step 1: Download the flash video file from youtube. Either use greasemonkey script [...]

Some excel functions

I keep forgetting some of the functions in excel and it is embarrassing to search for the same things every time.
PERMUT(n, r) = nPr = n! / (n - r)!
COMBIN(n, r) = nCr = n!/((n-r)!r!)
FACT(n) = n! = 1*2*3*…*n
BINOMDIST(s, n, p, cumul) Probability that there will be exactly s successes in n trials, each [...]