1137 search results for "excel"

XLConnect – A platform-independent interface to Excel

August 31, 2011
By
XLConnect – A platform-independent interface to Excel

XLConnect is a comprehensive and platform-independent R package for manipulating Microsoft Excel files from within R. XLConnect differs from other related R packages in that it is completely cross-platform and as such runs under Windows, Unix/Linux and Mac (32- and 64-bit). Moreover, it … Continue reading →

Read more »

Migrating from SPSS/Excel to R, Part 2: Working with Packages

July 17, 2011
By
Migrating from SPSS/Excel to R, Part 2: Working with Packages

In this post, I cover an important aspect of using R that users of SPSS/Excel won’t be familiar with: working …Continue reading »

Read more »

Migrating from SPSS/Excel to R

July 10, 2011
By
Migrating from SPSS/Excel to R

In this post, I give an outline for those interested in migrating from using SPSS and Excel for data processing/analysis …Continue reading »

Read more »

Yet another way to use R in Excel for .NET programmer

July 6, 2011
By
Yet another way to use R in Excel for .NET programmer

I wrote the article whose title is "Another way to use R in Excel for .NET programmer" last night.In that article, We need to use IDE to write C# program.On ther other hand, Excel-DNA give us easier way to create XLL.Let me show you one ...

Read more »

Another way to use R in Excel for .NET programmer

July 5, 2011
By
Another way to use R in Excel for .NET programmer

As you know, RExcel give us a way to combine R with Excel.But, It just bothering to install some COMs and maybe not be programming but excel manipulation!If you are a .NET programmer, there is another way to call R from Excel.I would like to ...

Read more »

Using R in Excel

Got to know a very cool tool to use R in Excel named RExcel, basically it provides an integration solution such that users can get data, run command in Excel the same way as in R, which is presumably good and convenient to present results to your coll...

Read more »

Example 8.37: Read sheets from an excel file

May 11, 2011
By
Example 8.37: Read sheets from an excel file

Microsoft Excel is an awkward tool for data analysis. However, it is a reasonable environment for recording and transfering data. In our consulting practice, people frequently send us data in .xls (from Excel 97-2003) or .xlsx (from Excel 2007 or 201...

Read more »

How to backtest a strategy in Excel

March 14, 2011
By

(This is a guest post by Damian from Skill Analytics and ETF Prophet) Let me start by saying that I’m not an expert in backtesting in Excel – there are a load of very smart bloggers out there that have, as I would say, “mad skillz” at working with Excel including (but not limited to) Michael Stokes over...

Read more »

How to backtest a strategy in Excel

March 14, 2011
By

(This is a guest post by Damian from Skill Analytics and ETF Prophet)Let me start by saying that I’m not an expert in backtesting in Excel – there are a load of very smart bloggers out there that have, as I would say, “mad skillz” at working with Excel including (but not limited to) Michael Stokes over...

Read more »

Moving from Excel to R

March 5, 2011
By

This first post of the Backtesting in Excel and R series will provide some resources to help smooth the transition from the familiarity and comfort of Excel to the potentially strange and intimidating world of R.I made my voyage from Excel to R more th...

Read more »