1377 search results for "Excel"

US House Election Results Visualized Five Ways

August 30, 2010
By
US House Election Results Visualized Five Ways

The Democratic major-party vote share of US House elections 2002-2008 visualized 5 different ways.

Read more »

Graphing Highly Skewed Data

August 30, 2010
By
Graphing Highly Skewed Data

Graphing data with a few outliers is challenging, and some solutions are better than others. Here is a comparison of the alternatives.

Read more »

Patrick Burns is blogging

August 28, 2010
By
Patrick Burns is blogging

Patrick Burns is the author of several helpful R resources, including A Guide for the Unwilling S User, The R Inferno, and S Poetry. He also wrote one of my favorite critiques of Microsoft Excel: Spreadsheet Addiction. His writing is witty, entertain...

Read more »

Oh (de)bugger!

August 26, 2010
By
Oh (de)bugger!

By number of questions asked, R passed MATLAB for the first time on Stack Overflow today. Thus it seems an appropriate time to write my first R-based post. This post concerns what to  do when your R-code goes pear shaped. Back in June there were a couple of very good videos on R debugging that

Read more »

What the hell is a variance matrix?

August 25, 2010
By
What the hell is a variance matrix?

When I first came to finance, I kept hearing about “risk models”. I wondered, “What the hell is a risk model?” Of course, I didn’t say this out loud — that would have given the game away.  My wife has strict instructions that she is to be the only one to know that I’m an … Continue reading...

Read more »

How Safe is Your Money?

August 24, 2010
By
How Safe is Your Money?

The FDIC regularly publishes a Failed Bank List and related statistics.  This post uses data in the original XLS from the FDIC web site which is formatted for human consumption to produce the charts below using R.  Note that 2010 data be...

Read more »

Packing everything into a data.frame

August 23, 2010
By
Packing everything into a data.frame

OK, I know I talk about R too much, but I like R, so I’m going to talk about it some more. Common situation: repeat a procedure many times; each time generates some large wadge of awful-structured data, and in … Continue reading →

Read more »

GRASS Can Make Pretty Maps

August 23, 2010
By
GRASS Can Make Pretty Maps

I have posted a couple examples in the past on the topic of high quality map production from GRASS GIS-- usually via the Generic Mapping Tools. I am not sure why, but I have previously avoided using the traditional cartographic output module that is bu...

Read more »

Rose plot using Deducers ggplot2 plot builder

August 16, 2010
By

The (excellent!) LearnR blog had a post today about making a rose plot in ggplot2. Following today’s announcement, by Ian Fellows, regarding the release of the new version of Deducer (0.4) offering a strong support for ggplot2 using a GUI plot builder, Ian also sent an e-mail where he shows how to create a rose plot using the new...

Read more »

Charting the performance of cricket all-rounders – IT Botham

August 16, 2010
By
Charting the performance of cricket all-rounders – IT Botham

Cricket is a sport that generates a large volume of performance data and corresponding debate about the relative qualities of various players over their careers and in relation to their contemporaries. The cricinfo website has an extensive database of statistics for professional cricketers that can be searched to access the information in various formats. As an

Read more »