Author Archives: Jesper

Creating a boxplot in Excel 2007 with negative values in dataset

September 16, 2008 Jesper Excel

Keywords: Excel, boxplot, box plot, stem and leaf plot, box and whiskers plot, negative values Dowload: 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 … Continue reading →

Popularity: 9% [?]

5 comments

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

September 15, 2008 Jesper MySQL

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 … Continue reading →

Popularity: 10% [?]

Comments Off

Creating a simple histogram in Excel 2007

May 27, 2008 Jesper Excel

Keywords: histogram, normal distribution, Excel 2007, column chart Version: Should work with any version. Tested with Excel 2007. This article contain a quick tutorial on how to create a simple histogram in Excel 2007, to visualize for example student test … Continue reading →

Popularity: 39% [?]

12 comments

Quality control chart for Excel 2007

May 26, 2008 Jesper Excel

Download: QC chart for Excel 2007 / 2003 (downloaded 3525 times) A couple of years ago I created a very simple QC-chart to keep track if instrument performance over periods of time. The chart fetches the usual data from user … Continue reading →

Popularity: 12% [?]

3 comments

Integrating a forum with your WordPress installation

April 1, 2008 Jesper Blogging etc, Wordpress

Traditionally it has been quite hassle to integrate a forum to a wordpress powered site, using a number of such bridge hacks to integrate phpBB and SMF I know how much work and trouble it can be; if you even … Continue reading →

Popularity: 8% [?]

Comments Off