1470 search results for "Excel"

In case you missed it: April 2013 Roundup

May 13, 2013
By

In case you missed them, here are some articles from April of particular interest to R users: A critique of a SAS whitepaper comparing the performance of SAS, R and Mahout. A video presentation from statistician Tess Nesbitt at UpStream, who uses GAM survival models in R for marketing attribution analysis. The April edition of the Revolution Analytics newsletter....

Read more »

Living it up with computational errors

May 13, 2013
By

How to have a better chance of a good outcome. Making mistakes There’s been a lot of talk recently about data analysis problems with spreadsheets.  If you’ve not stuck your head out of your cave lately, then you can catch some of the discussion by doing an internet search for: Reinhart Rogoff There are several The post Living...

Read more »

The Guerilla Guide to R

May 12, 2013
By

Update: Okay. I've uploaded a new template and things seem to be fine now. Update: I am aware the table of contents is not being displayed in bullet form as I intended. The web template I'm using seems to be buggy. It also seems to think this page is in Indonesian...Working on it! Table of Contents: Reading/Writing Files

Read more »

Reshaping data

May 12, 2013
By

Preparing and reshaping data is the ever continuing task of a data analyst. Luckily we have many tools for it. The default tool in R would be reshape(), although this is so user friendly that a reshape package has been added too. I try to use reshape()...

Read more »

A guide to speeding up R code

May 10, 2013
By

Noam Ross recently shared a very useful guide to speeding up your R code. Get a bigger computer (for example, renting an instance on the Amazon cloud for a few cents an hour) Use parallel programming techniques Using the R byte-compiler Profiling and benchmarking your code Using high-performance packages (like xts, for time series) And lastly, rewriting your code...

Read more »

Computed columns for dataframes

May 8, 2013
By
Computed columns for dataframes

Everyone loves to aggregate data. Everyone loves to create new columns based on other columns. Everyone hates to do the same thing twice. In my continuing work on multilevel view of loss reserving, I reached a point where I realized that I needed a robust mechanism to aggregate computed columns. SQL server and (I’m assuming)

Read more »

Gambler’s Run With Shiny

May 8, 2013
By
Gambler’s Run With Shiny

I finally had an opportunity to play with Shiny, and I am very impressed. I have created a Github Project so head over there for the source code. There are a number of ways to distribute Shiny apps. If you are running R (and mostly likely you are if you are reading this), you can download and...

Read more »

Incomplete Data by Design: Bringing Machine Learning to Marketing Research

May 6, 2013
By
Incomplete Data by Design: Bringing Machine Learning to Marketing Research

Survey research deals with the problem of question wording by always asking the same question.  Thus, the Gallup Daily Tracking is filled with examples of moving averages for the exact same question asked precisely the same way every day. &nb...

Read more »

Google Analytics + R = FUN!

May 5, 2013
By
Google Analytics + R = FUN!

The scope of this post it to show how simple it is to get data out of the Google Analytics and create your own reports (that you hope that they can be semi-automated at least) and you favourite statistical graphs (those that GA is currently missing). As you already know R is a favourite tool ...read more

Read more »

Google Analytics + R = FUN!

May 5, 2013
By
Google Analytics + R = FUN!

The scope of this post it to show how simple it is to get data out of the Google Analytics and create your own reports (that you hope that they can be semi-automated at least) and you favourite statistical graphs (those that GA is currently missing). As you already know R is a favourite tool

Read more »