Join Conrad Carlberg for an in-depth discussion in this video Move data from Excel to R, part of R for Excel Users.
- [Voiceover] You may recall this worksheet…from an earlier lesson.…It contains this list of height and weight values…and, notice that I have selected the entire list.…That's going to be an important point…a little bit later on in this lesson.…What I want to show you here…is how to download the package that will support…the transfer or export of this data…from Excel directly into R.…And, the way that we go about that…involves adding another…from the contributed packages list in R,…so we'll go over to R and we'll choose Packages…and Install Packages.…
Again, we need to specify which mirror we want to use…and, again, I like to use the HTTP Mirrors…and the USA California mirror in particular…because that's what I'm closest to,…and, now that I've decided which mirror to use,…we're going to need to find the package called…RDCOMClient,…and this is an alphabetical list,…so it's a good bit further down in the list…than DescTools was.…But, I know I've found the r's,…and, I've gone too far,…so come back up, and there's RDCOMClient.…
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