Browsing the blog archives for September, 2008

Generate a heatmap of your site

I stumbled over a couple of very interesting sites today. Have you ever heard of Jacob Nielsen and heatmaps? Sure you have, how would you ever find this post unless you searched for “heatmap”,  right? (I also wrote about heatmaps last year).
Well, heatmaps can give you valuable information about your sites layout. Is it effective? [...]

Popularity: 7% [?]

Creating a boxplot in Excel 2007 with negative values in dataset

Keywords: Excel, boxplot, box plot, stem and leaf plot, box and whiskers plot, negative values
Since my previous articles on boxplots in Excel, Improved advanced box-plot and whiskers chart in Excel and Box plot for Excel 2007, I have recieved a lot of questions on how to do boxplotswith negative values using Excel, since it [...]

Popularity: 11% [?]

Select a random row (like user or post) from your MySQL table

I have beein using all kinds of strange constructs to be able to select a random row (often user or post) from table, and then I stubled over this on sitepoint forums:
SELECT * FROM users WHERE age > 20 ORDER BY RAND() LIMIT1
One simple argument to the query! Awsome. Hope it helps you as much [...]

Popularity: 10% [?]