1695 search results for "excel"

Dream Team – combining Tableau and R

November 3, 2013
By
Dream Team – combining Tableau and R

Last quarter was a bit too busy to write some new blog post because of a new job. And changing the job often come along with changing the tools you work with. That was my way to Tableau. Tableau is one of the new stars in the BI/Analytics world and definitely worth a look. The people at Tableau...

Read more »

Data Preparation – Part I

October 31, 2013
By
Data Preparation – Part I

The R language provides tools for modeling and visualization, but is still an excellent tool for handling/preparing data. As C++ or python, there is some tricks that bring performance, make the code clean or both, but especially with R these choices can have a huge impact on performance and the “size” of your code. A The post Data...

Read more »

R and my divorce from Word

October 30, 2013
By
R and my divorce from Word

Being in grad school, I do a lot of scholarly writing that requires associated or embedded R analyses, figures, and tables, plus bibliographies. Microsoft Word makes this unnecessarily difficult. Many tools are now available to break free from the tyranny of Word. The ones I like involve writing an article in markdown format, integrating all data preparation,...

Read more »

Poisson regression fitted by glm(), maximum likelihood, and MCMC

October 29, 2013
By
Poisson regression fitted by glm(), maximum likelihood, and MCMC

The goal of this post is to demonstrate how a simple statistical model (Poisson log-linear regression) can be fitted using three different approaches. I want to demonstrate that both frequentists and Bayesians use the same models, and that it is the fitting procedure and the inference that differs. This is … Continue reading →

Read more »

Scaling up text processing and Shutting up R: Topic modelling and MALLET

October 29, 2013
By
Scaling up text processing and Shutting up R: Topic modelling and MALLET

In this post I show how a combination of MALLET, Python, and data.table means we can analyse quite Big data in R, even though R itself buckles when confronted by textual data.  Topic modelling is great fun. Using topic modelling I have been able to separate articles about the 'Kremlin' as a) a building, b) an international actor c) the...

Read more »

Montreal R User Group – Dr. Ramnath Vaidyanathan on his rCharts package

October 27, 2013
By
Montreal R User Group –  Dr. Ramnath Vaidyanathan on his rCharts package

Monday, October 28, 2013. 6:00pm at Notman House 51 Sherbrooke W., Montreal, QC. We are very pleased to welcome back Dr. Ramnath Vaidyanathan for a talk on interactive documents as it relates to his excellent rCharts package. Bringing a laptop to follow along is highly encouraged. I would recommend installing rCharts prior to the workshop. library(devtools) pkgs <- c(‘rCharts’, ‘slidify’, ‘slidifyLibraries’) install_github(pkgs, ‘ramnathv’, ref

Read more »

How to switch from spreadsheets to R for data analysis

October 25, 2013
By

To take a spreadsheet beyond what it's designed for — data presentation, summarization and simple calculations — into the world of complex data analysis can be an alluring prospect. But it can also be dangerous: consider these examples of spreadsheet errors that led to monumental financial losses, mistaken government policies, and even the wrong drugs being given to cancer...

Read more »

Pricing Reinsurance Contracts

October 24, 2013
By
Pricing Reinsurance Contracts

In order to illustrate the next section of the non-life insurance course, consider the following example1, inspired from http://sciencepolicy.colorado.edu/…. This is the so-called “Normalized Hurricane Damages in the United States” dataset, for the period 1900-2005, from Pielke et al. (2008). The dataset is available in xls format, so we have to spend some time to import it, > library(gdata) >...

Read more »

NESSIS 2013: The future of sports statistics is here!

October 24, 2013
By
NESSIS 2013: The future of sports statistics is here!

by Joseph Rickert We have been following sports statistics regularly on the Revolutions Blog with quite a few sports related posts this year. In one post I did back in April about the Latham R package for baseball statistics I speculated on how baseball was poised to move from Moneyball style predictive analytics to real-time descriptive stats by showing...

Read more »

Update for Backtesting Asset Allocation Portfolios post

October 23, 2013
By
Update for Backtesting Asset Allocation Portfolios post

It was over a year since my original post, Backtesting Asset Allocation portfolios. I have expanded the functionality of the Systematic Investor Toolbox both in terms of optimization functions and helper back-test functions during this period. Today, I want to update the Backtesting Asset Allocation portfolios post and showcase new functionality. I will use the

Read more »

Sponsors

Never miss an update!
Subscribe to R-bloggers to receive
e-mails with the latest R posts.
(You will not see this message again.)

Click here to close (This popup will not appear again)