Join Conrad Carlberg for an in-depth discussion in this video Next steps, part of R for Excel Users.
- [Voiceover] Thank you for joining me…on this brief exploration of some of the differences…between Excel and R as analysis platforms.…My own view is that Excel is a terrific platform…for learning about statistical analysis.…The results of its functions are live,…in the sense that the underlying data can change,…and the results will automatically update.…You can peak in to intermediate calculations…to see what's going on…in what R presents as just a black box.…On the other hand,…R offers analytic tools that are time consuming,…and difficult to create in Excel.…
Some tool's just missing from Excel.…The Queue Distribution is a good example.…Excel has Chi-Square, Beta, F,…and others, but not Queue.…For that, and for other important tools,…you better go to R.…For more information,…you can check out our other courses on statistics,…including the Statistics with Excel series,…and the R Statistics Essential Training course,…which dive further in depth on running analyses…in each respective application.…
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