- 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
Skill Level Intermediate
- [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.