1240 search results for "excel"

Econometrics and R

August 30, 2010
By
Econometrics and R

Econometricians seem to be rather slow to adopt new methods and new technology (compared to other areas of statistics), but slowly the use of R is spreading. I’m now receiving requests for references showing how to use R in econometrics, and so I thought it might be helpful to post a few suggestions here. A

Read more »

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 »

Do It Yourself Climate Trend Analysis

August 19, 2010
By
Do It Yourself Climate Trend Analysis

This post describes my consolidated global temperature anomaly CSV file that users can easily download to Excel or R to do their own trend analysis. Do It Yourself Global Temperature Anomaly  Trend Analysis As I wrote in my July 10, … Continue r...

Read more »