Join Conrad Carlberg for an in-depth discussion in this video Exercise files, part of R for Excel Users.
- [Voiceover] If you access the exercise files, you'll be able to follow along with what I'm doing onscreen. Within the exercise files folder, you'll find a folder for each chapter and for each video within the chapter, if there is a file to go along with it. Now for most of this series of lessons, we'll be using data that's provided by the R application, and which you can use to follow along with the content on the screen.
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