Join Conrad Carlberg for an in-depth discussion in this video Analyze one numeric variable by another in R, part of R for Excel Users.
- [Voiceover] The Desc function in the DescTools…contributed package is capable of doing more…than just the simple univariate,…one variable at a time analyses…that we've looked at so far.…In particular, it's good at doing bivariate analyses…depending on the level of measurement…that's applied to the variables that you choose.…You can get, for example, if you've got…two numeric variables to analyze together,…you'll get correlation coefficients.…If you want to analyze a numeric variable…such as temperature by a factor such as driver…in the Pizza file, then you'll get a breakdown…of items such as the mean value of temperature…by each value of the factor variable, driver in this case.…
And you'll also get a contingency table…if you want to analyze one factor in terms…of another factor, for example, the area delivered…by the driver who made the delivery.…That is normally referred to as a contingency table.…So you can get all three of those kinds of analyses,…and we'll take a look at them before…we're through with this series of lessons.…
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