Join Conrad Carlberg for an in-depth discussion in this video Run the Desc function on nominal variables, part of R for Excel Users.
- [Voiceover] The desc function that turned out…all of this distributional information…on the numeric variable also works with factors,…and one of the factors in the pizza data set…is the driver variable, the last name…of the person who drove the truck that delivered the pizza,…so let's take a look at what's available for you there.…D-E-S-C, and then the name of the data frame…and dollar sign driver this time.…
Again, the variables in the pizza data frame…are all lowercase, and once again,…we have 1209 whole cases in the data frame.…We have only five not applicable values this time,…so we have a valid n of 1204,…seven unique values, seven levels,…and there are duplicate entries,…as you would expect with a factor.…And here we've got the different levels…of the factor there, really just the driver's last name,…and the raw frequency and the percent of cases…for each level, the cumulative frequency,…and the cumulative percent for each level.…
So it's fairly simplistic, but it does…give you a breakdown of each level for the factor.…
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