Cookies help us display personalized product recommendations and ensure you have great shopping experience.

By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData CollectiveSmartData Collective
  • Analytics
    AnalyticsShow More
    big data and customer service outsourcing
    How Data Analytics Improves Customer Service Outsourcing
    18 Min Read
    How a Specialized Marketing VA Improves Campaign Analytics
    How a Specialized Marketing VA Improves Campaign Analytics
    11 Min Read
    New Data Analytics Breakthroughs Give eCommerce Startups a Fighting Chance
    New Data Analytics Breakthroughs Give eCommerce Startups a Fighting Chance
    6 Min Read
    How Data Analytics Is Reshaping Patient Financing Decisions
    How Data Analytics Is Reshaping Patient Financing Decisions
    13 Min Read
    business using business intelligence
    How to Use a Competitive Intelligence Dashboard to Turn Market Data Into Smarter Marketing Decisions 
    9 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-25 SmartData Collective. All Rights Reserved.
Reading: A video introduction to R for Excel users
Share
Notification
Font ResizerAa
SmartData CollectiveSmartData Collective
Font ResizerAa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Big Data > Data Mining > A video introduction to R for Excel users
Data MiningPredictive Analytics

A video introduction to R for Excel users

DavidMSmith
DavidMSmith
3 Min Read
SHARE

D Kelly O’Day has posted a great video introduction to R over at Charts and Graphs. At just nine minutes long it’s a short and sweet overview of R, and focuses on a practical example of writing a script in R to generate a chart.This was an inspired choice of example for Excel users. One of the loudest defenses I hear from Excel users relates to the charting capabilities: it’s really hard to convince an experienced Excel user to give up the point-and-click capabilities to edit charts in Excel for a programming environment. But what I like best about this…

D Kelly O’Day has posted a great video introduction to R over at Charts and Graphs. At just nine minutes long it’s a short and sweet overview of R, and focuses on a practical example of writing a script in R to generate a chart.

This was an inspired choice of example for Excel users. One of the loudest defenses I hear from Excel users relates to the charting capabilities: it’s really hard to convince an experienced Excel user to give up the point-and-click capabilities to edit charts in Excel for a programming environment.  But what I like best about this video is that it shows the parallel process in R. You create a simple chart first (in this case, a scatterplot) and then add modifications incrementally: add a title, change a scatterplot to a line plot, change the color of the line, etc. The difference is that in R you do this by modifying a script rather than pointing and clicking. But unlike in Excel, you can then reuse those modifications to recreate your customized chart any time, or even just recycle parts of the script for your next custom chart.  For me, this is the real time-saver of using R instead of Excel for charting: the extra time it takes to write the script far outweighs the time saved the next time I need to to a similar chart.

More Read

First Results from the Predictive Analytics in the Cloud Survey
Predictive Tourism: The Merger Of Big Data In Travel Industry
Promoting Poor Data Quality
The New Way to Segment For a 6x Greater Return
Implications of the Organization of Data
The only downside is that the video is available in WMV format only.  Great for Excel users on Windows, but it made it tricky to view on my Mac. A high-def YouTube version would be most welcome.

D Kelly O’Day: Getting Familiar with R’s User Interface. (Windows Media File, 6.3Mb.)

From http://blog.revolution-computing.com/
TAGGED:excelrvideo
Share This Article
Facebook Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

big data and customer service outsourcing
How Data Analytics Improves Customer Service Outsourcing
Analytics Exclusive
The End of Unstructured Marketing: Forcing Generative AI into Strict HTML Schemas
The End of Unstructured Marketing: Forcing Generative AI into Strict HTML Schemas
Artificial Intelligence Exclusive
How a Specialized Marketing VA Improves Campaign Analytics
How a Specialized Marketing VA Improves Campaign Analytics
Analytics Exclusive
ai marketing tools
The 9 AI Tools Marketers Use to Create Images and Video in 2026
Artificial Intelligence Exclusive

Stay Connected

1.2KFollowersLike
33.7KFollowersFollow
222FollowersPin

You Might also Like

Because it’s Friday: United States of Obesity

3 Min Read

Interview – Anne Milley, SAS, Part 1

15 Min Read

REvolution Computing training series announced

3 Min Read

Reminder: High-Performance Backtesting Webinar Tomorrow

2 Min Read

SmartData Collective is one of the largest & trusted community covering technical content about Big Data, BI, Cloud, Analytics, Artificial Intelligence, IoT & more.

AI and chatbots
Chatbots and SEO: How Can Chatbots Improve Your SEO Ranking?
Artificial Intelligence Chatbots Exclusive
ai chatbot
The Art of Conversation: Enhancing Chatbots with Advanced AI Prompts
Chatbots

Quick Link

  • About
  • Contact
  • Privacy
Follow US
© 2008-26 SmartData Collective. All Rights Reserved.
Welcome Back!

Sign in to your account

Username or Email Address
Password

Lost your password?