1214 search results for "excel"

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 »

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 »

Excellent R Code Format Package

Excellent R Code Format Package

I have been looking for this type of package for several days, and luckily found it today. Unquestionable R is powerful, however, R programming is unfriendly as far as I concern, mainly due to the lack of format shortcut, which makes the R codes rathe...

Read more »

Long R, Short Excel

October 29, 2009
By
Long R, Short Excel

R is very speedy statistical package that's like an F-18A Hornet, versus Excel which is like a paper airplane. R is professional sports, Excel is Pop Warner. R is Mona Lisa, Excel is stick figures. R is ... okay, you get the idea. I'm long R, and short...

Read more »

RExcel

October 13, 2009
By

I am not a fan of MS Windows software. However, the reality is that majority of people use it and it is often easier for me to live with this than to convert the sorounding souls. Additionally I am find ing out lately that majority of my favourite open...

Read more »

RExcel

October 13, 2009
By

I am not a fan of MS Windows software. However, the reality is that majority of people use it and it is often easier for me to live with this than to convert the sorounding souls. Additionally I am find ing out lately that majority of my favourite open...

Read more »

Export Data Frames To Multi-worksheet Excel File

October 6, 2009
By
Export Data Frames To Multi-worksheet Excel File

A few weeks ago I needed to export a number of data frames to separate worksheets in an Excel file. Although one could output csv-files from R and then import them manually or with the help of VBA into Excel, I was after a more streamlined solution, as I would need to repeat this process

Read more »

How to Import MS Excel Data into R

September 26, 2009
By
How to Import MS Excel Data into R

s Sir Francis Bacon said, “Histories make men wise; poets witty; the mathematics subtile; natural philosophy deep; moral grave; logic and rhetoric able to contend.” And Windows stupid. He should have added the last sentence if he were a Windows user in this age. 1. Avoid Using M$ Excel A lot of R users often ask this question:

Read more »