1812 search results for "Excel"

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 »

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 »

Backtesting in Excel and R

February 17, 2011
By

This post is the introduction to a series that will illustrate how to backtest the same strategy in Excel and R.  The impetus for this series started with this tweet by Jared Woodard at Condor Options.  After Soren Macbeth introduced us, Jare...

Read more »

Good riddance to Excel pivot tables

January 30, 2011
By
Good riddance to Excel pivot tables

Excel pivot tables have been how I have reorganized data...up until now. These are just a couple of examples why R is superior to Excel for reorganizing data:################ Good riddance to pivot tables ############library(reshape2)library(plyr)&nbsp...

Read more »

Predictive Analytics with R, PMML, ADAPA, and Excel

January 7, 2011
By
Predictive Analytics with R, PMML, ADAPA, and Excel

PMML (Predictive Model Markup Language) is the standard language used by all the top analytic vendors (commercial and open-source) to represent predictive models. These include IBM/SPSS, SAS, KXEN, TIBCO, STATISICA, R, KNIME, and RapidMiner (for detail...

Read more »

Databases (SQL, noSQL); Interfacing R with Excel

December 15, 2010
By
Databases (SQL, noSQL); Interfacing R with Excel

Los Angeles R users group Dec. 14 2010 meeting (see meetup info here): 1. A SQL primer for R users – Neal Fultz Video and slides will be available soon 2. R Database Access – Shrikrishna Bhogaonker 3. NoSQL data … Continue reading →

Read more »

Why R is better than Excel for teaching statistics

October 4, 2010
By
Why R is better than Excel for teaching statistics

This was the topic of a recent conversation on the Australian and New Zealand R mailing list. Here is an edited list of some of the comments made. R is free. R is well-documented. R runs (really well) on *nix as well as Windows and Mac OS. R is open-source. Trust in the R software

Read more »

Excel Errors and Other Numerical Nightmares

August 25, 2010
By
Excel Errors and Other Numerical Nightmares

Although I use Excel all the time, and I strongly encourage my students to use it for performance analysis and CaP, I was forced to include a warranty disclaimer in my GCaP book because I discovered a serious numerical error while writing Appendix B. There, my intention was just to show that Excel gives essentially the same results...

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)