Join Conrad Carlberg for an in-depth discussion in this video Run the Desc function on numeric variables, part of R for Excel Users.
- [Voiceover] I have already drawn R's attention…to the fact that the desk tools contributed package…exists and it's been loaded into memory…and I've also set the options…so that the scientific notation…and the thousands separator are as we want them.…I have already loaded desk by way of the library command…and I've already set the options…for the formats.…The desk function in the desk tools contributed package…can also provide you with useful charted information…about the distribution of variables…and we'll be taking a look at that in this video…so at this point we can go ahead…and call the desk function once again…and we'll specify d.pizza as the data frame…and use the dollar sign…so that we can specify the temperature variable…and this time we'll use the plot it keyword…to call for charts…and we'll set it to true…and we get these charts that show up…in response to the plot it keyword.…
We get first the density curve…that shows the relative frequency…of observations at different levels…of the numeric variable.…
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