Join Conrad Carlberg for an in-depth discussion in this video Analyze one numeric variable by another in Excel, part of R for Excel Users.
- [Voiceover] I'd like to give you a sense of what…the same kind of analysis looks like in Excel,…as compared to what it looks like in R.…In the most recent three videos we've looked at…analyzing a numeric variable,…why another numeric variable,…a numeric variable by a factor,…and one factor by another factor.…So, we'll take a look at those three analyses…in the next two or three videos…so you can compare what you get…from each application…and what it takes to get the analysis…in each application.…
Let's start out with the by numeric analysis that we did…when we correlated the temperature of a pizza…on its arrival with the number of delivery minutes…associated with each delivery.…So, to get the numeric by numeric correlation analysis…and the accompanying scatter chart,…we'll call the Desc function,…and, of course, I've already used the library command…to make the DescTools package available…and I've set the options for the formatting.…So, we'll call for temperature…and then tilde and delivery minutes.…
And we'll tell Desc which data frame…
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