Update your data science skills by learning R. Learn how common data analysis and statistics operations are run in Excel vs. R and how to move data back and forth between each program.
- [Voiceover] Hi I'm Conrad Carlberg and welcome to R for Excel Users. Excel is a powerful tool for statistics but it has its limits. R is a dedicated statistical package that's constantly growing, adding new capabilities. One problem it hasn't yet solved is that it can be tough to learn. I know plenty of people and you probably do too, who use Excel to do basic and intermediate statistical analysis. Many of them say that they'd like to add R to their toolkit but the documentation on R is terse.
It's dense and hard to follow. That puts people off. In this course I'll show you how to install R, how to install the desk tools package, which includes plenty of statistical tools, how to move data easily back and forth between Excel and R, how to arrange univariate, one variable at a time analyses in both Excel and R. How to run by variat analyses to assess the possible effect of one variable on another again in both Excel and R.
This course is intended as an introduction to R. For those who are already familiar with Excel and already have some exposure to basic statistics. Let's start by installing R on your machine and putting a new tool in your kit.
Much of the course focuses on how crucial statistical tasks and operations are done in R—often with the DescTools package—as contrasted with Excel's functions and Data Analysis add-in, and then scales up from there, showing R's more powerful features. Conrad Carlberg will help you effectively toggle between both programs, moving data back and forth so you can get the best of both worlds. Start by learning how to install R and the DescTools package, and the data files used in all the hands-on exercises. Then learn about calculating descriptive statistics on numeric and nominal variables, and running bivariate analyses in both Excel and R. In the "Next steps" video, Conrad breaks down the pros and cons of Excel vs. R and provides tips for learning more about statistics in each application.
- Installing R and DescTools
- Descriptive statistics in Excel and DescTools
- Moving data between R and Excel
- Running the Desc function
- Bivariate analysis in R and Excel