Graphing data with a few outliers is challenging, and some solutions are better than others. Here is a comparison of the alternatives.
878 search results for "excel"
Graphing Highly Skewed Data
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...
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 
Excel Errors and Other Numerical Nightmares
Although I use Excel all the time, and I strongly encourage my students to use it for performance analysis and CaP, I was forced to include a warranty disclaimer in my GCaP book because I discovered a serious numerical error while writing Appendix B. There, my intention was just to show that Excel gives essentially the same results...
Excel Errors and Other Numerical Nightmares
Although I use Excel all the time, and I strongly encourage my students to use it for performance analysis and CaP, I was forced to include a warranty disclaimer in my GCaP book because I discovered a serious numerical error while writing Appendix B. There, my intention was just to show that Excel gives essentially the same results...
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...
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...
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 →
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...
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...
Zero Inflated Models and Generalized Linear Mixed Models with R.
Zuur, Saveliev, Ieno (2012).
