- 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
- [Conrad] Excel is a powerful tool for statistics, but it has it's 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. You don't need all the information crammed into the formal documentation, at least not right now. Let's start with the basic skills that you need to leveridge your experience in Excel and start running the more sophisticated analysis that R can provide. I am Conrad Carlberg and I'd like to invite you to join me for my course on LinkedIn Learning where I'll show you how to get started with R and how to get your data back and forth between R and Excel.