Join Conrad Carlberg for an in-depth discussion in this video Analyze a numeric variable against a factor in Excel, part of R for Excel Users.
- [Voiceover] Let's take a look at how we would break…down a numeric variable such as temperature…by a factor such as area,…and we'll do it both in R as we have before,…and in Excel so they're in the position to…compare the two processes.…We'll call the Desc function,…and then we'll specify temperature as the…numeric variable that we want to break down,…and then we'll tell Desc that we want…to break it down by area,…and we do that using the tilde and the name area,…and we'll tell Desc to look for those two variables…in the pizza data frame,…and there's the summary that you may remember.…
It gives us some information on the number of cases…that we've got, the number of missing values,…there are three groups, Brent, Camden, and Westminster,…and it gives us of course the mean, median,…standard deviation and other good stuff.…It also gives us the Kruskal-Wallis rank sum test…which is a non-parametric test of the difference…of the medians in the different cities,…in the different areas rather.…Now, in Excel we would go about it differently…
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