1230 search results for "excel"

Survival skills for today’s analyst

April 21, 2011
By

I suffer a little from the age-old affliction of contrarianism. If a software package is used by the majority of the population, I assume it is flawed, highly limited, and its continued use will ultimately result in the downfall of the human race. Conversely, I am always extremely interested in a piece of software that has spread no further...

Read more »

Spreadsheet errors

April 20, 2011
By
Spreadsheet errors

For my sins, I have done more than my fair share of analysis in Excel. I am quite capable of building and maintaining 130Mb spreadsheets (I had a dozen of them for one client). Excel is pretty much installed everywhere, so it is sometimes the only way to get started getting commercial value of the data in the...

Read more »

Spreadsheet errors

April 20, 2011
By
Spreadsheet errors

For my sins, I have done more than my fair share of analysis in Excel. I am quite capable of building and maintaining 130Mb spreadsheets (I had a dozen of them for one client). Excel is pretty much installed everywhere, so it is sometimes the only way...

Read more »

Spreadsheet errors

April 20, 2011
By
Spreadsheet errors

For my sins, I have done more than my fair share of analysis in Excel. I am quite capable of building and maintaining 130Mb spreadsheets (I had a dozen of them for one client). Excel is pretty much installed everywhere, so it is sometimes the only way...

Read more »

250 years of Bayes’ Theorem

April 19, 2011
By

The Reverend Thomas Bayes died 250 years ago this month. His grave, located near epidemiological centre of excellence St Mary's College, remains a point of pilgrimage for statisticians (of both Bayesian and Frequentist stripes) visiting London to this day. Because since then, Bayes Theorem has been the underpinning of predictive analytics applications from spam detection to medical alerts. There...

Read more »

Using R, Sweave and Latex to integrate animations into PDFs

April 18, 2011
By
Using R, Sweave and Latex to integrate animations into PDFs

The first week of April I attended an excellent workshop on biplots held by Michael Greenacre and Oleg Nenadić at the Gesis Institute in Cologne, Germany. Throughout his presentations, Michael used animations to visualize the concepts he was explaining. He also included  animations in some of his papers. This inspired me to do this post

Read more »

Exporting R graphics as LaTeX code – version 0.6.1 of the tikzDevice package is out

April 17, 2011
By

(Guest post on R-bloggers by Charlie Sharpsteen) Cameron and I are pleased to announce version 0.6.0 of the tikzDevice package which should be available shortly at your local CRAN mirror! The tikzDevice makes it possible to export R graphics as LaTeX code that can be included in other documents or compiled into stand alone figures. The full power of...

Read more »

Pivot Tables and Medians in R

April 16, 2011
By

Pivot Tables are a useful way of aggregating data into the format that you’re after. In this example, I’m going to be using R to pivot some data and calculate medians for me. This is useful because Excel can calculate medians (the =MEDIAN(values)) function, but what it can’t do is calculate medians for Pivot Tables.

Read more »

Historical Sources of Bond Returns with Shiller Data 1919-2011

April 11, 2011
By
Historical Sources of Bond Returns with Shiller Data 1919-2011

And as usual, I always want a longer data set, so after a little playing with R-Excel, we can extend our historical sources of bond returns to 1919.  If nothing else, maybe you can find other uses for the Shiller Dataset in R. From TimelyPort...

Read more »

EC2 AMI for scientific computing in Python and R

April 11, 2011
By

Like many people who crunch numbers frequently, I have increasingly been integrating Amazon’s cloud computing services into my daily workflow. In particular, I have been using their elastic cloud computing (EC2) on a regular basis. The service is an excellent way to offload computationally intensive work from your laptop for literally pennies on the

Read more »