1227 search results for "excel"

XLConnect 0.1-5

July 11, 2011
By
XLConnect 0.1-5

Mirai Solutions GmbH (http://www.mirai-solutions.com) is pleased to announce the availability of XLConnect 0.1-5. This release adds the following new features: Support for setting/getting cell formulas. See methods set/getCellFormula. Support for setting/getting the force formula recalculation flag on worksheets. See methods … Continue reading →

Read more »

Creating 3D geographical plots in R using RGL

July 11, 2011
By
Creating 3D geographical plots in R using RGL

I've been playing around with the rgl package in the last week, as part of an ongoing quest to come up with nice-looking (but more importantly, useful) data vizualisations. It's a nice little package, and once you've run through the excell...

Read more »

Scary Derivatives and Scary XML in R

July 7, 2011
By
Scary Derivatives and Scary XML in R

I need some new R skills, and there is no better motivation to learn XML in R than one of the scariest financial datasets out there—the US Department of the Treasury Office of the Comptroller of the Currency (OCC) Quarterly Derivatives Report. I’ll...

Read more »

GLMM Hell

July 7, 2011
By
GLMM Hell

I have been starting to analyze some data I have of repeated counts of salamanders from 5 plots over 4 years. I am trying to develop a predictive model of salamander nighttime surface activity as a function of weather variables. The repeated counting l...

Read more »

Things I would tell a budding bioinformatician to learn.

July 7, 2011
By

I recently read Ewan Birney's blog post, which I found echoed a lot of my own thoughts about the use of statistical in computational biology. I thought I would compile my own similar list but for bioinformatics  / computational biology in general. I have not been and in the field as long as Ewan and I certainly still...

Read more »

Use R!

July 7, 2011
By
Use R!

In short: R is a free intuitive programming language that is used by practitioners in a plethora of academic disciplines. Therefore, it is on the cutting edge, and expanding rapidly. It creates stunning visuals, works seamlessly together with LaTeX, has really good online documentation and the community is unparalleled. A week...

Read more »

Color reduction of an image – and Warholize?

July 5, 2011
By
Color reduction of an image – and Warholize?

There seems to be several methods out there for reducing the colors in an image. I became interested in this after pondering how this is done in the excellent freeware program IrfanView. Unfortunately, their method is not described anywhere that I coul...

Read more »

ARMA Models for Trading, Part VI

July 5, 2011
By
ARMA Models for Trading, Part VI

All posts in this series were combined into a single, extended tutorial and posted on my new blog. In the fourth posting in this series, we saw the performance comparison between the ARMA strategy and buy-and-hold over the last approximately 10 years. Over the last few weeks (it does take time, believe me) I back-tested

Read more »

Even faster linear model fits with R using RcppEigen

Linear regression models are a major component of every applied researcher's toolbox. Obtaining results more quickly is therefore of central importance, particularly when many such models have to be fit. Common examples in this context are Monte Carl...

Read more »

The R apply function – a tutorial with examples

July 2, 2011
By

Today I had one of those special moments that is uniquely associated with R. One of my colleagues was trying to solve what I term an 'Excel problem'. That is, one where the problem magically disappears once a programming language is employed. Put simpl...

Read more »