1861 search results for "excel"

The difference between R and Excel

February 22, 2017
By
The difference between R and Excel

If you're an Excel user (or any other spreadsheet, really), adapting to learn R can be hard. As this blog post by Gordon Shotwell explains, one of the reasons is that simple things can be harder to do in R than Excel. But it's worth perservering, because complex things can be easier. While Excel (ahem) excels at things like...

Read more »

Three Tips for Training Excel Users in R

February 10, 2017
By
Three Tips for Training Excel Users in R

by Merav Yuravlivker, CEO of Data Society “I’m not a coder” or “I was never good at math” is a frequent refrain I hear when I ask professionals about their data analysis skills. Through popular culture and stereotypes, most people who don’t have a background in programming automatically underestimate their ability to create amazing things

Read more »

BERT: a newcomer in the R Excel connection

November 30, 2016
By
BERT: a newcomer in the R Excel connection

A few months ago a reader point me out this new way of connecting R and Excel. I don’t know for how long this has been around, but I never came across it and I’ve never seen any blog post or article about it. So I decided to write a post as the tool is really

Read more »

Introduction to R for Excel Users

May 3, 2016
By
Introduction to R for Excel Users

When all you have is a hammer...Engineers and scientists, Excel is the hammer. #Rstats is a toolkit. Here's an intro.

Read more »

Scoring R Models with Excel

March 17, 2016
By
Scoring R Models with Excel

by Joseph Rickert In a post late last year, my colleague and fellow blogger, Andrie de Vries described enhancements to the AzureML R package that makes it easy to publish R functions that consume data frames as Azure Web Services. A very nice consequence is that it is now feasible to develop predictive models in R and enable the...

Read more »

Few steps to connect R with Excel: XLConnect!

March 9, 2016
By
Few steps to connect R with Excel: XLConnect!

XLConnect allows to create a formatted spreadsheet usable as a dynamic report of the R analysis. Discover how to link R and Excel with just a few steps The post Few steps to connect R with Excel: XLConnect! appeared first on MilanoR.

Read more »

Using Excel versus using R

January 15, 2016
By

Here is a video I made showing how R should not be considered “scarier” than Excel to analysts. One of the takeaway points: it is easier to email R procedures than Excel procedures. Win-Vector’s John Mount shows a simple analysis both in Excel and in R.

Read more »

Slides of 10+ excellent tutorials at KDD 2015: Spark, graph mining and many more

August 17, 2015
By
Slides of 10+ excellent tutorials at KDD 2015: Spark, graph mining and many more

by Yanchang Zhao RDataMining.com I attended the KDD 2015 conference in Sydney last week. At the conference, there were more than 10 tutorials and I went to two of them, which are 1) Graph-Based User Behavior Modeling: From Prediction to … Continue reading →

Read more »

3D Graphing & Maps For Excel, R, Python, & MATLAB: Gender & Jobs, a 3D Gaussian, Alcohol, & Random Walks

July 1, 2015
By
3D Graphing & Maps For Excel, R, Python, & MATLAB: Gender & Jobs, a 3D Gaussian, Alcohol, & Random Walks

Showing a third dimension on a flat computer screen is usually hard. Plotly’s interactive 3D graphing changes that. You can zoom, toggle, pan, rotate, spin, see data on the hover, and more. In this post we’ll make 3D graphs with our APIs fo...

Read more »

R: the Excel Connection

May 29, 2015
By
R: the Excel Connection

By Andy Nicholls, Head of Consulting As companies increasingly look beyond the scope of what is logistically possible in Excel more and more companies are approaching Mango looking for help with connecting to Excel from R. With over 6,500 packages … Continue reading →

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)