1288 search results for "Excel"

Third year wrap-up

July 23, 2012
By
Third year wrap-up

July marks the end of three years of blogging for us. By our count, we've posted 121 examples across the first three years. We aim to be helpful and interesting.As always, it's hard to get a sense of our readership. At the time we wrote this, Feedbur...

Read more »

XLConnect 0.2-0

July 23, 2012
By
XLConnect 0.2-0

Mirai Solutions GmbH (http://www.mirai-solutions.com) is very pleased to announce the release of XLConnect 0.2-0, which can be found at CRAN. As one of the updates, XLConnect has moved to the newest release of Apache POI: 3.8. Also, the lazy evaluation … Continue reading →

Read more »

Time-based internet advertising

July 20, 2012
By
Time-based internet advertising

Last week it was announced that Facebook is rotating its ads after a certain time of exposure. Sid Suri, Preston McAfee, and Dan Goldstein's research may have been the source of this idea. In 2011 and 2012 the trio published a couple papers putting for and improving the idea. The post Time-based internet advertising appeared first on Decision Science...

Read more »

Volatility and Correlation

July 19, 2012
By
Volatility and Correlation

The implied option volatility reflects the price premium an option commands. A trader’s profit and loss ‘P&L’ from hedging option positions is driven to a large extend by the actual historical volatility of the underlying assets. Thus as option premiums … Continue reading →

Read more »

Best of Axys, R, d3.js, and HTML5

July 19, 2012
By
Best of Axys, R, d3.js, and HTML5

Axys, R, d3.js, and HTML5 all offer incredibly powerful tools for investment management and reporting, but they are not set up to synergistically interact to fill each other’s gaps and leverage each other’s strengths.  In my ideal scenario, Ax...

Read more »

50 Shades of Grey Wordcloud

July 17, 2012
By
50 Shades of Grey Wordcloud

Sometimes you just want to see what all the fuss is about. File this under the 'because I can' category: I proudly (?) present - a wordcloud produced from the text of E. L. James' "50 Shades of Grey".For a book which is getting all this press about bei...

Read more »

A simple Approximate Bayesian Computation MCMC (ABC-MCMC) in R

July 15, 2012
By
A simple Approximate Bayesian Computation MCMC (ABC-MCMC) in R

Approximate Bayesian Computing and similar techniques, which are based on calculating approximate likelihood values based on samples from a stochastic simulation model, have attracted a lot of attention in the last years, owing to their promise to provide a general statistical technique for stochastic processes of any complexity, without the limitations that apply to “traditional”…

Read more »

Importing public data with SAS instructions into R

July 10, 2012
By

Many public agencies release data in a fixed-format ASCII (FWF) format. But with the data all packed together without separators, you need a "data dictionary" defining the column widths (and metadata about the variables) to make sense of them. Unfortunately, many agencies make such information available only as a SAS script, with the column information embedded in a PROC...

Read more »

introduction to R: learning by doing (part 1)

July 9, 2012
By
introduction to R: learning by doing (part 1)

Geography is often about statistics as it is the basis for fast exchange of information: providing a mean and standard deviation to the audience is often much easier then showing raw data: Learning a script language for this purpose can be a hard-ass work. But I think it is more often a need of practice.

Read more »

ggplot2 – much easier with JGR and Deducer

July 7, 2012
By
ggplot2 – much easier with JGR and Deducer

In the last R-User meeting in Cologne, we had a discussion about using ggplot2 – and I gave a short introduction of how to use ggplot2 with JGR and Deducer. Basically, JGR is a Graphical User Interface for R, and Deducer is a kind of “data analysis plugin”, that also comes with a so-called “plot

Read more »