Join Conrad Carlberg for an in-depth discussion in this video Control the numeric format of output in R, part of R for Excel Users.
- [Voiceover] It's time to take a closer look…at some of the statistics that you can get…from the DescTools contributed package,…in particular by means of a function…in the DescTools package called Desc,…short of course, for descriptive.…But first we need to draw R's attention…to the fact that we already have the DescTools package…available here, and then we'll use the library command…to get that done.…And specify DescTools.…And now we can use the Desc function,…and we'll do that simply by entering its name.…
And we'll want to specify a variable now…that we want to analyze.…So I'm going to specify the temperature variable.…And the way to do that in the Desc function…is to specify the name of the dataframe…that it belongs to.…And if you recall, that's d.pizza.…And then we'll specify that we're going…to next provide the name of a variable.…And we do that with the dollar sign…and then type the name of the variable itself.…You'll find that all of the variables…in the pizza.dataframe have names that are all lowercase.…
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