1270 search results for "excel"

Calling Minimum Correlation Algorithm from Excel using RExcel & VBA

September 26, 2012
By
Calling Minimum Correlation Algorithm from Excel using RExcel & VBA

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

Read more »

Importing data directly from MS Excel

August 10, 2012
By
Importing data directly from MS Excel

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

Read more »

Data Mining In Excel: Lecture Notes and Cases

July 10, 2012
By
Data Mining In Excel: Lecture Notes and Cases

by Yanchang Zhao, RDataMining.com It is a 270-page book on data mining with Excel. It can be downloaded as a PDF file at http://citeseerx.ist.psu.edu/viewdoc/download?doi=10.1.1.83.1393&rep=rep1&type=pdf. Below is its table of contents. - Overview of the Data Mining Process - Data Exploration … Continue reading →

Read more »

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

July 2, 2012
By
MatLab, SAS, STATA, SPSS, Excel users: Try R, damn it!

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

Read more »

multiplicitiesoffreedom demonstrates Chaos Theory in Excel. If…

June 29, 2012
By
multiplicitiesoffreedom demonstrates Chaos Theory in Excel. If…

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 ...

Read more »

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...

Read more »

Pasting Excel data into R on a Mac

June 2, 2012
By
Pasting Excel data into R on a Mac

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

Read more »

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 →

Read more »

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...

Read more »

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

May 11, 2012
By
An embarrassing admission; Copy pasting tables with text containing spaces from Excel to R

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 →

Read more »