Join Conrad Carlberg for an in-depth discussion in this video Excel's Data Analysis add-in, part of R for Excel Users.
- View Offline
- [Voiceover] I'd like to give you a basis…for a comparison of how Excel…does some fairly standard statistical analyses…of a small data set, and we'll take a look later on…at how R makes the same kinds of analyses.…On the screen that you're seeing right now,…I have a list, what in Excel terms, a list of values.…It's an informal kind of arrangement of numerical values,…in this case with two different variables,…height and weight.…It's typical in a list to have different variables…in different columns and to have…different records in different rows.…
So that's the way that this is set up,…and the way that most people will go…about getting statistics from this list…is by way of worksheet functions.…Now here I have entered the worksheet function…called MIN, and that returns in this case…the minimum value in the range A2 to A21.…And similarly, in this cell, I have the average…of those same values, 69.65.…The good news about worksheet functions…is that they're what's called volatile.…
Notice that the formula that's in cell E3…
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