# 1745 search results for "excel"

## Calling Minimum Correlation Algorithm from Excel using RExcel & VBA

September 26, 2012
By

I want to show the example of calling the Minimum Correlation Algorithm from Excel. I will use RExcel to connect R and Excel and will create a small VBA cell array function to communicate between Excel and R. I have previously discussed the concept of connecting R and Excel in the “Calling Systematic Investor Toolbox

## Importing data directly from MS Excel

August 10, 2012
By

R is great for exploring, analysing and graphing your valuable data. No question about it. Unfortunately though, there’s no base package support for importing data directly from MS Excel. This means that you have to faff about saving it in another format, and THEN import this new file. This just adds another file to your

July 10, 2012
By

## MatLab, SAS, STATA, SPSS, Excel users: Try R, damn it!

July 2, 2012
By

Due to my work with a multitude of statistical packages in my career I may be able to evaluate a lot of them. I’ve first used Excel for my calculations as most of the normal users do. I like the idea behind a spreadsheet and the combination of data and click-to-do functions. Nevertheless I’ve often

## multiplicitiesoffreedom demonstrates Chaos Theory in Excel. If…

June 29, 2012
By

multiplicitiesoffreedom demonstrates Chaos Theory in Excel. If he filled in more initial values, you would see a thick bar—like a picture of white-noise. Butterflies flapping their wings in Vermont to change the wind in Hangzhou? A drop of water on ...

## Make R analysis Modules just like MS Excel Templates: Derivative Calculator study case

June 4, 2012
By

In this video tutorial, it will show you how to make R analysis Modules just like MS Excel Templates using the Building Derivative Calculator app as study case. Let’s say we wanted to know the derivative of tan(x^2 + 3), commonly, we will use th...

## Pasting Excel data into R on a Mac

June 2, 2012
By

When starting out with R, getting data in and out can be a bit of a pain. It should take long to work out a convenient method – depending on what OS you use and what other packages you work with. In my case I prefer to work with Excel spreadsheets (which are versatile and

## Using R.Net in an Excel Add in

May 31, 2012
By

I thought I’d try out R.net and in doing so I have put together a very simple Excel 2007 add in that connects Excel to R. I’m using .Net 4.0 in Visual Studio 2010 pro with the latest commit of R.Net, … Continue reading →

## Excel Import into R without rJava

May 17, 2012
By

In my ongoing quest to webappify various R scripts I discovered that rApache cannot load any R packages that depend on rJava.  For several of the scripts that I've written that grab data out of MS Excel files, and therein use the xlsx package, thi...

## An embarrassing admission; Copy pasting tables with text containing spaces from Excel to R

May 11, 2012
By

I can’t believe I didn’t learn how to do it earlier, but I never knew how to accurately copy tables from excel that had text with spaces in them, and paste into a data frame in R without generating confusion … Continue reading →