Join Conrad Carlberg for an in-depth discussion in this video Analyze a numeric variable against a factor in R, part of R for Excel Users.
- View Offline
- [Voiceover] Let's take a look at how you can use…the Desk function in the Desk Tools package…to break down a numeric variable,…such as the number of minutes it takes…to deliver a pizza,…by a factor, a nominally measured variable,…such as the name of the area to which…the pizza was delivered…and we'll do that by using the desk function again…and just as a reminder, I've already used…the library command to establish for R…that the package that we want to use is Desk Tools…and I've already set the formats…via the options statements.…
So now let's call for delivery minutes…and we'll use, again, the tilde to inform Desk Tools…that we want to break down delivery minutes…by a factor called area, and comma,…and then we'll specify that we want those variables…to come from the pizza data frame…and then press return,…and this is what we get a summary of…the number of cases that are involved in this analysis,…we've got some missing values here…and those, I believe pertain to the grouping variable…area contains 10 not applicable records,…
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